!--a11y-->
Technical name: 0CP_SLSC2_Q0001
Based on InfoCube:
ACNielsen: Syndicated Data Integration (0CP_SLSC2)Use
"Pipeline" refers to the distribution of finished products from a consumer product manufacturer to the consumer. In a pipeline analysis, the manufacturer's shipments are compared to retail sales with the consumer on an equivalized unit basis. Shipments are taken from the invoice document, retail sales from the fact data provided by ACNielsen U.S.A.. The result is the inventory change in the ACNielsen Market, which gives some hints about the future shipment volume: When inventory in the market is increased, retailers will likely order less product in the future – and vice versa.
This query based on the pipeline model provides important information that can be used in long-term planning. For this purpose, the trend over eight quarters is displayed as an example. By making assumptions about the category growth and target market share, you can calculate the expected shipment volume, which in turn allows you to adjust production capacities on a long-term basis.
You can further refine this analysis by considering absolute market stock figures. These are collected by ACNielsen's field service and updated in the InfoCube, where you can add your own sales figures and subtract consumption (both in EQU).
Filter
InfoObject |
Description |
Value |
0FISCVARNT |
Fiscal Year Variant |
SM |
0DEALTYPE |
Type of Sales Deal |
TOTL |
Free Characteristics
InfoObject |
Description |
0ACN_MARKET |
ACNielsen Market |
0ACN_CATGRY |
ACNielsen Category |
0ACN_BRAND |
ACNielsen Brand |
Rows (Key Figures)
Element |
InfoObject, restrictions, formulas |
Category Volume |
0ACN_SCE |
Adjustment Factor |
0CP_ADJSO |
Adj. Category Volume |
'Category Volume' * 'Adjustment Factor' |
Retail Sales (EQU) |
0ACN_SE |
Market Share of Brand |
'Retail Sales (EQU)' / 'Category Volume' |
Adj. Retail Sales (EQU) |
'Retail Sales (EQU)' * 'Adjustment Factor' |
Net Sales to Customer |
0CPSAEXNTEQ |
Stock in ACNielsen Market |
0CPMKTSTOEQ |
Retail Stock |
'Stock in ACNielsen Market' * 'Adjustment Factor' |
Weeks of Supply |
'Stock in ACNielsen Market' / 'Retail Sales EQU' |
Columns
Element |
InfoObject, restrictions, formulas |
Q1/1999 |
Fiscal Year Periods = [01.1999;003.1999] |
Q2/1999 |
Fiscal Year Periods = [004.1999;006.1999] |
Q3/1999 |
Fiscal Year Periods = [007.1999;009.1999] |
Q4/1999 |
Fiscal Year Periods = [010.1999;012.1999] |
1999 |
Fiscal Year = 1999 |
Q1/2000 |
Fiscal Year Periods = [001.2000;003.2000] |
Q2/2000 |
Fiscal Year Periods = [004.2000;006.2000] |
Q3/2000 |
Fiscal Year Periods = [007.2000;009.2000] |
Q4/2000 |
Fiscal Year Periods = [010.2000;012.2000] |
2000 |
Fiscal Year = 2000 |