Exercise 1

Exercise 1: Identifying Your Point of View (POV)

1. You want to run a CalRptg report to review your current year Forecast that reflects all of the reforecasting you have done to date. Which Dimension Members would you select to return this data? Write your answers on a piece of paper or in an online document.

Period: 

Year:

Scenario:

Version:

Entity:

2. Select the scenario and version from the bulleted list that you will need to derive each report. The first example is completed for you.

Versions and Scenarios:

  • Actual
  • Final
  • Forecast
  • Initial
  • Operating Budget
  • Working

a. Actual revenue and expenses

Scenario: Actual     Version: Final

b. Most current version of the plan for next year

Scenario: _____________     Version: ____________

c. Budget that was committed at the beginning of the year

Scenario: _____________     Version: ____________

3. Select the Year, Period, and Time Series from the bulleted list below that you will need to derive each report. You may use an item more than once. Some items will not be used at all. And there may be more than one correct answer for a report. The first example is completed for you.

Period, Year, and TIme Series:

  • YearTotal
  • Q2
  • Q4
  • December
  • FY23
  • FY24
  • FY25
  • Periodic
  • YearToDate

a. Budget for all of next year

Year: FY25     Period: YearTotal     Time Series: Periodic

Year: FY25     Period: YearTotal     Time Series: YearToDate

b. Second quarter of this year

Year: _______     Period: ____________     Time Series: __________________

c. This year through December

Year: _______     Period: ____________     Time Series: __________________


Check your understanding.