Oracle Business Intelligence Applications

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

OBIA-11.1.1.9.2 real time

Received Response
1
Views
2
Comments

Hi All, We have implemented finance/Spend analytics using OBIA-11.1.1.9.2(ODI as ELT) Source-EBS-12.1.3 Question:-Our client wants near real time data on one of the custom report(Budget forecast).This report data currently hitting against data warehouse. The back end fact tables for this report are W_GL_BALANCE_F,W_GL_OTHER_F-->DRILL DOWN TO W_AP_XACT_F Total this report uses 4 to 5 dimension tables. What are the options to give client near real time data? thanks R

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead

    Federation by pointing OBIEE direct at source too, or GoldenGate to load the data warehouse as the data hits EBS

  • 7688438
    7688438 Rank 5 - Community Champion

    rmoff, thanks for your response.! My client is against to directly point it to EBS. 2nd option is golden gate.I'm aware that golden gate and ODI are integrated with OBIA-11.1.1.9.2.My client expectation is to see the realtime data in less than 15 minutes. How long will it take if we use golden gate & ODI combination to load the data for GL and AP dashboards?.In our dashboard we have drill down from GL to AP transactions. Thanks