Logical Table Sources in OBIEE
1 . Expand D1 Time --> Sources.
2 . Double-click the LTS1 Time logical table source to open the Logical Table Source dialog box.
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".
3 . Click the Content tab.
4 . Confirm that Aggregation content, group by is set to Logical Level and the logical level is set to Time Detail for the H1 Time logical dimension. 
5 . Click OK to close the Logical Table Source dialog box.
6 . Repeat to verify or set content settings for the remaining logical table sources using the table and screenshots as a guide:
| Logical Table Source | Logical Dimension | Logical Level |
| LTS1 Product | H2 Product | Product Detail |
| LTS1 Customer | H3 Customer | Customer Detail |
| LTS2 Customer Address | H3 Customer | Customer Detail |
| LTS1 Revenue | H1 TimeH2 ProductH3 Customer | Time DetailProduct DetailCustomer Detail |
7 . Save the repository and check global consistency. Fix any errors or warnings before proceeding. Notice that you did not have to make any changes to the Presentation layer. 8 . Close the repository. Leave the Administration Tool open.
For an in-depth understanding of OBIEE click on
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
About Author
Name
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.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox