Hi all,

I'm using AS 2000 with SQL server 2000.

I have 2 shared dimension Hierarchy and ActiveHierarchy that are used
in a multi-partition cube. Each of the dimension have 6 levels. As the
name indicates, 'ActiveHierarchy' will show only active members of all
levels where as 'Hierarchy' will show all members. (I have achcieved
this by creating a new view for 'ActiveHierarchy' that selects blank
values for inactive members and by using "Hide Member If" property of
dimension to hide out blank members.)

My problem is the aggregation of Levels in 'ActiveHierarchy'
dimensions. Say, if in Level05, I have two inactive members that are
hidden to the users, parent member in Level04 aggregates the measures
against the hidden members too. I need to avoid this and I guess I can use
Custom
rollup formula for dimension members in Level04.

1. Can some one help with the formula. I need something like this
Sum (If Member.Children.Name = '', 0, Member.Children)

2. I tried using Unary Operator (~ for unactive hidden members and +
for all other members) but it does not work. Can someone explain why
this does not work if used in tandem with "Hide Member If" property.

Thanks in advance,
Space_AD