Hi all,
how does the following mdx expression compute household count and account
count measures? It's an example from Microsoft BI Accelerator, Woodgrove
Bank example. I tried to recreate the cube (without the following expresion)
from the original oltp database but the results aren't the same as in the
original olap example.

CREATE CELL CALCULATION
CURRENTCUBE.[Closing Balance]
FOR '(Measures.AllMembers)'
AS 'CalculationPassValue(ClosingPeriod([Time].[Month]),4)',
CONDITION =
'Count(Intersect({[Measures].CurrentMember},{[Measures].[Household
Count],[Measures].[Account Count]}))>0 And Not IsLeaf([Time].CurrentMember)'

Kind regards,
Tudor