Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Joins & mapping in LTS
Answers
-
A leading practice in OBIEE is to alias all your tables in the physical layer ... then you can actually have a 'star'; you'd be joining facts but you'd be joining the dimension alias of that table. While it might seem a case of semantics, it helps to preserve the 'theory' in the diagram.
0 -
Thomas,
I understand your point, however it's not essential problem in this topic.
0 -
Hello, if your requirement is to select only select reversals, the redemption partner and transactions relation and only show
The thing that if I create for example report with columns from Reversals, Redemptions, Redemptionpartner, I would like to use in select only these tables + Transactionsrelations, but instead of this OBI does select with all these tables that are in the picture.
You have to create an only one LTS for your "transaction measure" logical fact table, and in the LTS add in a join setting all your transaction tables, after it, you should ensure an only one LTS for your dimension tables.
0