Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with calculated member and currentmember

Status
Not open for further replies.

tarikqazza

Programmer
Nov 4, 2010
9
0
0
FR
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top