This query


SELECT
[Measures].[Reseller Sales Amount] ON COLUMNS,
Order (
Descendants (
[Employee].[Employee Department].[Department Name].&[Sales],
[Employee].[Employee Department].[Title],
SELF),
ASC
) ON ROWS
FROM [Channel Sales]

fails with error
Query (8, 3) An expression was expected for the function argument and no
expression was detected.

And this query

SELECT
{
[Measures].[Reseller Sales Amount]
}
ON COLUMNS,

NON EMPTY
{
Order (
{Descendants ([Employee].[Employee Department].[Department Name].&[Sales],
[Employee].[Employee Department].[Title],SELF)},
[Employee].[Employee Department].CurrentMember,
ASC
)
}
ON ROWS
FROM [Channel Sales]

works but doesn't sort by [Employee].[Employee Department].CurrentMember

I'm obviously not getting the semantics of sorting by dimensions




--------------------
Chris Harrington
Active Interface, Inc.
http://www.activeinterface.com

Hi Chris,

The 2nd argument of Order() is a numeric or string expression by which
to order the members of the 1st argument. So I assume that you wanted
something like:

[Measures].[Reseller Sales Amount] ON COLUMNS,
Order (
Descendants (
[Employee].[Employee Department].[Department Name].&[Sales],
[Employee].[Employee Department].[Title],
SELF),
[Measures].[Reseller Sales Amount],
ASC
) ON ROWS
FROM [Channel Sales]
---------------------------------------------------------
Reseller Sales Amount
Vice President of Sales (null)
Pacific Sales Manager $172,524.45
European Sales Manager $732,078.44
North American Sales Manager $1,092,123.86
Sales Representative $78,453,870.23

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Deepak,

No, actually what I want is to sort by the Title string. And get results as:


European Sales Manager $732,078.44
North American Sales Manager $1,092,123.86
Pacific Sales Manager $172,524.45
Sales Representative $78,453,870.23
Vice President of Sales (null)

Chris


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

I think I figured out my issue. I changed
[Employee].[Employee Department].CurrentMember

to

[Employee].[Employee Department].CurrentMember.Name

and now it sorts by employee title

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote