SQLTeam.com | Weblogs | Forums

SSAS Calculated Member Not Displaying Data


#1

I created a calculated member which is supposed to pull the value from a field in a dimension. However, the calculated member field contains no data in the pivot table. What could be causing this ?


#2

I suspect lots of things. Can you give some specifics?


#3

This is what I have in my calculated member:

Case
When IsEmpty( [Items].[Item Shipping Weight] )
Then 0
Else [Items].[Item Shipping Weight].CurrentMember / 9 *
[Measures].[Base Qty Sold - Detail]
End

If I have create a calculated member with just the [Items].[Item Shipping Weight], it appears blank.