Skip to Content
0
Former Member
Jul 12, 2005 at 04:56 PM

Sort output data in MDX queries

76 Views

Hi,

I wuold obtain a sorted output from my MDX query.

Follow an extract from my mdx code:

the sorted list will be ordered by char APF000050 and APF00048 descendant.

who can help my ?

Thanks in advance

SELECT

{ [Measures].MEMBERS} ON columns ,

NON EMPTY [APF000050].[LEVEL01].MEMBERS

  • [APF000048].[LEVEL01].MEMBERS

  • [APF000063].[LEVEL01].MEMBERS

  • [APF000068].[LEVEL01].MEMBERS

  • [APF000088].[LEVEL01].MEMBERS

*[APF000069].[LEVEL01].MEMBERS

PROPERTIES [APF000088].[2APF000088],[APF000069].[2APF000069]

on rows

FROM [APF_MP_01/AP]

WHERE ( [APF000001].[AP06 0000090106], [APF000095].[2004] )

Message was edited by: Luca Di Benedetto

Solved.