Q:- I want to hide All in my dimension. How can I do it? Is it good to do it?
Ans:- In Analysis Service we generally see all dimension has All member. This is because of IsAggregatable property of the attribute. You can set its value to false, so that it will not show All member.
Its default member for that attribute. If you hide this member than you will have to set other attribute value to default member else it will pick some value as default and this will create confusion in browsing data if someone is not known to change in default member.
Its good to use it in ParentChild dimension where there is one root member in the hierarchy.
Lets SQL 
June 11, 2010 at 2:41 pm |
Hi. I have a parent-child dimension but with more than one root. My problem is that every time i extend a branch i can see the parent node exists as a child as well. You can't see this while browsing the cube, only by viewing the dimension members. I'm not quite sure if IsAggregateble will sort this out. Can u help me with this?