problem with calculated member and currentmember

[tarikqazza]

Hello,

I have a [Product] dimension that is a hierarchy of product category.

I've created a new calculate members, such as:

CODE
With

Member [Product].[Category].[MyCar] as '[Product].[Category].[Ferari_Auto]'

Along with that, I've created a calculated measure that returns a price :

CODE
Member [Measures].[Price] as 'Iif ([Product].[Category].CurrentMember is null, null, ([Product].[Category].CurrentMember, [Measures].[DollarPrice]))'


Product Price

Wolsvaguen 1233
Ferari_Auto 1456
MyCar null

The only problem is that I continuously get NULL price for [MyElement] calculated member. I'm suspecting that the expression
Product.category.CurrentMember give Null for calculated memeber (why?)

is there a better way to resolve this problem this?

Thanks!
I see the same problem in this thread :
thread450-1422482