Hi.

In a cube with some common dimensions (Accounts, Products, Time,
Organization) i do have a measure (NoAccounts) which distinct counts the
number of accounts. I need a calculated member to represent the difference
between the value of [NoAccounts] corresponding to the [Products].[All
Products] member and the value of the same measure [NoAccounts] for the
CurrentMember selected in [Products] dimension.

TIA,
Rud

Hi. I found a solution and i show it to all of you interested:
Obviously, the similar but simplified problem is to produce a calculated
member which shows up the value of [NoAccounts] corresponding to the
[Products].[All Products] member for every cell. And the formula for that
is:

Iif([Products].CurrentMember Is [Products].[All Products] ,
[Measures].[NoAccounts] , [Products].[All Products])

which is a little bit strange because of the [Products].[All Products] from
the last part of IIF (how AS does it ??).
The second calculated member is a simple difference.
Rud

"Rud" <Rud_75 (AT) hotmail (DOT) com> wrote