Start of Content Area

Query Market Share/Market Growth: Category  Locate the document in its SAP Library structure

Technical Name: 0CMCP_C02_Q00061

Based on InfoCube: Syndicated Data: Retail Panel (0CMCP_C02)

Use

The query shows the growth registered by the retailer for the individual categories of the data providers, compared with the growth in the market as a whole.

Filters

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Analysis Level

0CMVRSIO restricted to the selection variable Analysis Level: Category (0P_CVRS1)

Free Characteristics

InfoObject

Description

Hierarchy ID

0CM_HIEID restricted to the selection variable Hierarchy ID of the CDT (0CMHIEID)

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Category Role

0CM_CDT1__ 0CM_ROLE

Category

0CM_CDT1

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Sales for the Previous Year

0CMCP_SALYG

Market Sales

0CMCP_MASAL

Market Growth

‘Market Growth’ % ‘Sales for the Previous Year’

Retailer’s Sales for the Previous Year

0CMCP_RESALYG

Retailer’s Sales

0CMCP_RESAL

Retailer’s Growth

‘Retailer’s Sales’ % ‘Retailer’s Sales for the Previous Year’

Market Share

‘Retailer’s Sales’ %A ‘Market Sales’

Index Growth

‘Retailer’s Growth’/‘Market Growth’

 

 

End of Content Area