How can I order in descending order the members of a Level in
analysis manager.



I know the "order" by property but i can only specify the column name

or key there, i cannot tell weather to order by descending or ascending.



Also tell me if I can use expressions in place of colum name in the

order by property.



Thanks



Asim Naveed


--
Posted via http://dbforums.com

Hi,
you can always order by MDX, outside AS manager:
In as you can only order ascending if choosing by Name,
or else you can oder by key in the order the key is in.

See documentation of MDX sample application for more
detail:

Order
Arranges members of a specified set, optionally
preserving or breaking the hierarchy.

Syntax
Order(«Set», {«String Expression» | «Numeric Expression»}
[, ASC | DESC | BASC | BDESC])

Remarks
There are two varieties of Order: hierarchized (ASC or
DESC) and nonhierarchized (BASC or BDESC, where B stands
for Break hierarchy). The hierarchized ordering first
arranges members according to their position in the
hierarchy. Then it orders each level. The nonhierarchized
ordering arranges members in the set without regard to
the hierarchy. In the absence of an explicit
specification, ASC is the default.

HTH Lutz