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.
2 .	Rename D20 ProductDim to H20 Product.
3 .	Double-click the H20 Product logical dimension to open the Logical Dimension dialog box.
4 .	On the General tab, select both Ragged and Skipped Levels.
5 .	Click OK to close the Logical Dimension dialog box.
6 .	Expand H20 Product.
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