Dear all

I'm new to mdx and are struggeling in Reporting Services with the sort order
of a resultset. My querry is

WITH
MEMBER
[Measures].[ParameterCaption] AS
'[Lieferant].[Name].CURRENTMEMBER.MEMBER_CAPTION'


MEMBER
[Measures].[ParameterValue] AS
'[Lieferant].[Lieferant].CURRENTMEMBER.UNIQUENAME'


MEMBER [Measures].[ParameterLevel] AS
'[Lieferant].[Lieferant].CURRENTMEMBER.LEVEL.ORDINAL'


SELECT
{[Measures].[ParameterCaption], [Measures].[ParameterValue],
[Measures].[ParameterLevel]} ON COLUMNS ,

{ [Lieferant].[Lieferant].ALLMEMBERS }ON ROWS FROM [Test]


I cant make it to sort this resultset [Lieferant].[Name]. When I try to add
[Lieferant].[Name] to the rows in a crossjoin the sort order stays with
[Lieferant].[Lieferant]

Thanks for your help,

Regards,

Marc

If you wish to sort by [ParameterCaption] ascending:

MEMBER
[Measures].[ParameterCaption] AS
'[Lieferant].[Name].CURRENTMEMBER.MEMBER_CAPTION'


MEMBER
[Measures].[ParameterValue] AS
'[Lieferant].[Lieferant].CURRENTMEMBER.UNIQUENAME'


MEMBER [Measures].[ParameterLevel] AS
'[Lieferant].[Lieferant].CURRENTMEMBER.LEVEL.ORDINAL'


SELECT
{[Measures].[ParameterCaption], [Measures].[ParameterValue],
[Measures].[ParameterLevel]} ON COLUMNS ,

Order([Lieferant].[Lieferant].ALLMEMBERS,
[Measures].[ParameterCaption], BASC) ON ROWS
FROM [Test]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Hi Deepak

thanks for your advice. I missed the second argument, that can be a valid
mdx string or numeric expression.

By the way what does BOL mean by saying a valid mdx numeric and string
expression? What you declared in the querry below, which works very well, is
a mdx measure, right?


Regards,

Marc


"Deepak Puri" wrote:

Hi Marc,

A measure can be considered a valid MDX expression:

http://msdn2.microsoft.com/en-us/library/ms145971.aspx

An expression is a combination of identifiers, values, and operators
that Microsoft SQL Server 2005 Analysis Services (SSAS) can evaluate to
get a result.
...
Object identifier

MDX is object-oriented because of the nature of multidimensional data.
Object identifiers are considered simple expressions in MDX.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thanks Deepak!

Marc
--
Best regards,

Marc


"Deepak Puri" wrote: