Web Report Studio Using OLAP Year over Year calculation -
03-22-2010
, 02:16 PM
I currently have a calculated member in an OLAP cube to calculate Year
over Year differences (code below).
(([CUBE].[Revenue],[Fiscal_Year].CurrentMember) -
([CUBE].[Revenue],[Fiscal_Year].CurrentMember.PrevMember)),
FORMAT_STRING="DOLLAR15."
When I display this calculated member in WRS, I get unexpected
results. I would expect that the calculated member for the first time
period would be NULL or zero. Instead, it just displays the revenue
from the first time period. Example:
Year Revenue Calculated Member Expected Results
1 800 800 -
2 1000 200 200
3 1500 500 500
Is there a way to adjust my code or WRS settings to zero out or not
show the calculated member for the first time period?
Thanks,
Carrie |