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

report with 2 facts and 3 conformed dimensions not giving results as expected

Received Response
1
Views
2
Comments
875299
875299 Rank 4 - Community Specialist
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Hi,

In obiee 12c , i have built a report with 2 facts and 3 conformed dimensions.

in results,i don't see measure values from both facts together (only one measure from one fact is shown)

At the same time,i can see measures separately.

please let me know if there is anything i have to do in the rpd to view the report with measures from different facts.

thanks

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    Hi @875299, to start off with, could you show a screenshot of the BMM layer data model which displays the joins of the 2 facts and 3 conformed dimensions?

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    Have you checked that the LTS for both FACTs have the correct settings to the appropriate level of detail for all of the conformed dimensions involved?

    Have you also checked that you have appropriate keys set for the dimensions.