Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Accepted answer
21
Views
1
Comments
Bryan K
Bryan K Rank 2 - Community Beginner
edited Aug 13, 2024 5:31PM in Oracle Analytics Cloud and Server

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?

Tagged:

Best Answer

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    Hi,

    I don't have an OTBI to check what it looks like, but it generally behave a lot like OBIEE (11g or 12c, no idea but doesn't matter here).

    In OBIEE you can pass filters to an analysis by using the GO URL syntax.

    https://datacadamia.com/dat/obiee/obips/url_filter

    I don't have a 12c link handy, but it is (was?) documented in the official doc too (both 11g and 12c), I just can't remember where to find it there...

    Give it a try and see if your OTBI accept the GO URL syntax.