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

Question

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

Robert Angel · Answer

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.

Joel Acha · Answer

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?