To create logical dimensions with ragged and skipped-level hierarchies, you perform the following steps:
- Import Metadata and Define Physical Layer Objects
- Create Logical Table and Logical Columns
- Create a Ragged/Skipped Levels Logical Dimension
- Create Presentation Layer Objects
- Test Your Work
Import Metadata and Define Physical Layer Objects
| 1 . | Open the BISAMPLE repository in offline mode. |
|---|---|
| 2 . | In the Physical layer, expand orcl.  |
| 3 . | Right-click Connection Pool and select Import Metadata to open the Import Wizard.  |
| 4 . | In the Select Metadata Types screen, accept the defaults and click Next.  |
| 5 . | In the Select Metadata Objects screen, in the data source view, expand BISAMPLE. |
| 6 . | In the data source view, select the SAMP_PRODUCTS_DR table for import: |
| 7 . | Click the Import Selected button to move the table to the Repository View. |
| 8 . | Expand BISAMPLE in the Repository View and confirm that the SAMP_PRODUCT_DR table is visible.  |
| 9 . | Click Finish to close the Import Wizard. |
| 10 . | Confirm that the SAMP_PRODUCT_DR table is visible in the Physical layer of the repository.  |
| 11 . | Create the following alias for the table: D20 Product  |
| 12 . | Use the Physical Diagram to create the following physical join for the alias table: "orcl".""."BISAMPLE"."D20 Product"."PROD_KEY" = "orcl".""."BISAMPLE"."F1 Revenue"."PROD_KEY"  |
| 13 . | Right-click D20 Product and select View Data.  Notice there are skipped levels in the hierarchy. For example, brand A - Brand2 has a NULL value for LOB for the product D - Product 8. |
| 14 . | Close View Data. |
No comments:
Post a Comment