dbTalk Databases Forums  

CHILDREN_CARDINALITY property in AS 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss CHILDREN_CARDINALITY property in AS 2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stan Kondrat
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.