HideMemberIF: Parent vs. Only Child w/ Parent

Even after reading the SQL BOL definitions, I'm unable to actually demonstrate a real-world difference between the "Never", "ParentName" and "Only Child w/ ParentName" settings for the HideMemberIF property with my multi-level hierarchy on it's ragged dimension. Specifically, my hierarchy simply will not hide a member named the same as it's parent, when viewed in VS's Dimension browser window, regardless of the HIdeMemberIF setting chosen. I've not yet loaded SQL 2K5's SP1, and here are my questions:

(1) Could it be that VS's dimension browser and/or cube browser do not support the HideMemberIF property?

(2) If so, has that changed with SP1?

I think I have seen this issue already in AS2000. The HideMemberIf property requires you to fill empty fields with null or a blank. It is only used for empty levels and not for parent and children with the same name. If you update all your empty levels with a blank or null, will that help?

Regards

Thomas Ivarsson

|||

Hi,

this is a weekness in the VS Browser - but the function works as documented. I use it regular in my projects. You need to use a client which is capable to set the "MDX Compatibility" property to the value of two to browse the proper structure. (Excel 2003 with the CubeAnalysis ADDIN is capable - and many othere clients)

See http://msdn2.microsoft.com/en-us/library/ms365406.aspx for further details or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=653115&SiteID=1

HANNES

|||

This is very encouraging news! Thank you.

Do you know if either

(1) ProClarity 6.1, or

(2) Strategy Companion

support MDX Compatibility = 2 ?

I'll check with the manufacturers myself and reply here with their responses.

Daniel

|||

Dan

Did you get a response from ProClarity? I have the same problem and want to set it to 2.

|||I did not get a response.

HideMemberIF: Parent vs. Only Child w/ Parent

Even after reading the SQL BOL definitions, I'm unable to actually demonstrate a real-world difference between the "Never", "ParentName" and "Only Child w/ ParentName" settings for the HideMemberIF property with my multi-level hierarchy on it's ragged dimension. Specifically, my hierarchy simply will not hide a member named the same as it's parent, when viewed in VS's Dimension browser window, regardless of the HIdeMemberIF setting chosen. I've not yet loaded SQL 2K5's SP1, and here are my questions:

(1) Could it be that VS's dimension browser and/or cube browser do not support the HideMemberIF property?

(2) If so, has that changed with SP1?

I think I have seen this issue already in AS2000. The HideMemberIf property requires you to fill empty fields with null or a blank. It is only used for empty levels and not for parent and children with the same name. If you update all your empty levels with a blank or null, will that help?

Regards

Thomas Ivarsson

|||

Hi,

this is a weekness in the VS Browser - but the function works as documented. I use it regular in my projects. You need to use a client which is capable to set the "MDX Compatibility" property to the value of two to browse the proper structure. (Excel 2003 with the CubeAnalysis ADDIN is capable - and many othere clients)

See http://msdn2.microsoft.com/en-us/library/ms365406.aspx for further details or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=653115&SiteID=1

HANNES

|||

This is very encouraging news! Thank you.

Do you know if either

(1) ProClarity 6.1, or

(2) Strategy Companion

support MDX Compatibility = 2 ?

I'll check with the manufacturers myself and reply here with their responses.

Daniel

|||

Dan

Did you get a response from ProClarity? I have the same problem and want to set it to 2.

|||I did not get a response.

HideMemberIF: Parent vs. Only Child w/ Parent

Even after reading the SQL BOL definitions, I'm unable to actually demonstrate a real-world difference between the "Never", "ParentName" and "Only Child w/ ParentName" settings for the HideMemberIF property with my multi-level hierarchy on it's ragged dimension. Specifically, my hierarchy simply will not hide a member named the same as it's parent, when viewed in VS's Dimension browser window, regardless of the HIdeMemberIF setting chosen. I've not yet loaded SQL 2K5's SP1, and here are my questions:

(1) Could it be that VS's dimension browser and/or cube browser do not support the HideMemberIF property?

(2) If so, has that changed with SP1?

I think I have seen this issue already in AS2000. The HideMemberIf property requires you to fill empty fields with null or a blank. It is only used for empty levels and not for parent and children with the same name. If you update all your empty levels with a blank or null, will that help?

Regards

Thomas Ivarsson

|||

Hi,

this is a weekness in the VS Browser - but the function works as documented. I use it regular in my projects. You need to use a client which is capable to set the "MDX Compatibility" property to the value of two to browse the proper structure. (Excel 2003 with the CubeAnalysis ADDIN is capable - and many othere clients)

See http://msdn2.microsoft.com/en-us/library/ms365406.aspx for further details or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=653115&SiteID=1

HANNES

|||

This is very encouraging news! Thank you.

Do you know if either

(1) ProClarity 6.1, or

(2) Strategy Companion

support MDX Compatibility = 2 ?

I'll check with the manufacturers myself and reply here with their responses.

Daniel

|||

Dan

Did you get a response from ProClarity? I have the same problem and want to set it to 2.

|||I did not get a response.

HideMemberIF: Parent vs. Only Child w/ Parent

Even after reading the SQL BOL definitions, I'm unable to actually demonstrate a real-world difference between the "Never", "ParentName" and "Only Child w/ ParentName" settings for the HideMemberIF property with my multi-level hierarchy on it's ragged dimension. Specifically, my hierarchy simply will not hide a member named the same as it's parent, when viewed in VS's Dimension browser window, regardless of the HIdeMemberIF setting chosen. I've not yet loaded SQL 2K5's SP1, and here are my questions:

(1) Could it be that VS's dimension browser and/or cube browser do not support the HideMemberIF property?

(2) If so, has that changed with SP1?

I think I have seen this issue already in AS2000. The HideMemberIf property requires you to fill empty fields with null or a blank. It is only used for empty levels and not for parent and children with the same name. If you update all your empty levels with a blank or null, will that help?

Regards

Thomas Ivarsson

|||

Hi,

this is a weekness in the VS Browser - but the function works as documented. I use it regular in my projects. You need to use a client which is capable to set the "MDX Compatibility" property to the value of two to browse the proper structure. (Excel 2003 with the CubeAnalysis ADDIN is capable - and many othere clients)

See http://msdn2.microsoft.com/en-us/library/ms365406.aspx for further details or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=653115&SiteID=1

HANNES

|||

This is very encouraging news! Thank you.

Do you know if either

(1) ProClarity 6.1, or

(2) Strategy Companion

support MDX Compatibility = 2 ?

I'll check with the manufacturers myself and reply here with their responses.

Daniel

|||

Dan

Did you get a response from ProClarity? I have the same problem and want to set it to 2.

|||I did not get a response.

HideMemberIf OnlyChildWithParentName and member formula

Levels are defined using a SourceAttribute that points to an attribute used to create the level. In the definition of that attribute, the CustomRollupColumn points to a formula to be used in the custom rollup.

But if the level is hidden using HideMemberIf, does the level still participate - does that formula still get executed at query time?

In other words, are custom rollups still calculated, even if they are hidden using something like HideMemberIf?

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.