11 Reporting Administration Task

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 1461281.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 build a Reporting Administration workbook, perform the following steps:

In the MFP Admin activity, click the New Workbook icon in the Reporting Administration task.

Figure 11-1 Reporting Administration Task
The workbook wizard opens at the Product Selection step. Select the departments you want to see and click Finish.

Figure 11-2 Reporting Administration Workbook Wizard - Product Selection

The Reporting Administration workbook is built.

Reporting Administration at Department View

Use this view 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 11-3 Reporting Administration at Department View

Reporting Administration at Class View

Use this view 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 11-4 Reporting Administration at Class View

Reporting Administration at Sub-Class View

Use this view 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 11-5 Reporting Administration at Sub-Class View