Promotion Shares: SKU

Technical Name: 0CMCP_C03_Q00038

Based on InfoCube: Retail POS Data (0CMCP_C03)

Use

The query shows the promotion shares for the promotion analysis on a higher level.

Filters

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Calendar Year

0CALYEAR restricted to the selection variable Calendar Year (0P_CALYE)

Free Characteristics

InfoObject

Description

Category

0CM_CDT1

Subcategory

0CM_CDT2

Segment

0CM_CDT3

Sub-segment

0CM_CDT4

Sub-subsegment

0CM_CDT5

Product Group

0CM_CDT6

Brand

0CM_CDT7

Hierarchy ID

0CM_HIEID

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

SKU Strategy

0CM_SKU__ 0CM_STRAT

SKU

0CM_SKU

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Number of Promotions

0CMCP_NPRRT

Promotion Sales/Retailer

0RTPRINSASV

Share of Promotion Sales

% GT ‘Promotion Sales/Retailer’

Sales/Retail Value

0RTBAINSASV

Share of Sales

% GT ‘Sales/Retail Value’