In a Parent Child Dimension (PDC), using the MembersWithData property we can see whether we want to display child nodes with the same parent name or not. For example, if we have a table like this:
We expect to see this: (1)
But by default Analysis Services produce this: (2)
The above screenshot shows that, by default, Analysis Services gives us 1 more child node, which is the parent.
To get (1), change the MembersWithData property from NonLeafDataVisible to NonLeaveDataHidden, like this:
We need to set this MembersWithData property on the parent key column, not on the dimension key column.
Thank you to Mourad Faiz for bringing this to my attention. As always I welcome corrections and discussion at vrainardi@gmail.com. Vincent 27/2/11.
Leave a Reply