| 1 . | Drag the D20 Product logical table to the Sample Sales subject area in the Presentation layer.  |
|---|---|
| 2 . | In the Presentation layer, rename D20 Product to Products (Ragged) and move Products (Ragged) to appear after Products.  |
| 3 . | Expand Products (Ragged) and notice that the H20 Product logical dimension is automatically added to the Presentation layer.  |
| 4 . | Save the repository and check consistency. Fix and errors or warnings before proceeding. |
| 5 . | Close the repository. Leave the Administration Tool open. |
Test Your Work
| 1 . | Return to Fusion Middleware Control and load the BISAMPLE repository. If you need help, click here to review steps from earlier in this tutorial. |
|---|---|
| 2 . | Return to Oracle BI, which should still be open, and sign in. |
| 3 . | Create the following analysis to test the ragged / skipped level hierarchy: Products (Ragged).Brand Products (Ragged).LOB Products (Ragged).Product Type Products (Ragged).Product Base Facts.Revenue  |
| 4 . | Click Results.  The results display correctly even though there are skipped levels (levels with NULL values) and ragged levels (leaves with varying depth). |
| 5 . | Sign out of Oracle BI. |
No comments:
Post a Comment