Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 48 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to join the multiple subject areas in otbi
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
Best 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.
Hope this helps.
Thanks,
Dimple Nagesh
0
Answers
-
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.
Hope this helps.
Thanks,
Dimple Nagesh
1