Building Rolling Forecast Reports in Financial Reporting


Purpose


This tutorial covers building rolling forecast reports in Financial Reporting for Essbase and Financial Management data sources.

Time to Complete


Approximately 30 minutes

Topics


This tutorial covers the following topics:

Overview
Scenario
Prerequisites
Creating a rolling forecast report for an Essbase data source
Creating a rolling forecast report for a Financial Management data source
Summary
Related Information

Viewing Screenshots


Click icon to show all screenshots Click icon to show all screenshots

Note: Alternatively, you can click an individual icon (or image) associated with each step to view (or hide) the screenshot associated with that step.

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.

After setting up the periods and scenarios in the columns, you use conditional suppression to display the columns correctly when you select any period in the user Point of View (POV).

Back to Topic List

Scenario


As a report designer, you are tasked with creating rolling forecast reports for an Essbase or Financial Management data source.

Back to Topic List

Prerequisites


Before starting this tutorial, you should:

1.Have access to a data source, such as a Financial Management application or an Essbase database.
2.Have access to Reporting Studio release 9.3.1 or higher.
3.Have experience in creating basic reports in Reporting Studio.

Back to Topic List

Creating a rolling forecast report for an Essbase data source


To create a rolling forecast report for an Essbase data source, perform these 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 in the rows.

 

2.

Select column A, and select Insert > Column > 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.

In this example, you select the Children of Profit and Profit accounts.

 

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 the 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 > 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 if 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 if 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.

Back to Topic List

Creating a rolling forecast report for a Financial Management data source


To create a rolling forecast report for a Financial Management data source, perform these steps:

1.

In Reporting Studio, create a report and insert a grid for a Financial Management 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 Comma application, add the Period and Scenario dimensions to the columns, and the Account dimension to the rows.

 

2.

Select column A, and select Insert > Column > 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 Account dimension.

In this example, you select the Children of OperatingExpenses and OperatingExpenses accounts.

 

4.

For the Scenario dimension in column A, select Actual.

 

5.

For the Period dimension in column A, use the Range function to select the range of periods from January to Current Point of View for Period.

 

6.

For the Scenario dimension in column B, select Budget.

 

7.

For the Period dimension in column B, use the Range function with the PeriodOffset function to select the range of periods from Period Current Point of View for Period offset by 1 to December.

 

8.

For the Scenario dimension in column C, select Budget.

 

9.

For the Period dimension in column C, select the Current Point of View for Period.

 

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.

For the Comma application, set the user POV to these selections, and then select File > Print Preview to preview the report.

DimensionMember
Year2006
PeriodApril
ViewPeriodic
EntityGeographical
Value<Entity Currency>
ICP[ICP None]
ProductTotalProducts
CustomersTotalCustomers
Channel[None]
UnitsFlows[None]

 

The report displays Actual data from January through April, and Budget data from May to December.

However, if you change the user POV from April to December and preview the report, it displays Actual data from January to December, and Budget data from January to December.

In this example for the Comma application, Budget data for the following year contains missing data.

 

12.

To suppress the twelve Budget columns when the user POV is set to December, 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 if the period member is December.

 

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 if column C is suppressed. This suppression setting will suppress column B when the user POV for the Period dimension is December.

 

16.

In the user POV bar, set the Period dimension to December, and preview the report.

The report displays Actual data from January through December. Since the user POV is set to December, the budget data columns are suppressed.

Back to Topic List

Summary


In this tutorial, you've learned how to:

Create a rolling forecast report for an Essbase data source
Create a rolling forecast report for a Financial Management data source

Back to Topic List

Related Information


To learn more about Financial Reporting, refer to additional OBEs..

Back to Topic List

Left Curve
Popular Downloads
Right Curve
Untitled Document
Left Curve
More Middleware Downloads
Right Curve