Forecast Input Form Design - TechNet Forums

From Jon Crowell in the MSDN forums.  How to create a forecast input form with rolling actuals.

Try this:

1. You need scenario and months on the columns.

2. Select Actuals and Forecast in scenario.

3. In Time.YQM, select the first month of the year (or whatever range you want to display) and select "Add Range" from the Time drop-down.

4. Select "from member to current month"

Your selected member should look like this: [Time].[YQM].[All].[2008].[Q1 2008].[January 2008] : Current Month + 0

5. Select the last month of the year (or whatever range you want to display) and select "Add Range" from the Time drop-down.

6. Select "from current month to member".

7. Increase the month offset to 1. (You may decrease the previous range by 1 and leave this at 0 depending on how your current period is set up.)

Your selected member should look like this: Current Month + 1 : [Time].[YQM].[All].[2008].[Q1 2008].[December 2008]

8. Click OK.

9. Select Define member intersections for columns.

10. Select "column by column".

You should see Actual lined up with your first time range and Forecast lined up with your second range.

11. Refresh your report.

12. In report options, set "merge and center headers" to false.

This approach will require you to edit the ranges at the end of each year, but will dynamically update for all other times. You can make this completely dynamic using custom MDX, but it's a little more complicated.