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
Cardinality in Oracle Administration Tool ?

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
Answers
-
Your physical join must be wrong. What you're showing is the logical relationship. Go one level deeper to the physical layer.
0 -
You got it , just saw that i put a wrong join because the dimension have almost the same name , Thank you Christian !
0 -
No problem. See we're tame in here ;-)
Can you please close the thread?
0