OBIEE 11G Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies 2:Create a Ragged/Skipped Level Logical Dimension

Create a Ragged/Skipped Level Logical Dimension

1 . Right-click the D20 Product logical table and select Create Logical Dimension > Dimension with Level-Based Hierarchy to automatically create a logical dimension named D20 ProductDim.
Screenshot for Step
Screenshot for Step
2 . Rename D20 ProductDim to H20 Product.
Screenshot for Step
3 . Double-click the H20 Product logical dimension to open the Logical Dimension dialog box.
Screenshot for Step
4 . On the General tab, select both Ragged and Skipped Levels.
Screenshot for Step
5 . Click OK to close the Logical Dimension dialog box.
6 . Expand H20 Product.
Screenshot for Step
7 . Create the following hierarchy:
Level
Column
Key
Use for Display
Product Total
Product Brand Brand Brand Yes
Product LOB LOB LOB Yes
Product Type Product Type Product Type Yes
Product Product Product Yes
Product Detail Product Number Product Number Yes
Screenshot for Step

No comments:

Post a Comment

Popular Posts