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:
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.
Data from the POPULATION table:
Data from the MARKET table showing the POPULATIONID for each STATE. The tables are joined through the 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)
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’.
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.