• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Associate Time Logical Columns with 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 YearYear
Per Name HalfHalf
Per Name QtrQuarter
Per Name MonthMonth
Per Name WeekWeek

Your results should look similar to the screenshot:

2

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.

2

Logical LevelLevel KeyUse for Display
YearPer Name YearYes
HalfPer Name HalfYes
QuarterPer Name QuarterYes
MonthPer Name MonthYes
WeekPer Name WeekYes
Time DetailCalendar DateYes
Desired to gain proficiency on OBIEE Training? 
Explore the blog post on OBIEE  training to become a pro in OBIEE Training Online.

2

 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.

LevelColumnKeyUse for Display
Customer Total<none><none><none>
Customer RegionRegionRegionYes
Customer AreaAreaAreaYes
Customer CountryCountry NameCountry NameYes
Customer StateState ProvinceState ProvinceYes
Customer CityCityCityYes
Customer Postal CodePostal CodePostal CodeYes
Customer DetailCustomer NameCustomer NumberCustomer 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:

2

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Associate Time Logical Columns with Logical Levels in OBIEE
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Associate Time Logical Columns with Logical Levels in OBIEE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.