OBIA-11.1.1.9.2 real time

Question

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

7688438 · Answer

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

rmoff · Answer

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