Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Priority in business model

Received Response
1
Views
1
Comments
choracy69
choracy69 Rank 6 - Analytics Lead
edited August 2024 in Oracle Analytics Cloud and Server

Hi everyone,

I have question about model in business layer.

Let's assume that I get model like:

pastedImage_0.png

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

  • elb666
    elb666 Rank 2 - Community Beginner

    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.