Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How use metrics from two facts table on same report
ForSly
Rank 5 - Community Champion
Summary
Same report two fact tables
Content
I ma working on requirement that requires me to use metrics from two facts tables, however when u use the metrics on same report, my expected results are getting inflated. I realize its possible because the two fact tables are not joined. Any suggestions on how I can possible resolve this issue?
Version
12C
Tagged:
0
Answers
-
Which product are you talking about? Are you really concerned about a "report" - which is a BI Publisher object - or an "analysis" - which is an OBIEE object?
In case you are talking about OBIEE and hence RPD modelling: There is never ever a join between fact tables! Cross-fact analysis of information always works along conformed dimenisons.
0