SQLTeam.com | Weblogs | Forums

SSAS Calculated Member Not Displaying Data


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 ?


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


This is what I have in my calculated member:

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

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