I have a very simple cube consisting of two dimensions and one measure. The
first dimensions is an ordinary Time-dimension (Year, Month, Quarter, Day)
and the second Flow_type, is a flat dimension with just three members, 1=
Opening Balance, 2 = In, 3 = Out.

In the Calculated Members Builder created a Calculated Measure with the
following syntax
Iif([Flow_Type] = 0, [Measures].[Quantity], Null)

I don’t get any syntax error when I click the Check-button, but something is
wrong because the Calculated Measure just returns “Err”. What’s wrong?

--
Not a Guru