Overview
In Financial Reporting, you create rolling forecast reports to display data for multiple periods and scenarios. For example, you display actual data from the beginning of the year to the current month, and budget data from the following month to the end of the year.
When you select April for the current month in the user Point of View (POV), the rolling forecast report displays Actual data from January through April, and Budget data from May to December.
Creating a Rolling Forecast Report for an Essbase Data Source
To create a rolling forecast report for an Essbase data source, perform the following steps:
1 .In Reporting Studio, create a report, and insert a grid for an Essbase data source. Place the period and Scenario dimensions in the columns, and a dimension of your choice in the rows.
In this example, you use the Sample:Basic database, add the Year and Scenario dimensions to the columns, and the Measures dimension to the rows.
2 .Select column A, and select Insert, then Column, and then Data to insert a data column after column A. Repeat this command to insert a third column in the grid.
In this example, you select the Children of Profit and Profit accounts.
3 .Select row members for the Measures dimension.
4 .For the Scenario dimension in column A, select Actual.
5 .For the Year dimension in column A, use the Range function to select the range of periods from Jan to Current Point of View for Year.
6 .For the Scenario dimension in column B, select Budget.
7 .For the Year dimension in column B, use the Range function with the RelativeMember function to select the range of periods from Current Point of View for Year offset by 1 to Dec.
8 .For the Scenario dimension in column C, select Budget.
9 .For the Year dimension in column C, select Current Point of View for Year.
10 .Select column C, and from the Column C Properties sheet, select Hide Always.
You hide column C so it does not display in the report. Later, you will use column C to define conditional suppression options for the report.
11 .In the user POV, set the Year dimension to Apr, the Product dimension to 100, and the Market dimension to East. Select File, and then Print Preview to preview the report.
The report displays Actual data from January through April, and Budget data from May to December.
However, if you change the user POV from Apr to Dec and preview the report, it displays Actual data from Jan to Dec, and Budget data from Jan to Dec.
12 .To suppress the twelve Budget columns when the user POV is set to Dec, you apply conditional suppression.
Select column C. From the Suppression area of the Column C Properties sheet, select Advanced Options, and click Setup.
13 .In the Conditional Suppression dialog box, enter the options to suppress column C when the period member is Dec.
14 .Select column B. From the Suppression area of the Column B Properties sheet, select Advanced Options, and click Setup.
15 .In the Conditional Suppression dialog box, enter the options to suppress column B when column C is suppressed. This suppression setting will suppress column B when the user POV for the Year dimension is Dec.
16 .In the user POV bar, set the Year dimension to Dec, and preview the report.
The report displays Actual data from January through December. Since the user POV is set to Dec, the budget data columns are suppressed.
In Financial Reporting, you create rolling forecast reports to display data for multiple periods and scenarios. For example, you display actual data from the beginning of the year to the current month, and budget data from the following month to the end of the year.
When you select April for the current month in the user Point of View (POV), the rolling forecast report displays Actual data from January through April, and Budget data from May to December.
Creating a Rolling Forecast Report for an Essbase Data Source
To create a rolling forecast report for an Essbase data source, perform the following steps:
1 .In Reporting Studio, create a report, and insert a grid for an Essbase data source. Place the period and Scenario dimensions in the columns, and a dimension of your choice in the rows.
In this example, you use the Sample:Basic database, add the Year and Scenario dimensions to the columns, and the Measures dimension to the rows.
2 .Select column A, and select Insert, then Column, and then Data to insert a data column after column A. Repeat this command to insert a third column in the grid.
3 .Select row members for the Measures dimension.
4 .For the Scenario dimension in column A, select Actual.
5 .For the Year dimension in column A, use the Range function to select the range of periods from Jan to Current Point of View for Year.
6 .For the Scenario dimension in column B, select Budget.
7 .For the Year dimension in column B, use the Range function with the RelativeMember function to select the range of periods from Current Point of View for Year offset by 1 to Dec.
8 .For the Scenario dimension in column C, select Budget.
9 .For the Year dimension in column C, select Current Point of View for Year.
11 .In the user POV, set the Year dimension to Apr, the Product dimension to 100, and the Market dimension to East. Select File, and then Print Preview to preview the report.
However, if you change the user POV from Apr to Dec and preview the report, it displays Actual data from Jan to Dec, and Budget data from Jan to Dec.
12 .To suppress the twelve Budget columns when the user POV is set to Dec, you apply conditional suppression.
Select column C. From the Suppression area of the Column C Properties sheet, select Advanced Options, and click Setup.
13 .In the Conditional Suppression dialog box, enter the options to suppress column C when the period member is Dec.
14 .Select column B. From the Suppression area of the Column B Properties sheet, select Advanced Options, and click Setup.
15 .In the Conditional Suppression dialog box, enter the options to suppress column B when column C is suppressed. This suppression setting will suppress column B when the user POV for the Year dimension is Dec.
16 .In the user POV bar, set the Year dimension to Dec, and preview the report.
No comments:
Post a Comment