Hi all,

I have some MDX written by someone else which works fine when I use my
Product dimension (and with my time dimension), however, it doesn't work
when I use a different dimension (Location)

All I am trying to do is to perform a calculation of a measure that works
when using all my dimensions.

What is strange is that the calculation works when i use a Time dimension,
but not my Location dimension.
Why should AS2000 care? After all, a dimension is just a dimension, isn't
it?

Calulated Measure is as follows

iif([Product_New].CurrentMember.Name = "All
Product",([Measures].[Value],[Product_New].[Product
Type].[Concessions]),iif(Ancestor([Product_New].CurrentMember,[Product
Type]).Name =
"Concessions",([Measures].[Value],[Product_New].CurrentMember),NULL))/([Measures].[Quantity],
[Product_New].[Product Type].[Tickets/Other])



The other dimension that i want the same MDX applied to is
Dimenion name = Location
Levels (just one) = Parent Location with 6 members.

Hope this makes sense?

Regards
Immy