Blog

In this article, we will discuss on how to report on multiple subject area in OTBI

The following are the rules to be followed to create a multiple subject area OTBI analysis:

1. make sure all the folders/dimensions are available in all the subject areas to be joined.

in case of unrelated dimensions, apply the “Dimensionality” hint on the OTBI analysis.
Goto Advanced tab > Advanced SQL Clauses > DIMENSIONALITY (show total value for all measures on unrelated dimensions.

2. at least one measure column from each subject area to be included in the analysis.
Regardless of whether it is required to be shown in the analysis or not. If you do not require this measure, hide the column.

For those who want a video log, the following Oracle Learning Library link, details the same.  
https://www.youtube.com/watch?v=-2h3a7F_19k&feature=youtu.be