OTBI Logical SQL complex query assembler - NOW 10 subject Areas

Summary

Now updated - Combine analyses from up to 10 different subject areas (V4)

Content

It was already posted on OBIEE forum, but I figured HCM would be a demanding that sort of thing a lot. So let's dive in.

Why do you need this?

While building a report on OTBI, you will encounter some cases where the Subject Area will only provide you partial information, and you need to complete that data with some others which are located on an entirely different Subject Area.

Sometimes, even within the same subject area, the logical SQL arbitrarily used by OTBI when selecting some columns will render no results because of the joins decided by people creating the subject area columns are not compatible or are reporting on 2 realms that cannot communicate together.