-
Predefined Sorting in MDX
I am dealing with Occupancy Rate in Hotel Industry.
I would like to display [Measures].[Taux Occupation] ordered by categorie DESC and according to a specified order of [Localisation] :
Paris
Province-Cote-d'Azur
Autres Regions
It's Clear that this order is neither Asc Nor Desc...
Should I define a set and order according to this set ?
This is my script :
SELECT
NON EMPTY { [Measures].[Taux Occupation] } ON COLUMNS,
{ORDER (
{[hotel].[Categorie].[Categorie].ALLMEMBERS *
[hotel].[Localisation].[Localisation].ALLMEMBERS },
[Categorie].CurrentMember.Properties('KeyColumns'),DESC ) } ON ROWS
FROM [CUBE]
Thnks a lot for ur Answer
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|