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
Priority in business model

Hi everyone,
I have question about model in business layer.
Let's assume that I get model like:
F1 and F2 - facts tables
D1 and D2 - dimension tables
My question is:
Can I set priority for this model that when I use columns from F1, D1, D2 I want that BI generate SQL Query without join between D1-D2? It is mean - when I use columns from F1 - I want use joins only between F1-D1 and F1-D2 - without joins between D1-D2.
When I don not use columns from F1, but use columns from F2, D1, D2 that i want use joins between F2-D1 and D1-D2. It is possible to control model in rpd?
Answers
-
If I understand correctly, the join between D1 and D2 is only there for F2. I suggest having separate aliases of your D tables for F1 and F2. The aliases for F2 include a join between D1 and D2, while the aliases for F1 do not.
Keep in mind that assuming you want to have a common logical table, you'll also have to two logical table sources in the BMM, one for F1 and one for F2.
0