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 |
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:
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
