Trying to connect two SA

Question

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

ravikiran goda-Oracle · Answer

HI

Khalid Aldosari-Oracle

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

Riyaz Ali-Oracle · Answer

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

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/25299/trying-to-connect-two-sa

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.