CHILDREN_CARDINALITY property in AS 2005 -
08-02-2006
, 10:16 AM
Hi,
This property was quite useful in AS 2000 to determine if a hierarchy member
was a leaf, particularly when using XML Reader to retrieve the results of a
complex MDX query.
This property seems to be quite useless in the current version of AS 2005,
since it only returns 0 or 1000, and even that is not reliable to determine
if the member has any children.
Is this going to be fixed soon? If not, what are the alternatives? The
IsLeaf MDX function means adding more calculations to the query. For complex
multi-dimensional queries this is problematic. Are there any other approaches?
Thanks,
Stan |