Prev: Date Conversion
Next: univariate default tables
From: Carrie Wilmoth on 22 Mar 2010 12:02
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

 | 
Pages: 1
Prev: Date Conversion
Next: univariate default tables