Re: Question on Using Order()

#1

There must be some sort of a simple syntax error in the statement. For
example, this is from the Foodmart 2000 mdx sample file and it works fine.

select
{[Measures].[Unit Sales]} on columns,
non empty order([Promotion media].members,[Measures].[Unit Sales],DESC)
on rows
from Sales

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

Quote:

I have the following query:

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 sort by [Total Assets], so I need to use the ORDER. I made my
query look as follows:

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

But, I'm getting an error on [Total Assets] in the ORDER statement. Will
it not let me use a dimension in ORDER on Rows that I specified in
Columns?

#2

May be the problem is that you use

[Measure].[Total Assets]

in the filter function instead of

[Measures].[Total Assets]

Francesco De Chirico

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Question on Using Order()

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Question on Using Order() - 07-15-2003 , 12:02 PM

Re: Question on Using Order() - 07-16-2003 , 02:33 AM