Hi,
I've deployed a simple cube with a time dimension on SQL 2005. I added the time intelligence which generated some calculations like Day over Day difference, Month over Month difference. If I drag it to row on a pivot table, the grand total of the measures cannot be shown.
Is it because the calculated member is not aggregatable? Is there any ways to show the grand total as well as those calculation on the pivot table?
Million Thanks.
KJ
Kelvin,
This is the intended behaviour. The calculations are written in such a way as to purposely place "NA" in cells where the calculated value would not make sense. For example, if you think of a YTD calculation in the context of all years, it doesn't really make sense; likewise for a year over year calculation.
-rob
No comments:
Post a Comment