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

Cardinality in Oracle Administration Tool ?

Received Response
21
Views
3
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 6:03PM in Oracle Analytics Cloud and Server

Hi everyone ,

I am new on oracle BI so please be kind !

I have done my modelisation in Oracle Administration Tool ( as shown below )

and i have a problem , in Oracle BIEE when i split my measure by the dimension "D07- Type incoterm" i dont find exaustiv data ( means that i find only 2 values of the dimension (3rd image) )

But in my datawarehouse , when i write the SQL code for the same query ( 2d image ) , i have the correct result , so its maybe a question of cardinality . i dont know if there is something special i should do in this tool. Thank you if you can help

pastedImage_1.png

pastedImage_2.png

pastedImage_0.png

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Your physical join must be wrong. What you're showing is the logical relationship. Go one level deeper to the physical layer.

  • John305
    John305 Rank 5 - Community Champion

    You got it ,  just saw that i put a wrong join because the dimension have almost the same name , Thank you Christian !

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    No problem. See we're tame in here ;-)

    Can you please close the thread?