Error while Passing Session Variables to Essbase in Evaluate Expression

We can make use of native Essbase Functions using the Evaluate and Evaluate_Aggr Expressions in OBIEE. Let’s first see how we can call an Essbase Function TOPCOUNT from within OBIEE. The TOPCOUNT function returns a set of n elements ordered from largest to smallest, optionally based on an evaluation. For example: To Find the top [...]

Passing Time Series Functions in OBIEE to ESSBASE

In OBIEE we have the AGO and TODATE Time Series Functions in order to compare measures across time periods. Let us see whether we can make use of these functions when using an Essbase Cube as our Data Source. Let us first test out the AGO function. The AGO  function calculates the aggregated value as [...]

Incorporating Attribute Dimensions in Essbase into OBIEE

Attribute dimensions that you define in Essbase are imported into the OBIEE RPD when you import the cube. However, they are not automatically assigned to the correct dimensional level during the import process. Lets us see how we can model attribute dimensions and associate them with the correct level. In this blog we will see [...]

Data Visibility in an OBIEE/Essbase Integrated Environment

In my previous blog we seamlessly integrated an Essbase cube with OBIEE.  In this blog  we will see how a simple data-visibility scheme can be implemented for this OBIEE, Essbase integration. In my SALES_F fact table you can see that every transaction is assigned to one of 5 employees (1 through 5) joined to the [...]

Seamless Integration of OBIEE with an Essbase Cube

In my previous blog we created a simple Essbase cube and also modeled the cube in OBIEE. In this blog I will talk about achieving seamless integration between OBIEE and the Essbase Cube I had created in my previous blog. The purpose is to use the hyperion cube as aggregated data and the actual Oracle [...]