2 Replies Latest reply: Mar 24, 2014 5:36 AM by asim juman cholas RSS

    Top and Bottom Selection

    user8206283

      Hi Gurus,

       

      I have very small requirement.

      I have to create a prompt (SQL Type) where  I have display below values in the prompt ( I am able to create a prompt).

      Top Ten

      Top Twenty

      Bottom Ten

      Bottom Twenty

      Top and Bottom Ten

      Top and Bottom Twenty

       

      And another prompt which I would have to display measure name

      M1

      M2

      M3

      M4

      M5

       

      Based on these two prompt selection I would have to show Top Ten, Twenty,Bottom Ten,Twenty ...etc

       

      Dimension    Measure M1or M2 or M3 or M4 ...

      D1               Measure Value

      D2               Measure Value

      D3               Measure Value

       

      Can some one would help me or suggest how would I do this in 11.1.1.7.1

       

      All the Measures M1 to M5 are columns in my Fact table