Building Rolling Forecast Reports in Financial Reporting

<Do not delete this text because it is a placeholder for the generated list of "main" topics when run in a browser>

Purpose

In this tutorial, you learn how to build rolling forecast reports in Oracle® Hyperion Financial Reporting, Fusion Edition for Oracle® Essbase and Oracle® Hyperion Financial Management, Fusion Edition data sources.

Time to Complete

Approximately 30 minutes.

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.

Scenario

In Oracle® Hyperion Financial Reporting Studio, Fusion Edition (Reporting Studio), you create rolling forecast reports for Essbase and Financial Management data sources.

After setting up the periods and scenarios in the columns, you use conditional suppression to display the columns correctly when you select the current period in the user POV.

Prerequisites

Before starting this tutorial, you should:

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:

.

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.

 

.

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.

 

.

Select row members for the Measures dimension.

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

 

.

For the Scenario dimension in column A, select Actual.

 

.

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.

 

.

For the Scenario dimension in column B, select Budget.

 

.

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.

 

.

For the Scenario dimension in column C, select Budget.

 

.

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

 

.

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.

 

.

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.

 

.

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.

 

.

In the Conditional Suppression dialog box, enter the options to suppress column C when the period member is Dec.

 

.

Select column B. From the Suppression area of the Column B Properties sheet, select Advanced Options, and click Setup.

 

.

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.

 

.

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.

 

Creating a Rolling Forecast Report for a Financial Management Data Source

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

.

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.

 

.

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.

 

.

Select row members for the Account dimension.

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

 

.

For the Scenario dimension in column A, select Actual.

 

.

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.

 

.

For the Scenario dimension in column B, select Budget.

 

.

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.

 

.

For the Scenario dimension in column C, select Budget.

 

.

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

 

.

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.

 

.

For the Comma application, set the user POV to the selections in the following table:

Select File, and then Print Preivew 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 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.

 

.

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.

 

.

In the Conditional Suppression dialog box, enter the options to suppress column C if the period member is December.

 

.

Select column B. From the Suppression area of the Column B Properties sheet, select Advanced Options, and click Setup.

 

.

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.

 

.

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.

 

Summary

In this tutorial, you should have learned how to:

Resources

Hardware and Software Engineered to Work Together About Oracle | Oracle and Sun | Oracle RSS Feeds | Subscribe | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights