How to join Oracle BI Analysis report and BIP data model

Question

Content

Hello Everyone,

I'm trying to create a BIP data model which consists of core_hr data attributes retrieved via SQL and other attributes from Oracle BI Analysis(answer Report). I was able to view both the data sets(BIP and OTBI) but was not able create the link for join and I don’t see Oracle BI Analysis data attributes for linkage. Does anyone was able to join BIP data model and Oracle BI Analysis(answer Report)? Is it possible to join ? Please let me know.

Below is the screen of data model.

Thanks,

Varun

Version

HCM 20D

Praveen Kumar Akkala-Oracle · Answer

Hello @VarunG,

You can run them in separate data sets but cannot be linked.

Data sets from different data sources cannot be linked in Fusion BI Publisher Data model.

You can log an Idea in Idea Labs.

Thanks,

Praveen

RyanPasca1 · Answer

Hi Anil, Just confirming it is not possible to create a Data Model from Analysis option in the below screenshot?

Thank you,

Ryan

User_M4LEM · Answer

Hi Varun,

It is not feasible to link analysis data set with other data sets. Use Logical SQL to create dataset instead of analysis.

Thanks,

Anil