I have a dimension Customer for whom all members use unary operator ~. The
fact table links directly to this dimension.

everything is working well, except for the all level. The All level should
be the combined total of 2 of the members. I define the all member formula to
be the following:
Aggregate({[Customer].[Segment Name].&[member1],[Customer].[Segment
Name].&[member2]})

however is get all zeros for the all level.

even if I define the all member formula to be "1", i still get all zeros
uponw reprocessing. It seems as if the all level formula is being ignored.

ideas?

Thanks
Paul

I'm not sure whether it is bug or by design.

This is not best answer but you can get the results you want by using
calculated cells.

Ohjoo Kwon

"Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote

Thanks, I figured out the problem

Paul

"Ohjoo Kwon" wrote: