OBIEE 11G Create Logical Levels

1 .	Right-click H2 Product and select New Object > Logical Level.
2 .	Name the logical level Product Total .
3 .	Because this level represents the grand total for products, select the Grand total level check box. Note that when you do this, the Supports rollup to higher level of aggregation field is grayed out and protected.
4 .	Click OK to close the Logical Level dialog box. The Product Total level is added to the H2 Product logical dimension.
5 .	Right-click Product Total and select New Object > Child Level to open the Logical Level dialog box.
6 .	Name the logical level Product Brand.
7 .	Click OK to close the Logical Level dialog box. The Product Brand level is added to the logical dimension.
8 .	Repeat the steps to add the following child levels: Product LOB as a child of Product Brand Product Type as a child of Product LOB Product Detail as a child of Product Type Use the screenshot as a guide: