November 7, 2002 at 4:01 am
I've created a ragged 3-level product dimension, with hidden members in the second level for most product groups. Browsing the dimension in AS looks like it's working fine, but trying to use Excel XP to view the data is not hiding the hidden members and skipping a level in the dimension structure, but showing the 2nd-level member.
Looking into the books online it says there are 3 things needed to get this working...
1 - defining the hidden members
2 - using a client that supports ragged dimensions with hidden members
3 - ensuring the MDX Compatability setting on the client connection is set to 2 (this is not the default setting).
I've obviously done step 1, but can't seem to find anything saying if Excel does or does not support ragged dimensions with hidden members. If it does then I hit the 3rd problem...where can I change the MDX Compatability setting for the Excel connection?
Can anyone assist?
November 10, 2002 at 6:23 pm
This was removed by the editor as SPAM
November 25, 2002 at 9:21 am
Excel and the Office Web Components intentionally ignore the Hide Member If property, because they don’t behave properly if placeholder members are hidden.
You can see what would happen by using the Analysis Manager browser: Put a dimension with hidden members on rows, and then drill down to the children of the hidden members. You can’t do it. You can’t drill “past” hidden members. This is essentially an artifact of using rigid columns for each level.
It is possible to make Excel hide the placeholders. You add the MDX Compatibility property to the connection string. But I don’t recommend it.
Scot J Reagin
Scot J Reagin
sreagin@hitachiconsulting.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply