Hello All,

I have a question with regard to the descendants command.
I use the syntax below quite often within cubes. This is
fine while I have the dimension class on rows or columns
or just one member selected on a background dimension,
however if there are multiple members selected on
background, then nothing is returned.

descendants([class].currentmember,[class].[Minor],self)

I understand why this is happening, descendants expects a
member parameter, and .currentmember with multiple
background members returns [Class].[ Aggregation] (in the
example above), which descendants cannot parse, and so the
result of the descendants commant is an empty set {}

My question is, is there anyway around this? Perhaps some
sort of recursive function that returns a set consisting
of multiple descendants commands?

Any advise appreciated.

Mark

As of SP3, descendants accepts a set as a parameter.
By substituting [class].currentmember by the set of
selected members your queries should work.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html