OBIEE 11G Create Logical Levels

1 . Right-click H2 Product and select New Object > Logical Level.
Screenshot for Step
2 . Name the logical level Product Total .
Screenshot for Step
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.
Screenshot for Step
4 . Click OK to close the Logical Level dialog box. The Product Total level is added to the H2 Product logical dimension.
Screenshot for Step
5 . Right-click Product Total and select New Object > Child Level to open the Logical Level dialog box.
Screenshot for Step
6 . Name the logical level Product Brand.
Screenshot for Step
7 . Click OK to close the Logical Level dialog box. The Product Brand level is added to the logical dimension.
Screenshot for Step
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:
Screenshot for Step

No comments:

Post a Comment

Popular Posts