Hi everyone,

I managed to get a server-side named set as a dimension in an Excel
2003 pivot table using some VBA code (available upon request). The
named set (tested in the MDX sample app) shows a dimension's last
level's members sorted according to one of their properties. I can
drag it as row headings just fine, but it shows up sorted as in the
original hierarchy (i.e, accounting for the sort order of every level
above).

The same issue comes up if I define the named set using the
CalculatedMembers.Add function of the Pivot Table object.


Any idea whether this is an Excel bug or an error on my part?

Thanks,

SR