Hi @Khalid Aldosari-Oracle,

Please find below few high level steps that needed to be followed while combining the multiple OTBI SAs.

• You should have common dimension in the subject areas used in the report.
• Add at least one Measure/Fact/Metric from each subject area on the report.
• Click on the Advance tab of the Analysis report --> Scroll down till you see Advance SQL clause --> Check the Dimensionality check box --> click on Apply SQL button. Go to the Results tab and test the results.
• Need to consider the lowest grain at which the Subject Areas built.
• More than one subject area reports are complex reports, make sure to apply proper filters on the report otherwise there might be performance impact.
• High level steps to debug the issue:
  • Create a simple report with one subject area and make sure it is returning data & working.
  • Remember to add as many dimension columns from first SA and add at least one measure.
  • Apply filters.
  • Add second subject area add required dimension columns and don't forget to add measure.

Hope this help.

Thank you.

HI

Khalid Aldosari-Oracle

Make sure to add measure from both the subject areas and common dimensions