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: __________________