0 Replies Latest reply on Jun 6, 2013 6:29 AM by dwhpc

    Federation Reports Issues - ESSBASE with Oracle DB Source

    dwhpc
      Hi All,

      I am creating Federation reports, trying to achieve Horizontal Federation using Essbase source with Oracle DB.

      I am getting the both the values from ESSBASE as well as from DB Source, but the results are not clubbed together instead its showing Essbase values first followed by Oracle DB value.

      I followed all the steps, dont know whether i did the mistake.

      Source|Product|Units|Price

      ESSBASE|1|1|Null
      ESSBASE|2|2|Null
      ORACLE|XXX|Null|123
      ORACLE|yyyy|Null|345

      Note: Price columns populated from DB, in the above first two rows, i didnt get the DB Values and the next two rows i didnt get the ESSBASE values.

      FYI, I have posted the same question on OBIEE forum, i didn't get any replies. Please anyone guide me...

      Thanks