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] )
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.