MDX Filter Expressions RRS feed

  • Question

  • Hi All,
        I am trying to arrange the time dimension filter in the descending order. As of now i am able to arrange all the months in the descending order. I have used the following code

    (Order([Month].[Dim Month].[Dim Month], RANK([Month].[Dim Month].Currentmember, [Month].[Dim Month].[Dim Month]),BDESC))

    The output i have got is as follows.
    Feb 09
    Dec 08

    Now i need to get the filter for the entire  time hiearchy. My requirement is as follows

    Year 2009
        Dec 09
        Nov 09
        Oct 09

    Year 2008
          Dec 08
         Nov 08
         Oct 08

    Please let me know if you have any solutions.

    Thanks and Regards,

    Wednesday, February 25, 2009 1:06 PM


  • Ram,
    You may create a hierarchy in the time dimension which gives you this result and you may use that in the filter.

    Dibyant S U padhyay
    Thursday, February 26, 2009 5:39 AM