Sorting in DMX Query...

  • Hi All,

    I am using order function in a MDX query to get the member values of a dimension in Alphabetical order - A to Z. This dimension member is one of the parameter of my report.

    But there is a challenge. I have data like

    Abraham Lincoln

    Afzal Khan

    All

    So now as it is working in Ascending order format. Data is show like this in the Drop down list box.

    I want to achieve the order like this, irrespective of the names. The All values has to be displayed first in the drop down menu of parameter.

    All

    Abraham Lincoln

    Afzal Khan

    Please suggest any suitable MDX based solution ?

    Thanks in advance.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply