Creating Logical Dimensions with Ragged and Skipped- Level Hierarchies

• 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. Create Logical Table and Logical Columns 1 . Drag D20 Product from the Physical layer to the Sample Sales business model in the BMM layer to create a D20 Product logical table. The logical join to F1 Revenue is created automatically based on the join in the Physical layer.

Old Name	New Name
BRAND	Brand
LOB	LOB
PROD_DSC	Product
PROD_KEY	Product Number
Type	Product Type

3 . Rename the D20 Product logical table source to LTS1 Product (Ragged)

Desired to gain proficiency on OBIEE 11g? 
Explore the blog post on OBIEE 11g training online to become a pro in OBIEE 11g 

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	<none>	<none>	<none>
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

For indepth understanding of OBIEE click on

• OBIEE 11g Tutorials
• New Features in OBIEE11g
• Checking Out a Project in OBIEE 11g
• Making Changes to the Repository in OBIEE
• Setting Up a Multiuser Development Environment in OBIEE