Business Intelligence – Oracle

Oracle BI EE – Overriding Autogeneration of Dimension Level Names of Hyperion Essbase 9.3.1

Posted by Venkatakrishnan J on April 23, 2008

I got a simple question from an user yesterday who basically wanted to know how to have custom names for different levels while importing an Essbase cube. If you are not sure what i mean, look at the screenshot below.


As you see, this is nothing but the sample Demo cube which has been imported into BI EE. If you notice, for the Market Dimension, all the levels have names like Gen1, Market, Gen2, Market etc. The question from the client was how do we make BI EE to extract the names from the cubes themselves rather than manually updating them in BI EE. Hyperion Essbase users would know how to do this very easily since all we would have to do is to update the Generation Names for all the levels in the dimension. But for users who are not aware of what Generation and Levels mean in Essbase, the following screenshot would be useful.


As you see, Generations are nothing but the reverse of a Level. So, in order to import user defined level names into BI EE, we would have to open the outline of the specific cube using Essbase Administration Services. Then right click on the Market Dimension and click on Generations.



Now, specify a name for each level (number for the levels would be in descending order). So, use the names All Markets, Region and City for the 3 Generations.


Save the outline. Now, if you import the cube into BI EE, you would see that the names too get automatically imported.


One Response to “Oracle BI EE – Overriding Autogeneration of Dimension Level Names of Hyperion Essbase 9.3.1”

  1. This is useful. How can I merge my Essbase Cube with my existing BMM which has the details? I have tried adding secondary sources but BMM breaks.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: