OBIEE 11G Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies

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.
Screenshot for Step
3 . Right-click Connection Pool and select Import Metadata to open the Import Wizard.
Screenshot for Step
4 . In the Select Metadata Types screen, accept the defaults and click Next.
Screenshot for Step
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:
Screenshot for Step
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.
Screenshot for Step
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.
Screenshot for Step
11 . Create the following alias for the table: D20 Product
Screenshot for Step
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"
Screenshot for Step
13 . Right-click D20 Product and select View Data.
Screenshot for Step
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

Popular Posts