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.
No comments:
Post a Comment