0 Replies Latest reply: Mar 12, 2012 6:22 AM by JUPS RSS

    Measure labels as rows in BIP Pivot Table

    JUPS
      Hi Gurus,

      I have a problem with pivot table that i need to generate, I have only two columns:

      Fiscal-Period Project-Revenue
      SEP-12 1000
      OCT-12 1200
      NOV-12 1400


      Now, I need to the pivot view in this format:


      -- - - - - - - - - - - - SEP-12 -- - - OCT-12 - - - - NOV-12
      Project-Revenue-- 1000 - - - - 1200 -- - - - - -- 1400

      i.e. I need label of the measure displayed as row. I am using OBIEE query as source.

      Thanks,
      Sreekanth Jala

      Edited by: JUPS on Mar 12, 2012 4:52 PM