Dynamic Display Name for Presentation columns

There was a question asked on this post here and I thought of having another post to answers Vik’s question.
Hi carpediemconsulting
Good Artical, Thanks
We have a Similar req at my client, but little bit different.
we have a Dimension, in that we have a hierarchy H1 with Levels, Level1, Level 2 , Level 3 we are implimenting [...]

Dynamic Data security in OBIEE

Here is an interesting scenario that I came across recently. The client has 2 hierarchies based on cost centers, Management and P&L. The business push behind this was that lot of users had dual roles in terms of how they look at expenses. Both the hierarchies had cost center at the lowest level and the [...]

Period Comparison without time series or ago functions.

Recently at a client site we had to connect to some tables in owned by another application and generate some reports for our OBIEE user base. We had no control over the table structures in the external application and we had to generate some time series measures. We couldn’t use the time series wizard or [...]

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 3 Products ranked  [...]

Choose and Indexcol functions in OBIEE

You can use the choose statement to dynamically choose different columns in a request  depending on the group a user belongs to:
Let us look at  the following request:

Based on the USER logging in we need to choose different columns from the EMPLOYEE_HIER table.
We can do this using the CHOOSE function.
The first step is to create [...]