Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OTBI Help: Pulling data from 2 subject areas or how to find the sql behind it

Adil_RMay 15 2019 — edited Aug 6 2019

I am trying to build a Analysis which will consist of two subject areas: "comp salary..." and "workforce mgmt.assignment real time" but when i move few salary field over then i get an error: "no facts.....". i'm hoping someone can provide some guidance. I need an alternate solution, possibly finding the sql code behind an Analysis so i can build my own report with join statement or is there a way to get data off from two subject areas without an error messages. Thanks

This post has been answered by SivaReddy Mitnala on Aug 6 2019
Jump to Answer
Comments
Post Details
Added on May 15 2019
4 comments
2,494 views