12 Reporting Administration

The Reporting Administration workbook is used to facilitate the Oracle Retail Fashion Planning Bundle Reports. These reports are unsupported samples provided by Oracle Retail.

The Oracle Retail Fashion Planning Bundle Reports package includes role-based Oracle Business Intelligence (BI) Enterprise Edition (EE) reports and dashboards that provide an illustrative overview highlighting the Fashion Planning Bundle solutions. These dashboards can be leveraged out-of-the-box or can be used along with the other dashboards and reports that may have already been created to support a specific solution or organizational needs. This package includes dashboards for the Assortment Planning, Item Planning, Item Planning Configured for COE, Merchandise Financial Planning Retail Accounting, and Merchandise Financial Planning Cost Accounting applications.

The Oracle Retail Fashion Planning Bundle Reports documentation set includes the following documents that describe how you can install and use the reports and dashboards:

Oracle Retail Fashion Planning Bundle Reports Installation Guide - This guide describes how you can download and install the Fashion Planning Bundle reports. This guide is intended for system administrators and assumes that you are familiar with the Oracle Retail Predictive Application Server (RPAS) and Oracle BI EE.
Oracle Retail Fashion Planning Bundle Reports User Guide - This guide describes the reports and dashboards included for the Oracle Retail Fashion Planning Bundle solutions.

You can download this documentation set from My Oracle Support using the Note ID 1132783.1. Access My Oracle Support at the following URL:

https://support.oracle.com

The Reporting Administration workbook in MFP is used to define a threshold between actual sales and planned sales. This threshold is used to highlight sales data in the Oracle BI EE reports. Sales that fall below the threshold appear in red. Sales above the threshold appear in green.

Reporting Administration Wizard

To open a Reporting Administration workbook:

Select New from the File menu, or click the New button in the toolbar.
On the Planning Admin tab, select Reporting Administration and click OK.

Figure 12-1 Creating a New Reporting Administration Workbook
The Available Departments step appears. Select the departments you want to examine and click Finish.

Figure 12-2 Reporting Administration Wizard: Available Departments

The Reporting Administration workbook is built.

Reporting Administration at Sub-Class Worksheet

Use this worksheet to define a threshold between the actual sales and the planned sales for each subclass. This threshold is used to highlight sales data in the Oracle BI EE reports. Sales that fall below the threshold appear in red. Sales above the threshold appear in green.

Enter a threshold percentage in the Wp User-Defined Performance Threshold measure. When finished, commit the workbook.

Figure 12-3 Reporting Administration at Sub-Class Worksheet

Reporting Administration at Class Worksheet

Use this worksheet to define a threshold between the actual sales and the planned sales for each class. This threshold is used to highlight sales data in the Oracle BI EE reports. Sales that fall below the threshold appear in red. Sales above the threshold appear in green.

Enter a threshold percentage in the Wp User-Defined Performance Threshold measure. When finished, commit the workbook.

Figure 12-4 Reporting Administration at Class Worksheet

Reporting Administration at Department Worksheet

Use this worksheet to define a threshold between the actual sales and the planned sales for each department. This threshold is used to highlight sales data in the Oracle BI EE reports. Sales that fall below the threshold appear in red. Sales above the threshold appear in green.

Enter a threshold percentage in the Wp User-Defined Performance Threshold measure. When finished, commit the workbook.

Figure 12-5 Reporting Administration at Department Worksheet