all member property | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

all member property

Month Dimension: All Month
–Jan
–Feb
.
.
.
–Dec All memeber property for month dimesion configure as mdx below :
max(descendants([DimMonth_HeadCnt].currentmember,[Mth]),[Measures].[No Head]) Problems :
The result show as below and it works fine at the pivot (excel).
All Month $1000
Jan $100
Feb $200
Mac $100
Apr $900
May $100
Jun $200
Jul $1000
Aug $200
Sep $300
Oct $300
Nov $200
Dec $300 But if user go to the pivot and select the filtering criteria to uncheck the Jul criteria, then result for ‘All Month’ still show $1000 instead of $900 as below: All Month $1000
Jan $100
Feb $200
Mac $900
Apr $100
May $100
Jun $200
Aug $200
Sep $300
Oct $300
Nov $200
Dec $300
Any idea to solve this issue?
Thanks.

]]>