Associate Time Logical Columns with Logical Levels in OBIEE

Logical Levels in OBIEE

1 . Use a different technique to associate logical columns with logical levels. Drag the logical columns from the Time Detail logical level (not from the D1 Time logical table) to their corresponding levels in the H1 Time logical dimension. This is a convenient technique when logical columns are buried deep in the business model.

Logical Column	Logical Level
Per Name Year	Year
Per Name Half	Half
Per Name Qtr	Quarter
Per Name Month	Month
Per Name Week	Week

Your results should look similar to the screenshot:

2 . Delete all remaining columns from the Time Detail level except for Calendar Date so that only Calendar Date is associated with the Time Detail level. Notice that deleting objects from the hierarchy does not delete them from the logical table in the business model.

These core tutorials will help you to learn the fundamentals of OBIEE 11g.  For an in-depth understanding and practical experience, explore "OBIEE 11g Training".

Logical Level	Level Key	Use for Display
Year	Per Name Year	Yes
Half	Per Name Half	Yes
Quarter	Per Name Quarter	Yes
Month	Per Name Month	Yes
Week	Per Name Week	Yes
Time Detail	Calendar Date	Yes

 Create a Logical Dimension for Customer

1 . Use either technique to create a logical dimension with a level-based hierarchy named H3 Customer for the D3 Customer logical table with the following levels, columns, and keys. Hint: Create the levels first, then double-click a logical column to open the Logical Column dialog box and use the Levels tab to associate the logical column with a logical level.

Level	Column	Key	Use for Display
Customer Total	<none>	<none>	<none>
Customer Region	Region	Region	Yes
Customer Area	Area	Area	Yes
Customer Country	Country Name	Country Name	Yes
Customer State	State Province	State Province	Yes
Customer City	City	City	Yes
Customer Postal Code	Postal Code	Postal Code	Yes
Customer Detail	Customer NameCustomer Number	Customer Name Customer Number	Yes No

Set Customer Total as the grand total level. Set Customer Number as the primary key for the Customer Detail level. Your results should look similar to the screenshot: