Guidance Required for Configuring OTBI Reports with Multiple Subject Areas

User_8GG44

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.

Hitesh Patel-Oracle

Hi,

For OTBI queries, please use the below forum:

https://community.oracle.com/customerconnect/categories/cx-reporting-analytics-sales

For the best practices, please refer this page.
You would find more information around best practices and others at the below location
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=90843665650366&id=1624768.1&_afrWindowMode=0&_adf.ctrl-state=2ecxinhou_4

Priscila Terazawa - Support-Oracle

Hi @User_8GG44 ,

Please refer to

https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1624768.1&id=1601082.1https://www.oracle.com/pls/topic/lookup?ctx=en/cloud/saas/sales&id=s20054653

They both show examples.

Hope it helps.
Priscila Terazawa

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/23217/guidance-required-for-configuring-otbi-reports-with-multiple-subject-areas

Below should be helpful as well:

Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1)

Thanks.