4 Replies Latest reply on Jul 6, 2015 10:25 AM by Gianni Ceresa

    Dynimically change the heading in pivot table in obiee11g

    Sudha777

      Hi all,

       

      1 - I have a requirement like when i select a period in prompt, it should display that period data + 11 months data. Can we dynamically get all columns dynamically for 11 periods automatically.

       

      2 - I am able to get the data for the prompt month + 11 periods, but column heading is static, i want to change the heading of that columns based on prompt selected.

       

      ex - i select May-15, it should show data for May-15, Jun-15, Jul-15, Aug-15, Sep-15, Oct-15, Nov-15, Dec-15, Jan-16, Feb-16, Mar-16..... I want the logic to change the heading only, where i got the columns data.