Queries: Category Role (SAP Library

Queries: Category Role

The process step 'Category Role' is very strongly analysis-oriented. A role is assigned to each category. All the categories for a company are compared before a role can be determined and assigned. This involves analyzing the categories to determine which categories, for example, play a key role in terms of profit and customer satisfaction.

The following Queries are based on the InfoCube External Data: Household Panel, Target Consumers (0CM_C01): The Queries are based on external data providers as the category structure may not be available when a company decides on Category Roles.

Name	Query	Use
Market Penetration of Target Consumer	0CM_C01_Q0001	Displays the market penetration of target consumers for the individual Categories from the data provider.
Average Basket Size at Retailer	0CM_C01_Q0002	Displays the average basket size in the individual Categories from the data provider.
Indexed Market Penetration	0CM_C01_Q0003	Displays the market penetration of target consumers, indexed to the market penetration of all consumers for the individual Categories from the data provider.
Spend at Retailer	0CM_C01_Q0004	Displays the target consumer's spend for the individual Categories from the data provider.
Visit Frequency in Market	0CM_C01_Q0005	Displays how often the target consumer visits the individual Categories from the data provider.
Indexed Frequency for Total Market	0CM_C01_Q0006	Displays the frequency with which target consumers visit the market as a whole, indexed to the visit frequency for all consumers for the individual Categories from the data provider.
Retailer's Closure Rate	0CM_C01_Q0007	Displays the closure rate for the data provider's individual merchandise categories.
Annual Spend of all Consumers	0CM_C01_Q0008	Displays the annual spend of all consumers in the individual Categories from the data provider.
Target Customer's Fit to Category	0CM_C01_Q0009	Displays the relation between the target customer's spend and the spend of all consumers in the individual Categories from the data provider.
Fit Index	0CM_C01_Q0010	Displays the fit indexed to the total spend in the individual Categories from the data provider.
Target Consumer's Loyalty	0CM_C01_Q0011	Displays the relation between the target customer's spend at the retailer compared with the spend of the consumers in the market in the individual Categories from the data provider.
Target Consumer Loyalty Index	0CM_C01_Q0012	Displays the loyalty indexed to the target consumers for the individual Categories from the data provider.

The following Queries are based on the InfoCube External Data: Retailer Panel (0CM_C02): The relevant level in this Query is the external data provider's Category.

Name	Query	Use
Retailer's Sales	0CM_C02_Q0001	Display the retailer's sales, taken from the scanner data for the individual Categories from the data provider.
Retailer's Growth	0CM_C02_Q0002	Display the retailer's growth in the individual Categories from the data provider, compared to the previous fiscal year.
Market Share	0CM_C02_Q0003	Displays the retailer's market share in the individual merchandise categories from the data provider.
Retailer Growth vs. Market Growth	0CM_C02_Q0004	Display the retailer's growth compared to the market as a total, for the individual Categories from the data provider.
Annual Sales	0CM_C02_Q0005	Displays the retailer's annual sales in the individual Categories from the data provider, compared to competitors.
Market Sales	0CM_C02_Q0006	Displays the market sales in the individual Categories from the data provider.
Market Growth YAGO	0CM_C02_Q0007	Displays market growth in the individual Categories from the data provider, compared to the previous fiscal year.
Market Growth vs. 3YAGO	0CM_C02_Q0008	Displays market growth in the individual Categories from the data provider, compared to the previous three years.