Sunday, February 19, 2012

HideMemberIf ADOMD.NEt

Hello everyone!
I have a ragged hierarchy, and I'm using HideMemberIf = ParentName in the last level of the hierarchy (AS 2005)
I have a client application written using ADOMD.NET where I put the data into a cellset object.
The problem is that I can't differentiate when a level has this property set with adomd.net.
Could anyone help me here?
thanksThere is no way in ADOMD.NET to find out whether a level has HideMemberIf turned on.|||You can however check to see if a member is a placeholder member (that is should be hidden) by checking the IS_PLACEHOLDERMEMBER property in the properties collection. Note that this property isn't retrieved by default for members so you'll probably need to call FetchAllProperties() or request it when you fetch your members. Note that you also need to set the connection string property MDX Compatibility=1 for this IS_PLACEHOLDERMEMBER to be set.

No comments:

Post a Comment