Hi ,
Somebody has been in a similar situation or knows like solving it?
I have this situation : 5 levels (Country), (Region), (Area),
(Cities), (Districts)
Well, I need to execute a Mdx to return
-Country
-Region
-Cities
but I need Cities order by Region (without Hierarchy -areas omitted-).

select Measures.[Unit Sales] on columns,
Hierarchize ( {
country.members, descendants (country1, region),
country.members, descendants (country1, region),
country2.region1, country2.region2, descendants (country1,
cities)...})
from CubesSales
where Time.2003

Note: I am using Hierarchize because the selection of levels / members
is "Open" through an assistant.
I tried to use Sorting on multiple criteria method ( 'parent_name' +
value ....) but with more than 2 levels does not work.

Any idea about it? I do not know MDX deeply, is it really complex
sometimes?.

Thanks in advance.
al