2 Replies Latest reply: Mar 24, 2014 5:36 AM by Orcl01 RSS

    Top and Bottom Selection


      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







      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


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