Oracle Analytics Cloud and Server

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

Categories

How use metrics from two facts table on same report

Received Response
15
Views
1
Comments
ForSly
ForSly ✭✭✭✭
in Oracle Analytics Cloud and Server

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:
· Share on FacebookShare on Twitter

Answers

  • Christian Berg
    Christian Berg mod

    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.

    · Share on FacebookShare on Twitter