How to join the multiple subject areas in otbi

Dilip.Murugan-Oracle

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

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

Dimple-Nagesh-Support-Oracle

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