Hi,

We are encountering an issue in our current business requirement, which involves creating an OTBI report by utilizing multiple standard and custom objects across four to five subject areas. To ensure data availability, we are required to add a measure when incorporating these subject areas. However, we are facing challenges with inconsistent and duplicate data entries in the report, and certain data are missing.

We would appreciate guidance on the following:

• How to effectively use multiple subject areas, particularly when they include both standard and custom objects, for configuring OTBI reports.
• The impact and handling of scenarios where one or more subject areas lack a common dimension, as this appears to contribute to the inconsistencies in our report.

Looking forward to insights on resolving these issues.