Oracle Analytics and AI

Trying to connect two SA

Hi Everyone,

I have those two subject area and I wondering if there is a way to joining them together

1- Payroll - Payroll Costing Setup Detail Real Time.

2- Payroll - Payroll Run Results Real Time

thanks in advance

OTBI

OTBI Reports

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.

Please review the below KM notes and follow to create report from cross Subject Areas:

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

Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI - KB89403

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