Drawing tutor

There are many brain fitness exercises on the web that helps to develop mental skills. There are not that much programs that help to develop visual skills. Well I do not know any of such. The purpose of this program is to develop visual skills. You could also improve your intellectual skills trying to figure […]

Dynamic Formatting in Web Intelligence

You can get the response string to a prompt using Web Intelligence function UserReponse(). However the function returns string value which is formatted according to Web Intelligence preferred locale. To make handling of date strings independent on the locale, dynamic formats can be used. Dynamic Formats in ToDate Function To convert the date prompt string […]

Getting Started with Designer SDK in C#

You will need: BusinessObjects Enterprise XI 3.x: You need BusinessObjects client tools installed on your PC, and a connection to a BusinessObjects server. Visual Studio C#: You can install Microsoft Visual Studio Express from http://www.microsoft.com/express/downloads/. Create new project: File > New Project… > Console Application Add reference to the SDK: Project > Add Reference… > […]

Selectivity and Execution Plan

Cardinality is how many rows should be returned after evaluating predicates. Selectivity is cardinality divided by the total number of input rows. DBMS uses selectivity for choosing the right index. Density is characteristic of data in a column. It is equal to 1 divided by the number of distinct values. Let's consider few examples of […]