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:
|
No comments:
Post a Comment