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