I am trying to use a property member in a calculated member.
I would like to sum a member property at the item level called "retail
price". So following is what I have done.

SUM(DESCENDANTS([Item Nbr].[All Item Numbers],1),VAL([Item
Nbr].CurrentMember.Properties("Present Retail")))

The sum is $12,000,000.

The problem with this is that when I drill down on the items, it holds the
sum of $12,000,000 for each item. It needs to be dynamic. If I drill down,
I just want to see the present retail price for each item, when I drill up, I
want to see the $12,000,000.

Any help is appreciated.
TC
tclauer (AT) badcock (DOT) com
12/21/2004

The expression should evaluate all descendants of the current (rather
than of a fixed) member of [Item Nbr]:

VAL([Item Nbr].Properties("Present Retail")))

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank you Deepak. You have been helpful. The MDX worked as far as drilling
down and up on the item dimension. It kept the total, and I will keep it for
future reference, but it will not slice by the other dimensions. It keeps
the same amount at every level in the other dimensions. The MDX needs to be
dynamic across all dimensions.
Any other thoughts would be much appreciated.
TC

"Deepak Puri" wrote:

Since the "Present Retail" Property belongs to the [Item Nbr] dimension,
I am unclear as to how it should be sliced on other dimnsions - can you
give some examples?


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!