I have created a calculated member on a cube using the
following MDX:

ValidMeasure((
[Measures].[Number Of Passengers],
LinkMember(
[OperatingDate].[Calendar].CurrentMember,
[Leg Dept Date].[Calendar])))

The calculated member works fine, but at the All level it
errors.

Both dimensions are identical (other than the level names
used for each level). They contain the same levels. There
are multiple hierarchies for each dimension (Analysis
Server should treat them as separate dimensions).

I would appreciate any suggestions to solve this problem.

Regards,

Modesto

You need to special case the all member using IIF.

tom @ the domain below
www.tomchester.net


"Modesto Vega" <modestov (AT) clearviewbi (DOT) com> wrote

Could you please give an example?

Thanks,

Something like this...

IIF( OperatingDate.CurrentMember IS OperatingDate.DefaultMember,
ValidMeasure(Measures.[Number of Passengers], [Leg Dept
Date].DefaultMember),
ValidMeasure((
[Measures].[Number Of Passengers],
LinkMember(
[OperatingDate].[Calendar].CurrentMember,
[Leg Dept Date].[Calendar])))
)

tom @ the domain below
www.tomchester.net


"Modesto Vega" <anonymous (AT) discussions (DOT) microsoft.com> wrote