Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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