Oracle BI EE 10.1.3.3.2 – Handling Attribute Dimensions of Hyperion Essbase 9.3.1 in BI EE
Posted by Venkatakrishnan J on April 15, 2008
One of the dimension types in Hyperion Essbase is an Attribute Dimension. If you are used to Oracle OLAP AWM, Attribute Dimension is nothing but a dimension which maintains all the attributes of different levels in a dimension. Essbase treats all the attributes seperately and one has to model a seperate dimension for handling attributes. Lets start with a simple example of an Attribute Dimension and see how BI EE treats this Dimension. We shall start with the OLAP Model first. In the model, we shall try creating attribute dimension for all the levels in the Product Dimension. Our Product dimension would have a hierarchy as shown below
Product Total ID – Product Category ID – Product Sub-Category ID
Now, we shall treat the following columns Product_Total, Product_Category_Desc and Product_SubCategory_Desc respectively as attributes to the ID columns which make up the above hierarchy. So, in order markup a column as an attribute click on the Dimension in the OLAP Model and go to Edit – Properties – Columns.
Now, save this OLAP Model and in the Metaoutline drag and drop the attribute columns from left frame to the right. This will automatically create attribute dimensions. We would have to double click on each of the columns to assign the level that an attribute is assigned to. For example, in our case, we need to assign PRODUCT_TOTAL to PRODUCT_TOTAL_ID level etc.
Now build this cube and import the cube to BI EE. If you drag and drop the cube to BM layer, you would notice that by default the attributes are not assigned to the specific levels since BI EE currently does not support auto assignment of attributes to their corresponding levels. In order to achieve that we would have to manually assign the attributes to the specific levels in the BM layer.
Lets remove the attribute hierarchies and put all the attributes into a single Logical table as the Product Logical Table. Also, redesign the product hierarchy to include the attribute levels in the hierarchy as shown below (remember, you need to check whether attribute dimension has data properly loaded. Generally when you assign attributes to a specific level the cube is loaded only to that level. There would not be any association between 2 different attributes which you would have to do it manually in BI EE).