The more I explore about the multidimensional analytics capability of BI 11g the more I am impressed. I had briefly touched upon moving a row level multidimensional data into a column, in my previous post. Here we will explore more on this capability. We will create a new Request or in 11g terms a “Analysis” [...]
One of the features I was looking forward to in 11g was the enhanced ability of OBI to interpret multi-dimensional data. This is the feature that would help welcome the Essbase users, seamlessly into the OBIEE world as well. The real world interpretation of data as hierarchies can be easily represented and analyzed in this [...]
Another collaborative solution today. Mikhail on the PeopleSoft reporting team had a tough little problem. Those of you that know PeopleSoft, will know that its full of ‘trees’. A very powerful way of building hierarchies for all types of application e.g. financial accounts. However, lots of his customers want to be able to print the [...]
11gR2 introduced a new mechanism to build up hierarchies. I remembered a thread in developpez.net that reveals the dubious implementation of nocycle in 10g. For the CONNECT BY ISLEAF, I have read the technique on amis.nl. Ok, here is my graph The 10g query with o as ( SELECT 'A' obj, 'B' link from dual [...]
In the first part of this series here, i had shown how to go about using the ODI RKM’s from within Warehouse Builder to reverse engineer Essbase metadata. Though i did promise to come back sooner on the rest of the series, a client engagement completely held me away from doing this earlier. Better late [...]
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 [...]
Here we will look at building cube organized materialized views for a relational fact table. The illustration uses the Oracle OLAP 11g Sample Schema and rather than the cube organized materialized views being created via the script in the demo, they will be designed and generated from OWB. The cubes and dimensions designed in OWB [...]
Well it’s early Tuesday morning over in San Francisco and we’re in the middle of a storm. Apparently we’ve got the tail-end of a monsoon coming over from Japan, and coupled with some local bad weather it’s looks like we’re in for a stinker. The local newspaper is reporting where sandbags can be picked up [...]
One of the nice little advantages of using Oracle Essbase Studio is the fact that it manages the relational drill through much better than the Essbase Integration Services. With the advent of Essbase studio, all the metadata for relational drill through is pushed back to the Studio server. So, when one looks at an Essbase [...]
One common issue that gets highlighted when someone uses BI EE is its inability to leverage Parent Child Hierarchies out of the box. 11g release scheduled sometime later next year is supposed to address this seamlessly. Having said that, being consultants ourselves most of the times we find ourselves in situations wherein we would have [...]