How to join multiple subject areas in OTBI

Dilip.Murugan-Oracle

Please explain how to join multiple subject areas in OTBI

For example help me to join the below subject areas.

1. Project control - Financial Project plans Real Time

2. Project Costing - Expenditure Item Performance-Real TIME

Please let me know about this

Rajasekhar Bandaru-Oracle

Hi Dilip

Please review the given documentation link

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

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/combine-subject-areas-analyses.html#GUID-8B9DF9B1-20E3-4F88-8EEE-0714EF6E2F63

https://docs.oracle.com/en/cloud/saas/project-management/23b/faopm/Project-Control--Financial-Project-Plans-Real-Time-SA-9.html#Project_Control__Financial_Project_Plans_Real_Time_SA_9_d1e4037

https://docs.oracle.com/en/cloud/saas/project-management/23b/faopm/Project-Costing--Expenditure-Item-Performance--Rea-SA-15.html#Project_Costing__Expenditure_Item_Performance__Rea_SA_15_d1e5201

We need to follow few steps to create analysis with multiple subject areas.

1. You should have common dimension in all the subject areas

2. Add Measure/Fact from each subject area on the report

3. 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 Results tab to see the data.

B. You also need to consider the lowest grain at which the SA is built.

C. More then one subject area reports are complex reports, apply proper filters on the report

D. Best to debug the issue, create a simple report with one subject area, 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.