How to define these calc measures and in MDX -
05-16-2004
, 06:22 AM
I have the following calculated measures for forecast to be defined
from the forecast measure.
Forecast1 forecast for currentPeriod (Period is a dimension like
200301)
Forecast2 forecast for currentPeriod+2 (Period is a dimension like
200301)
Forecast3 forecast for currentPeriod+3 (Period is a dimension like
200301)
Forecast4 forecast for currentPeriod+4 (Period is a dimension like
200301)
Forecast5 forecast for currentPeriod+5 (Period is a dimension like
200301)
Forecast6 forecast for currentPeriod+6 (Period is a dimension like
200301)
Similaryly I have a dimension called CalMonth which as a property
called daysinmonth I want to define the following derived dimensions:
Mth1 = Days in currentmonth
Mth2 = Days in Currentmonth + 1
Mth3 = Days in Currentmonth + 2
Mth4 = Days in Currentmonth + 3
Mth5 = Days in Currentmonth + 4
Mth6 = Days in Currentmonth + 5
Please advise how I can implement in this in AS2K.
Thanks
Simon |