CalPlanning: Intro & Reporting - Exercise 1

Exercise 1

Identifying Your Point of View (POV)

Write your answers on a piece of paper or in an online document.

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? 

Dimension Dimension Member
Year
Period
Time Series
Scenario
Version
Entity

2. Select the scenario and version from the bulleted list below that you will need to derive each report:

Report Scenario Version
Actual revenue and expenses
Most current version of the plan for next year
Budget that was committed at the beginning of the year
  • Actual
  • Final
  • Forecast
  • Initial
  • Operating Budget
  • Working

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.

Report Year Scenario Version
Budget for all of next year
Actuals for second quarter of this year
This year through December
  • YearTotal
  • Q2
  • Q4
  • December
  • FY22
  • FY23
  • FY24
  • Periodic
  • Year to Date

See the answer sheet to check your understanding. Review content in this chapter as needed.