Rittman Mead - Delivered Intelligence

In the last post we saw how BI EE generates Essbase specific MDX while using Attribute columns for a specific case. In today’s post we shall look at how the new BI EE 11g specific features like Hierarchical columns and Value-Based hierarchies affect the MDX generated. For continuation sake, i have highlighted the case again [...]

If you had gone through my blog series for BI EE 10g and Essbase here, i would have covered the different ways of controlling the BI EE MDX generated for Essbase Sources. With 11g, that too with the introduction of Hierarchical Columns and Value Based Hierarchies, the entire series needs a relook in the context [...]

My latest article for Oracle Magazine is now available online, and this month it’s a joint effort between myself and Venkat. “Using Oracle Essbase Release 11.1.2 Aggregate Storage Option Databases” takes a look at the new calculation capabilities in Essbase 11.1.2, in particular looking at how data can be aggregated, derived and allocated within 11.1.2 [...]

At Rittman Mead, one of the major areas that we’ve been asked to help customers in the past is in the integration between OBIEE 10g and Essbase. OBIEE supports Essbase as a data source, but it’s had a few well-known limitations in the 10g release of OBIEE that have made it hard for certain types [...]

In the last 2 blog entries, i showed how the calculations in ASO work. Today lets look at another new feature in ASO cubes i.e the ability to run allocations directly. In a BSO cube, Allocations and Calculations are all driven through a set of calculation commands. Some Allocation features in BSO can actually be [...]