Hi All,

Since the regular roll-up did not work, I created a calculated member
that is the SUM of the values of three members which rolls up to its
parent. Now I need to hide these three members (Children).
For Example
‘All Time‘--> Quarter (Q1)---> Month (Jan, Feb, March)


MDX: iif([Time].currentmember.level.name= "Quarter",
--Then
Sum({[Time].currentmember.children},[Measures].[Sales]),
--Esle
null)
This works fine when the visible properties of ‘Month' level is set to
true.I.e it rolls up the month sales to quarter. But when hide the
Month level( Visible =False) it returns nothing. My question is, How
can access the descendants(e.g Months) of a member( e.g Quarter) when
the visible properties of descendants(e.g Months)level is set to
‘False'.

I want to hide the Month level from users, but I still want to access
the members within the calculation for roll-ups.

Hope my question is clear.

Thanks in advance.

Best regards,
Nik.