How to join the multiple subject areas in otbi

Question

Is there any join condition to join multiple subject areas

For example could anyone help to join below subject areas.

Project Costing - Expenditure Item Performance-Real TIME

Project control - Financial Project plans Real Time

Dimple-Nagesh-Support-Oracle · Accepted Answer

Hi Dilip,

About Cross-Subject Area Joins

You can create analyses that combine data from more than one subject area.

Review guidelines for creating these joins in MyOracle Support (Doc ID 1567672.1).

Note:

Use joins sparingly with cross subject areas as they can affect report performance.

Cross-subject area analyses can be classified into three broad categories:

* Using common dimensions - A common dimension is a dimensional attribute that exists in all subject areas in the analysis. These dimensions are considered common dimensions between subject areas and can be used to build a cross-subject area report.

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

Hope this helps.

Thanks,

Dimple Nagesh