Wednesday, February 3rd, 2010 by Venkatakrishnan J
One of the biggest differences between Essbase and most other reporting/OLAP tools like BI EE/Oracle OLAP etc is in the way Measures are treated(comparison only in terms of data modeling and reporting and not on physical implementation). In Essbase, every data/value(cell) is attributed by a set of dimensions. Even a measure is considered as an [...]
Tuesday, February 2nd, 2010 by Adrian Ward
An in-depth article on the analysis of facts, when those facts are also used as attributes.
Wednesday, January 20th, 2010 by Venkatakrishnan J
Degenerate dimensions are quite common when we do a Data Warehouse implementation. They are nothing but a set of dimensions that can be classified as Fact attributes and are hence maintained in the fact table itself instead of separate dimension tables. One of the key advantages of using Degenerate dimensions is the fact that there [...]
Friday, January 15th, 2010 by Venkatakrishnan J
Ever wondered what is the actual difference between the logical calculated measures in the repository and the native DB calculated measures? I have had this question asked to me quite a few times in the recent past that i thought it made sense to create a separate blog entry for it. The difference between the [...]
Thursday, December 31st, 2009 by Venkatakrishnan J
One of the features that Oracle could add to BI EE, is in opening up the BI Server in the form of updatable APIs. Currently, the biggest stumbling block is if there are any lack of features we will have to completely depend on Oracle to add that feature. I thought Content Accelerator Framework or [...]
