There are three tracks (beside Project Management) that running in paralel: technological, data and business intelligence. Yes, theoretically it is possible to run them in parallel, but it seems that such practice is quite rare. It would be interesting to hear an example of a True Kimball Project.
Author Archives: dmytro
How to determine BusinessObjects service pack and fix pack
Method 1. Software Inventory Tool The best way to determine the current version is through Software Inventory Tool. It has complete history of your BOE updates. Method 2. CMC Settings If you don't have access to the server with the BOE, you can check the metrics of BusinessObjects servers. Open CMC, go to Settings. In […]
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 […]
Mutual statement calculator
When a group of people participate in an event with shared expenses often people pays in turn. The calculator can help to figure out who owns whom. Russian version English version
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 […]
ForceMerge() example
The Webi document is built on two queries. First query dimensions are Country and Resort: There is only one dimension – Resort in the second query. The queries are merged on Resort. The first table in the result contains expected numbers. While in the second table, sum of Number of guests (565+446+540=1551) is duplicated for […]
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 […]
localhost in QaaWS for Xcelsius dashboards
To allow easy migration of QaaWS from one server to another it is recommended to use localhost instead of server name in QaaWS and in Xcelsius dashboard connection to QaaWS. This however complicates the job of Xcelsius dashboard developer, because reference to localhost will not work for QaaWS connection if he works from his PC […]