Re: Calculated Member Issue -
07-08-2003
, 10:41 AM
More information...
The problem looks to be related to the "All Level" of the Pricing Type
dimension. As long as the measures selected are based off of the
Pricing Type dimension "all" level, then what I experience is that the
CostPerUnit calculated member cell generates an #ERR as its value.
When I click on the cell, it says that the property "Unit Type" is not
valid. If I set the "All Level" to "no" in the Pricing Type dimension
properties, then I get the desired result meaning the CostPerUnit
calculated member is being calculated properly for any variations of
filter, row, or column combinations with one exception. The problem
is that the measures represented are only those of the first Pricing
Type member. When I include the Pricing Type dimension as a filter,
row, or column selection then all Pricing Type members are included.
It looks like I need the "All Level" of the Pricing type dimension, so
how do I get around this issue?
By the way, I thing I accidently posted an experimental mdx statement
in my initial description. Please review the statement below.
IIF ([Measures].[Revenue Gross] <> 0,
IIF ([Pricing Type].CurrentMember.Properties("Unit Type") =
"impressions" and [Measures].[Impressions] <> 0,
Val([Measures].[Revenue Gross] / [Measures].[Impressions]) *
Val([Pricing Type].CurrentMember.Properties("Divisor")),
IIF ([Pricing Type].CurrentMember.Properties("Unit Type") =
"clicks" and [Measures].[Clicks] <> 0,
Val([Measures].[Revenue Gross] / [Measures].[Clicks]) *
Val([Pricing Type].CurrentMember.Properties("Divisor")),
0)
),
0)
Thanks again to all of those who respond. |