I have what I thought would be a simple query, which is attached below:


select
{[Measures].[No of Clients],
[Measures].[Cash],
[Measures].[Bonds],
[Measures].[Mutual Funds],
[Measures].[Total Assets],
[Measures].[Total Liabilities]} on columns,
non empty ({[Primary SalesRep].[primary Sales Rep].members}) on rows
from RPT2X
where
([Time].[Apr 2003],
[Company].[New York]
)

I need to be able to sort on the [Measures].[Total Assets] column, and
nothing else. I can see how to do it if I want to sort on everything in
all columns, but I just need one column sorted.

Does anyone have a simple answer to this? Thanks.

Hi Duane,

You need to use the ORDER() MDX function. Something like

non empty (ODER({[Primary SalesRep].[primary Sales Rep].members},
[Measure].[Total Assets], DESC)) on rows
Sean

--
Sean Boon
SQL Server BI Product Unit

Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"Daune Kramer" <daune (AT) riverlooksoftware (DOT) com> wrote

Hi Sean -

Thanks

One question - my MDX is kicking out the [Total Assets]. Since I specify
[Total Assets] in my columns, does it prevent me from using it in an
order statement on the rows?

"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote in
news:OkGdbBjSDHA.1868 (AT) TK2MSFTNGP11 (DOT) phx.gbl:

Nope. Shouldn't matter. I noticed that Total Assets is referred to
incorrectly. I forgot the "S" in Measures.

Sean


--
Sean Boon
SQL Server BI Product Unit

Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"Daune Kramer" <daune (AT) riverlooksoftware (DOT) com> wrote