Operational InfoCube

Technical Name: 0RC_MC01

Use

As of release 2.0B this MultiCube version of the Operational InfoCube supersedes the previous version (technical Name: 0RC_C03). This MultiCube includes all queries that were hitherto defined in InfoCube 0RC_C03.

This InfoCube combines sales and labor-related information. Based on this set of information it is possible to model calculated key figures such as "Sales per (Labor) Hour" or "Labor Percent" (percentage of labor cost compared with sales) which combine sales and labor information and which are key indicators in the retail industry.

Sales information is presented at the following level:

  • Store
  • Business indicator: a more detailed level of sales reporting. In a grocery store, a business indicator would be, for example, meat sales, produce or dairy sales. In a department store, a business indicator would be, for example, men’s, women’s or children’s sales. With SAP StaffWorks, clients can set up any type of business indicator they choose.

Labor information is presented at the following level:

  • Store
  • Job: each employee can be assigned a number of different jobs, with one of them defined as his primary job. All data stored within SAP StaffWorks is aggregated in BW at job level.

This InfoCube contains information available in the current extraction file, that is, data delivered from SAP StaffWorks.

SAP StaffWorks uses the following terms when referring to labor and sales key figures:

Term

Description

scheduled hours

Labor representing shifts scheduled by SAP StaffWorks and/or edited by the manager

workload hours

Labor representing the manpower demand for the work to be done. Scheduled hours are the 'supply' ideally placed to cover the workload 'demand'.

actual hours

Labor representing shifts actually worked. In an ideal scenario, the actual hours should be placed exactly where the workload demand is placed and the schedule was created to cover that demand.

planned sales

Budgeted sales figures supplied by the corporate headquarters

system sales

Sales forecast computed by algorithms from SAP StaffWorks

manager sales

Adjustments made by the user to the SAP StaffWorks‘ forecast

actual sales

Sales actually reported on that day. Ideally, it should match the plan, system and manager forecast

In SAP BW, if stores upload data twice for a specific day, the new data is not added to the existing values but the old data is completely replaced by the newest data. For example, if store_1 uploaded $100 for July 10, 1999 and business indicator_2 (dairy products), and if the same store then uploads $125 for the same date and business indicator, the update rules for the SAP StaffWorks integration InfoCubes replace the value $100 by $125. BW standard update rules would add both figures together to a total $225.

Comments on queries from InfoCube 0RC_MC01

Some key figures are marked as hidden because they are part of the query definition but are not displayed when you run the query.

When comparing actual with planned values it can happen that planned values but no corresponding actual figures are available. This may cause problems for interpreting aggregated key figures that compare actual with scheduled data. To solve this problem, the following calculated key figures were introduced:

  • Net Plan or Net Scheduled key figures describe the planned value of only those stores that reported information for the particular time period. This will allow users to see only planned vs. actual figures for stores that have both planned and actual figures. For example, if nine stores reported $100 actual sales for the day and one store was missing, there would be $900 of Actual Sales. If all ten stores in the district had planned to sell $100, the actual vs. planned figures would be 900 divided by 1000 or 90 % of plan. This indicates results that are below expectation. However, if you compare the actual figures vs. the net plan (plan for reporting stores) this would be 900/(1000-100) or 900/900 = 100 % of plan. This indicates good performance. Whenever some stores do not report actual values, the comparison of actual vs. planned numbers will be misleading unless they have been "cleaned" by using net plan or projected values.
  • Projected key figures are a projection of certain values under the assumption that all stores reported that information for the particular time period. This will allow users to have a best estimate for when a single store or group of stores does not report for a specific time period. Usually, the planned or scheduled data is used as a substitute for actual data to allow this projection. For example, if nine stores reported $100 for the day and one store did not report the $75 planned sales may be substituted for the missing figure to give us a total of $975 projected sales for the day.

InfoSources

0RC_CI_1 Labor

0RC_CI_2 Sales

Characteristics

InfoObject

Description

0RC_STORE

Store

0RC_BUS_ID

Business indicator

0RC_JOB

Job

0RC_DAYWK

Day of week (Monday, Tuesday...)

Time Characteristics

InfoObject

Description

0CALDAY

Calendar day

0CALWEEK

Calendar week

0FISCPER

Fiscal period / year

0FISCVARNT

Fiscal year variant

Key Figures

InfoObject

Description

TOT_WL

Total workload: the total number of forecast hours. This is the sum of flowed and filler workload.

0RC_FLOW_WL

Flowed workload: workload dynamically driven by revenue, customer count or any other variable flowed task defined in SAP StaffWorks. Includes the static workload.

0RC_FILL_WL

Filler workload: the fixed and variable filler hours allocated to the workload. In contrast to static workload that has to be scheduled for certain times (for example, 9 a.m. to 10 a.m.), filler workload refers to non-selling tasks that can be scheduled variably within certain time segments (for example, in the morning). As a rule, filler workload fills the gaps between workload peaks.

0RC_STAT_WL

Static workload: work manually defined by the user. It is constant and independent of revenue, customer count or any business indicator or task defined in SAP StaffWorks (for example, the person who unlocks the store).

0RC_SYSFCST

Sales forecast by the system

0RC_OVRSTFF

Overstaffing: the number of hours in which the total workload is smaller than the number of people scheduled and not on an unpaid break

0RC_UNDSTFF

Understaffing: the number of hours in which the total workload is greater than the number of people scheduled and not on an unpaid break

0RC_EFFHRS

Effective hours: the scheduled hours minus overstaffed hours minus breaks. The values will be zero for events (for example, training or meetings) because these are not scheduled. From the perspective of SAP StaffWorks, effective hours are scheduled hours that match the workload hours. They are a general measure of schedule quality.

0RC_NEFFHRS

