Store Operations Summary
Technical Name: 0RC_MC02_Q0001
Based on InfoCube:Operational2 info cube (0RC_MC02).
Use
This query allows managers ‘one-stop shopping’ for the key sales and labor metrics for a defined time period as it shows the principle key figures at a glance. The goal of placing all these key figures in one report is to save the user from having to look at five queries to find out whether everything is in order. Certain limitations require us to keep the reporting at the ‘total store’ level. If the user wants more detailed results, they can use the other sales and labor reports to find out what is specifically causing the problem.
Rows
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
0RC_RT_FWK |
Retail Fiscal Week |
0RC_STORE__0RC_GEOLEV3 |
Region |
Columns
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
0RC_MC02_CK006 |
Projected Actual Hours |
0RC_MC02_RK003 |
Total Store Projected Sales |
0RC_MC02_CK004 |
Projected Pay |
0RC_MC02_CK007 |
Projected Average Hourly Rate |
0RC_MC02_CK009 |
Schedule Effectiveness |
0RC_MC02_CK001 |
Total Hours |
0RC_MC02_CK002 |
Total Pay |
Projected Sales Per Hour |
'Total Store Projected Sales' / 'Projected Actual Hours' |
Projected Labor Percent |
'Projected Pay' %A 'Total Store Projected Sales' |
Total Store Sales |
For Business Indicators that are part of total sales |