I am trying to write a query that will order [Trn_Age_Tag].Members by
[Measures].[Net Amt Vlme Bal Xfer] desc. Below is my attempt? Can
anyone tell me what I am doing wrong.

Thanks


With
MEMBER [Measures].[dayname] AS '[Time].CurrentMember.PROPERTIES
("dayname")'
SELECT
{[Measures].[dayname] , [Measures].[Net Amt Vlme Bal
Xfer],[Measures].[Net Amt Vlme Conv Chk],[Measures].[Net Amt Volume
Atm],[Measures].[Net Amt Volume Cash],
[Measures].[Net Amt Volume Ovrdft]}ON COLUMNS,
Crossjoin(Order ({[Time].[Day].Members},[Trn_Age_Tag].Members,Desc)} ON
ROWS
FROM [Open Date]

Maybe the query isn't copied correctly, because Order() doesn't take 2
set parameters? Anyway, if [Trn_Age_Tag].Members includes members at
different levels, but they still should be ordered without regard to
level, then the BDESC option should be used, like:

MEMBER [Measures].[dayname] AS
'[Time].CurrentMember.PROPERTIES("dayname")'
SELECT
{[Measures].[dayname] ,
[Measures].[Net Amt Vlme Bal Xfer],
[Measures].[Net Amt Vlme Conv Chk],
[Measures].[Net Amt Volume Atm],
[Measures].[Net Amt Volume Cash],
[Measures].[Net Amt Volume Ovrdft]}ON COLUMNS,
Crossjoin([Time].[Day].Members,
Order([Trn_Age_Tag].Members,
[Measures].[Net Amt Vlme Bal Xfer], BDESC)) ON ROWS
FROM [Open Date]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***