Reporting Stores

Technical Name: 0RC_MC02_Q0005

Based on InfoCube: Operational2 info cube (0RC_MC02).

Use

It will be rare that all stores successfully deliver their daily information to the BW system every day. Transmission problems, user errors and simple timing issues may prevent this. When users interpret the query results, they must know how close to complete the data is that provided the basis for the results. For stores that did not upload their data, this query shows the forecast sales values. This allows users to simply add the missing numbers to see what a complete reporting would look like.

Rows

InfoObject

Description of the InfoObject (or restriction or calculation formula)

0RC_RT_FWK

Retail Fiscal Week

0RC_STORE

Store

Columns

InfoObject

Description of the InfoObject (or restriction or calculation formula)

0RC_ADJSALE

Adjusted Sales

0RC_RPFLG

Reporting Flag

0RC_MC02_RK002

Total Store Planned Sales

Number of Non Reporting Stores

DELTA ( 'Reporting Flag' )

Number of Reporting Stores

COUNT ( 'Reporting Flag' )

Planned Sales, Weighted Average Reporting

( 'Total Store Planned Sales' - 'Adjusted Sales' ) %A 'Total Store Planned Sales'