Reporting with SAP BW (SAP Library

Reporting with SAP BW

Purpose

The store manager has several reporting options at his/her disposal, especially for employees’ shifts and business volume. In contrast to reports in SAP CAMPBELL StaffWorks, which are restricted to figures from one retail store, a report in SAP Business Information Warehouse (SAP BW) can be run to include each individual store. SAP BW integrates the data from different SAP applications, and thus provides an enterprise-wide overview.

You can evaluate the following data:

Actual and planning working times, standard working time, and overtime
Actual and planned salaries (such as for standard working time, and overtime, for example)
Workload: anticipated number of personnel required (in working hours) for each job
Shift statistics, with times when target coverage is exceeded, or not reached
Actual business volume
Planned business volume (according to head office)
Anticipated business volume development, in accordance with algorithm of SAP CAMPBELL
Sales figures from previous year
Evaluation of customer-specific business indicators (such as the volume of business in individual departments, for example, the Menswear department in a department store).

SAP BW contains statistics and reports from practically every SAP application. For example, Payroll transfers wage and salary information to SAP BW. A user role or authorization concept is used to regulate access to data stored in SAP BW.

For more information, see the documentation provided on SAP Business Information Warehouse.

Prerequisites

You have implemented SAP CAMPBELL StaffWorks and SAP CAMPBELL Time & Attendance in the retail store.

You have transferred shift, personnel cost and business volume figures to the SAP CAMPBELL infocubes in SAP BW.

Process Flow

During the week, retail stores regularly (for example, on a daily basis) upload the following data to SAP BW:

Actual and planned data from the previous week
Planned data for the current week, and the actual data from the current week, up to the previous day inclusively
Planned data for the next week

It is possible that the data in SAP BW will not be up-to-date until the next upload of data, as data may have been changed in the retail store. For example, the store manager may edit data relating to the previous working day.

Depending on their level of responsibility, role holders can access data in SAP BW. You can also evaluate by level - such as by store, by region, or by any company code, for example.

The data in SAP BW is updated when you next upload data.

Optional: If you use a business scenario that runs payroll-relevant time evaluation in SAP HR, ( SAP CAMPBELL scenario), you can regularly download time evaluation results from SAP HR to the retail stores.

The SAP HR Time Evaluation results overwrite SAP CAMPBELL Time & Attendance Time Evaluation results in the retail store. They are then uploaded to SAP BW, and can be used in reports.