OBIEE 11G Associate Time Logical Columns with Logical Levels

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:
Screenshot for Step
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.
Screenshot for Step
3 . Set the logical keys for the H1 Time logical dimension according to the following table:
Logical Level
Level Key
Use for Display
Year Per Name Year Yes
Half Per Name Half Yes
Quarter Per Name Qtr Yes
Month Per Name Month Yes
Week Per Name Week Yes
Time Detail Calendar Date Yes
Screenshot for Step

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.
Use for Display
Customer Total
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 Name
Customer Number
Customer Name
Customer Number
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:
Screenshot for Step

No comments:

Post a Comment

Popular Posts