Sorry, I still haven't figured this one out...?

Hello,

I am using SSAS 2005, June CTP.

I have a question concerning a parent-child dimension I created. My roll-up
totals are messed up. When a expand the hierarchy to display the children I
noticed that the parent is displayed again and it's values are included in
the total. How do I make it stop doing this?

Thanks for any help you can provide.

-Scott

Sounds like your fact table has data that is directly associated with
non-leaf (parent) members of the dimension. In that case, this parent
data will be rolled up in AS 2005 (unless excluded by a custom rollup);
but you can control whether it is visible as a child Data Member or not:

http://msdn2.microsoft.com/en-us/library/ms174581.aspx
...
Setting the MembersWithData property to NonLeafDataHidden hides data
members contained by the parent attribute, while setting the property to
NonLeafDataVisible exposes data members. This setting does not override
the normal aggregation behavior for nonleaf members; the data member is
always included as a child member for the purposes of aggregation,
although a custom rollup formula can be used to override this behavior.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***