Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Pass results from an analysis in OAC to filter values of an analysis in ERP OTBI

Closed
11
Views
1
Comments
Bryan K
Bryan K Rank 2 - Community Beginner

I am trying to compare data from ERP/OTBI to OAC and then pull additional details from ERP based on the results of the comparison. For example, I have dimensions A, B, C and Measure 1 from OTBI. I compare (join) them to Dimensions A, B, C and Measure 1 from OAC. For any values which join, but Measure 1 doesn't match, I need to pull additional details from ERP/OTBI. I found a method where you setup a BIP report in ERP, and have the dimensions sent as parameter values, which are passed as a data action from OAC to BIP via URL. But is there no way to show the data in an OTBI Analysis, rather than in a BIP report?

Best Answer

This discussion has been closed.