How To Create An Attribute Dimension With a Hierarchy From Essbase Studio


How to Create Hierarchy for Attributes from Essbase Studio

The goal is to create a hierarchy for a particular Attribute dimension from Essbase Studio and link it with another dimension at the leaf node.  For example, to accomplish creating an attribute dimension named Population which has a hierarchy. Population should be an attribute for Level 0 (State) in the Market dimension as shown in the screen shot below:

POPULATION attribute dimension

The attribute columns need to be added as a second “chain” to the dimension hierarchy. Then in the Essbase Model properties, click on the attribute in the hierarchy and check the box ‘Essbase attribute for’.

The POPULATION table below is shown in the Essbase Studio mini schema. Note the join between MARKET and POPULATION.

POPULATION in minischema

Data from the POPULATION table:

POPULATION table

Data from the MARKET table showing the POPULATIONID for each STATE. The tables are joined through the POPULATIONID.

Market table with POPULATIONID

Create a hierarchy called Market, and add the base dimension hierarchy columns (REGION.REGION->MARKET.STATE), as well as the attribute hierarchy columns with the level 0 column from the MARKET table. (POPULATION.POPGROUP-> POPULATION.POPULATION->MARKET.STATE)

Market Hierarchy w POPULATION

After creating the cube schema and the Essbase model, open the Essbase Model Properties.  For the POPGROUP in the Market dimension, check the ‘Essbase attribute for ‘STATE’ ‘ box, and type in the name you want for the attribute dimension, in this case ‘Population’.

Model Properties for POPULATION attribute

Close the window and perform a cube deployment.  When you deploy this cube, you will end up with an attribute to the Market dimension called Population, which has two levels.

POPULATION attribute dimension

Thanks,

~KKT~

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s