Non-effective hours: the sum of overstaffing and understaffing for the day. The values will be zero for events (for example, training or meetings), fixed shift and temporary fixed shift job types, because these are not scheduled. Non-effective hours could, for example, be spent working on the shop floor and be paid while SAP StaffWorks calculated no corresponding demand.

0RC_COREAFT

Core afternoon hours: the number of hours of core coverage as part of the workload for the afternoon segment. Core coverage means that employees with a particular job-specific minimum skill level must be scheduled.

0RC_COREEVN

Core evening hours: the number of hours of core coverage as part of the workload for the evening segment. Core coverage means that employees with a particular job-specific minimum skill level must be scheduled.

0RC_COREMRN

Core morning hours: the number of hours of core coverage as part of the workload for the morning segmen

0RC_PAIDBR

Paid breaks: the number of hours of scheduled paid breaks.

0RC_NPAIDBR

Unpaid breaks: the number of hours of scheduled unpaid breaks.

0RC_MANEDIT

Manual edits: manual changes to the system-generated staffing schedule. The number of scheduled days (shifts) that have been manually edited for every employee. Edits are attributed to each employee's primary job.

0RC_RULVIOL

Number of employees with violations of scheduling work rules assigned to the primary job

0RC_SCDHRS

Scheduled hours : total number of scheduled hours that are not unpaid breaks. This includes all hours scheduled (regular, overtime, vacation, and so on).

0RC_SCDEHRS

Scheduled event hours: this key figure is the sum of all hours that employees with the selected job as their primary job spend in events (for example, training or meetings) .

0RC_SCDOHRS

Scheduled overtime hours: the number of hours that will be paid at a higher rate (at a multiple higher than one), regardless of the reason.

0RC_SCDPAY

Scheduled pay : the total payroll for the scheduled hours. This includes regular, overtime, vacation, and so on.

0RC_SCDEPAY

Scheduled event pay : the total payroll for the scheduled event hours, calculated from scheduled event hours.

0RC_ACTRHRS

Actual regular hours: actual (punched) paid non-overtime hours.

0RC_ACTOHRS

Actual overtime hours: actual paid overtime hours.

0RC_ACTEHRS

Actual event hours: actual hours spent in an event. These hours are assigned to the employee's primary job.

0RC_ACTPHRS

Actual productive hours: within SAP StaffWorks, hours can be labeled as productive (for example, regular hours) or non-productive (for example, hours spent on vacation). Typically productive hours are spent in direct support of the store’s operations.

0RC_ACTNHRS

Actual non-productive hours: within SAP StaffWorks, these are hours that can be labeled as productive (for example, regular hours) or non-productive (for example, hours spent on vacation). Typically, non-productive hours are not spent in direct support of the store’s operations.

0RC_ACTRPAY

Actual regular pay: total payroll for the actual regular hours as calculated by SAP StaffWorks.

0RC_ACTOPAY

Actual overtime pay: total payroll for the actual overtime hours as calculated by SAP StaffWorks.

0RC_ACTEPAY

Actual event pay : the pay for the actual event hours

0RC_TYSALES

Actual sales of the current year

0RC_RPFLG

Reporting flag: auxiliary variable indicating whether actual figures are available for the selected day and store.

0RC_LYRPFLG

Last year reporting flag: auxiliary variable indicating whether actual figures are available for the selected day and store in the previous year.

0RC_ADJLYSL

Adjusted sales of the previous year: auxiliary variable used only to compute the calculated key figure net last year sales. It equals zero if actual sales figures exist or it equals last year's sales if no actual sales exist for the current year.

0RC_ADJHOUR

Adjusted hours: auxiliary variable used only to compute the calculated key figures net scheduled hours and projected hours. It equals zero if actual hours exist or it equals scheduled hours if no actual hours exist.

0RC_ADJPAY

Adjusted pay: auxiliary variable used only to compute the calculated key figures net scheduled pay and projected pay. It equals zero if actual pay figures exists or it equals scheduled pay if no actual pay exists.

0RC_ADJSALE

Adjusted sales: auxiliary variable used only to compute the calculated key figures net plan sales and projected sales. It equals zero if actual sales figures exist or it equals planned sales if no actual sales exist.

Restricted Key Figures

InfoObject

Description

Formula and Restriction

0RC_CM01_RK001

Total Store Manager's Sales

Total Business =1; key figure = Manager's Forecast

0RC_CM01_CK002

Total Store Planned Sales

Total Business =1; key figure = Planned Sales

0RC_CM01_CK003

Total Store Projected Sales

Total Business =1; key figure = Projected Sales

0RC_CM01_CK004

Total Store Sales

Total Business =1; key figure = Sales

Calculated Key Figures

InfoObject

Description

Formula and Restriction

0RC_CM01_CK003

Average Hourly Rate

Total Pay / Total Hours

0RC_CM01_CK006

Projected Actual Hours

Total Hours + Adjusted Hours

0RC_CM01_CK007

Projected Average Hourly Rate

Projected Pay / Projected Actual Hours

0RC_CM01_CK004

Projected Pay

Total Pay + Adjusted Hours

0RC_CM01_CK005

Projected Sales

Sales + Adjusted Sales

0RC_CM01_CK008

Sales per Hour

Sales / Total Hours

0RC_CM01_CK009

Schedule Effectiveness

Percentage of Scheduled Hours in (Scheduled hours – Understaffing – Overstaffing).

0RC_CM01_CK010

Scheduled Average Hourly Rate

Scheduled Pay / Scheduled Hours

0RC_CM01_CK001

Total Hours

Regular Hours + Overtime Hours + Event Hours

0RC_CM01_CK002

Total Pay

Regular Pay + Overtime Pay + Event Pay

Units

InfoObject

Description

0UNIT

Unit of measurement

0CURRENCY

Currency key