Measures

Measures Overview

Use Demand Signal Repository’s base measure values to calculate common performance measures, such as sales growth, gross margin, and inventory cover (days of supply). Demand Signal Repository calculates these measures at the appropriate hierarchy levels.

As well as base measures, Demand Signal Repository supports external measures, which are measures that cannot be calculated based on the base data model or that are provided directly by the retailer in precalculated form. You can load external measures into Demand Signal Repository.

Note: Demand Signal Repository does not map or aggregate external measures.

Customer Shipments Measures

Name	Type	Description
Inbound Shipment Cost (Customer Currency)	Base	The monetary value (expressed in the customer's currency) of a customer shipment into a business unit based on the customer's cost.
Inbound Shipment Quantity	Base	The number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) in the primary unit Of measure.
Inbound Shipment Quantity (Alt UOM)	Base	The number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) in the alternate unit of measure.
Shipment Amount	Base	The monetary value of a customer distributor or retailer) shipment from a business unit (typically a DC), expressed in the manufacturer's currency.
Shipment Amount (Customer Currency)	Base	The monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC), expressed in the customer's currency.
Shipment Cost	Base	The monetary value of a customer distributor or retailer) shipment from a business unit (typically a DC) based on the customer's cost and expressed in the manufacturer's currency.
Shipment Cost (Customer Currency)	Base	The monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC) based on the customer's cost and expressed in the customer's currency.
Shipment Quantity	Base	The number of units a customer distributor or retailer) has shipped from a business unit (typically a DC) in the primary unit of measure.
Shipment Quantity (Alt UOM)	Base	The number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC) in the alternate unit of measure.

Customer Shipments - Previous Period Measures

Name	Type	Description
Inbound Shipment Amount Previous Period	Base	The monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC) for the previous period, expressed in the manufacturer's currency.
Inbound Shipment Amount Previous Period (Customer Currency)	Base	The monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC) for the previous period, expressed in the customer's currency.
Inbound Shipment Quantity Previous Period	Base	The number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) for the previous period, in the primary unit of measure.
Inbound Shipment Quantity Previous Period (Alt UOM)	Base	The number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) for the previous period, expressed in the alternate unit of measure.
Shipment Amount Previous Period	Base	The monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the previous period, expressed in the manufacturer's currency .
Shipment Amount Previous Period (Customer Currency)	Base	The monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the previous period, expressed in the customer's currency .
Shipment Cost Previous Period	Base	The shipping cost of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the pervious period, expressed in the manufacturer's currency.
Shipment Cost Previous Period (Customer Currency)	Base	The shipping cost of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the pervious period, expressed in the customer's currency.
Shipment Quantity Previous Period	Base	The number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC) for the previous period in the primary unit of measure.
Shipment Quantity Previous Period (Alt UOM)	Base	The number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC) for the previous period in the alternate unit of measure.

Customer Shipments - Same Period Last Year Measures

Name	Type	Description
Inbound Shipment Amount Last Year	Base	The monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC) for the same period of the previous year, expressed in the manufacturer's currency.
Inbound Shipment Amount Last Year (Customer Currency)	Base	The monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC) for the same period of the previous year, expressed in the customer's currency.
Inbound Shipment Cost Last Year	Base	The monetary cost of a customer (distributor or retailer) shipment into a business unit (store or DC) for the same period of the previous year, expressed in the manufacturer's currency.
Inbound Shipment Cost Last Year (Customer Currency)	Base	The monetary cost of a customer (distributor or retailer) shipment into a business unit (store or DC) for the same period of the previous year, expressed in the customer's currency.
Inbound Shipment Quantity Last Year	Base	The number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) for the same period of the previous year, expressed in the primary unit of measure.
Inbound Shipment Quantity Last Year (Alt UOM)	Base	The number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) for the same period of the previous year, expressed in the alternate unit of measure.
Shipment Amount Last Year	Base	The monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the same period of the previous year, expressed in the manufacturer's currency.
Shipment Amount Last Year (Customer Currency)	Base	The monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the same period of the previous year, expressed in the customer's currency.
Shipment Cost Last Year	Base	The monetary cost of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the same period of the previous year, expressed in the manufacturer's currency.
Shipment Cost Last Year (Customer Currency)	Base	The monetary cost of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the same period of the previous year, expressed in the customer's currency.
Shipment Quantity Last Year	Base	The number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC) for the same period of the previous year, expressed in the primary unit of measure.
Shipment Quantity Last Year (Alt UOM)	Base	The number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC) for the same period of the previous year, expressed in the alternate unit of measure.

Customer Shipments - Same Period Last Year YTD Measures

Name	Type	Description
Inbound Shipment Amount Last Year YTD	Base	The year-to-date monetary value of a customer (distributor or retailer) shipment into a business unit store or DC) for the previous year, expressed in the manufacturer's currency.
Inbound Shipment Amount Last Year YTD (Customer Currency)	Base	The year-to-date monetary value of a customer (distributor or retailer) shipment into a business unit store or DC) for the previous year, expressed in the manufacturer's currency.
Inbound Shipment Cost Last Year YTD	Base	The year-to-date monetary cost of a customer (distributor or retailer) shipment into a business unit (store or DC) for the previous year, expressed in the manufacturer's currency.
Inbound Shipment Cost Last Year YTD (Customer Currency)	Base	The year-to-date monetary cost of a customer (distributor or retailer) shipment into a business unit (store or DC) for the previous year, expressed in the customer's currency.
Inbound Shipment Quantity Last Year YTD	Base	The year-to-date number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) for the previous year, expressed in the primary unit of measure.
Inbound Shipment Quantity Last Year YTD (Alt UOM)	Base	The year-to-date number of units a customer (distributor or retailer) has shipped into a business unit (store or DC) for the previous year, expressed in the alternate unit of measure.
Shipment Amount Last Year YTD	Base	The year-to-date monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the previous year, expressed in the manufacturer's currency.
Shipment Amount Last Year YTD (Customer Currency)	Base	The year-to-date monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the previous year, expressed in the customer's currency.
Shipment Cost Last Year YTD	Base	The year-to-date monetary cost of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the previous year, expressed in the manufacturer's currency.
Shipment Cost Last Year YTD (Customer Currency)	Base	The year-to-date monetary cost of a customer (distributor or retailer) shipment from a business unit (typically a DC) for the previous year, expressed in the customer's currency.
Shipment Quantity Last Year YTD	Base	The year-to-date number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC) for the previous year, expressed in the primary unit of measure.
Shipment Quantity Last Year YTD (Alt UOM)	Base	The year-to-date number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC) for the previous year, expressed in the alternate unit of measure.

Customer Shipments - YTD Measures

Name	Type	Description
Inbound Shipment Amount YTD	Base	The YTD monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC), and expressed in the manufacturer's currency.
Inbound Shipment Amount YTD (Customer Currency)	Base	The YTD monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC), and expressed in the customer's currency.
Inbound Shipment Cost YTD	Base	The YTD monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC), based on the customer's cost and expressed in the manufacturer's currency.
Inbound Shipment Cost YTD (Customer Currency)	Base	The YTD monetary value of a customer (distributor or retailer) shipment into a business unit (store or DC), based on the customer's cost and expressed in the customer's currency.
Inbound Shipment Quantity YTD	Base	The YTD number of units a customer (distributor or retailer) has shipped into a business unit (store or DC), expressed in the primary unit of measure.
Inbound Shipment Quantity YTD (Alt UOM)	Base	The YTD number of units a customer (distributor or retailer) has shipped into a business unit (store or DC), expressed in the alternate unit of measure.
Shipment Amount YTD	Base	The YTD monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC), expressed in the manufacturer's currency.
Shipment Amount YTD (Customer Currency)	Base	The YTD monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC), expressed in the customer's currency.
Shipment Cost YTD	Base	The YTD monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC), based on the customer's cost and expressed in the manufacturer's currency.
Shipment Cost YTD (Customer Currency)	Base	The YTD monetary value of a customer (distributor or retailer) shipment from a business unit (typically a DC), based on the customer's cost and expressed in the customer's currency.
Shipment Quantity YTD	Base	The YTD number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC), expressed in the primary UOM.
Shipment Quantity YTD (Alt UOM)	Base	The YTD number of units a customer (distributor or retailer) has shipped from a business unit (typically a DC), expressed in the alternate UOM.

Organization Measures

Name	Type	Description
Annual Volume	Base	Total annual sales volume of each business unit. It can be aggregated from store to larger geographical sets such as organization hierarchy, market area, region, sub-region.
Number of Retail Stores	Derived	Number of retail stores (business unit type = "RTL"). This does not include distribution centers or other business unit types.
Organization Annual Volume	Derived	The organization's total annual volume. This measure always represents the total annual sales volume of every business unit within the organization regardless of which level of the organization hierarchy is being queried. This measure is commonly used as the denominator when calculating ACV % at various levels of customer's organization hierarchy.

Point of Sale Measures

Name	Type	Description
% of Stores Not Scanning	Derived	The percentage of stores not scanning for point of sale measures.
% of Stores Scanning	Derived	The percentage of stores that are scanning (selling).
% Retailer Gross Margin	Derived	The ratio (percentage) of gross profit as compared to monetary sales.
% Returns	Derived	The ratio (percentage) of the Return Amount as compared to the Sales Amount.
% Change Average Price	Derived	The percent change in average price as compared to the previous period.
% Change Profit	Derived	The percent change in profit as compared to the previous period.
% Contribution Profit To Category	Derived	The percent of profit contribution as related to the overall product category's profit.
% Product to Category by Amount	Derived	The ratio (percentage) of monetary sales as compared to the all sales of a product category expressed in the manufacturer's currency.
% Product to Category by Quantity	Derived	The ratio (percentage) of units sold as compared to the all units sold of a product category.
Authorized Stores Not Selling	Derived	Number of authorized stores not selling.
Average Price Per Unit	Derived	The average price per unit sold expressed in the manufacturer's currency.
Average Sales Per Store Selling	Derived	Average unit sales per store selling.
Category Sales Amount	Base	The monetary sales amount for the entire product category expressed in the manufacturer's currency.
Expected Revenue	Derived	Expected revenue based on the promotion price.
Market Share	Derived	The percentage of monetary sales for the Manufacturer's item to the monetary sales of all items.
Net Cost	Base	The cost of sales expressed in the manufacturer's currency.
Promotion Flag	Base	The Promotion Flag Indicates a promotion is active.
Retailer Cost (Retailer Currency)	Base	The cost of sales expressed in the customer's currency.
Retailer GM % Point Increase (Year/Year)	Derived	The Retailer's gross margin percentage point increase year over year.
Retailer GM Increase - (Year/Year)	Derived	The increase in the retailer's gross profit as compared to the previous period.
Retailer GMROI	Derived	The customer's gross margin return on their investment.
Retailer Gross Margin	Derived	The customer's profit, expressed in the manufacturer's currency.
Return Amount	Base	The monetary value of the units returned expressed in the manufacturer's currency.
Return Amount - Cost Basis	Base	The monetary value of the units returned based on the customer's cost expressed in the manufacturer's currency.
Return Amount - Cost Basis (Retailer Currency)	Base	The monetary value of the units returned based on the customer's cost expressed in the customer's currency.
Return Amount (Retailer Currency)	Base	The monetary value of the units returned expressed in the customer's currency.
Return Quantity	Base	The number of units returned, expressed in the primary UOM.
Return Quantity (Alt UOM)	Base	The number of units returned, expressed in the alternate UOM.
Sales Amount	Base	The monetary value of the units sold, expressed in the manufacturer's currency.
Sales Amount (Retailer Currency)	Base	The monetary value of the units sold, expressed in the customer's currency.
Sales Growth Amount	Derived	The percentage increase in sales amount as compared to the previous period expressed in the manufacturer's currency.
Sales Growth Quantity	Derived	The percentage increase in unit sales as compared to the previous period in the primary UOM.
Sales Growth Quantity (Alt UOM)	Derived	The growth of current unit sales as compared to previous period in the alternate UOM.
Sales Quantity	Base	The number of units sold, expressed in the primary UOM.
Sales Quantity (Alt UOM)	Base	The number of units sold, expressed in the alternate UOM.
Sell Through	Derived	Unit sales net of any returns. Used in calculating Expected Ending Inventory.
Total Authorized Stores	Base	Total number of stores authorized to sell.
Total Category Average Profit	Derived	The average profit for the category.
Total Category Average Sales Value	Derived	The average monetary sales for the category.
Total Category Average Sales Volume	Derived	The average sales volume for the category.
Unit Profit	Derived	The average gross profit per unit sold.

Exceptions Measures

Name	Type	Description
10% of Promotion Price	Derived	10% of the SKU's promoted price as defined in the retailer's promotion plan.
110% of Daily Average Sales Qty for Last 4 Weeks	Derived	110% of the daily average sales quantity for the previous four completed weeks.
Exception Amount	Base	The monetary value associated with the exception, representing the impact on the business. This value differs by exception type. For example, in an overstock exception it represents, the value of the excess inventory. In an out-of stock exception, it represents the lost sales amount (difference between forecast and actual sales).
Exception Amount Previous Period	Base	The monetary value associated with the exception, representing the impact on the business for the previous period. This value differs by exception type. For example, in an overstock exception it represents, the value of the excess inventory. In an out-of stock exception, it represents the lost sales amount (difference between forecast and actual sales).
Exception Count	Base	A count representing the number of exceptions.
Exception Count Previous Period	Base	A count representing the number of exceptions for the previous period.
Exception Quantity	Base	The quantity associated with the exception that represents the impact on the business. This value differs by exception type. For example, in an overstock exception it represents, the units of excess inventory. In an out-of stock exception, it represents the lost sales quantity (difference between forecast and actual sales).
Exception Quantity Previous Period	Base	The quantity associated with the exception representing the impact on the business for the previous period. This value differs by exception type. For example, in an overstock exception it represents, the units of excess inventory. In an out-of stock exception, it represents the lost sales quantity (difference between forecast and actual sales).
Expected Inventory	Derived	The anticipated inventory quantity at the end of a period.
Expected Sales	Base	The quantity of units expected to sell, based on historical sales of that SKU/BU combination. For promoted days (where POS sales were flagged as promoted), expected sales is the median of promoted daily sales in past 180 days. For Non-promoted days (where POS sales were flagged as non-promoted), expected sales is the median of previous five same-day periods.
Goal Forecast Accuracy (Org-Category-Week)	Base	An externally-loaded goal representing the desired target for a customer's forecast accuracy percent. This goal is loaded at the customer - product category - week level.
In-Flight Promotional Lift Exception Amount	Derived	The expected sales amount, assuming a 10% lift from average daily sales.
In-Flight Promotional Lift Exception Quantity	Derived	The expected sales quantity assuming a 10% lift from average daily sales.
Minimum Threshold Actual Sales	Base	The minimum threshold quantity that will trigger an imputed Out of Stock Exception when actual sales quantity is below this value.
New Item End Date	Base	The date on which the item is no longer considered to be a new item.
New Item First Sale Date	Base	The date in which the SKU was first sold at the business unit.
New Item Not Selling Exception Amount	Derived	The forecasted sales quantity for new items that haven't sold.
New Item Not Selling Exception Quantity	Derived	The forecasted sales monetary amount for new items that haven't sold.
New Item Start Date	Base	The date in which the SKU was first introduced to the business unit.
Out of Stock Imputed Exception Amount	Derived	Lost sales. The difference between the sales forecast and actual sales. If no sales forecast is available, then the difference between expected sales and actual sales.
Out of Stock Imputed Exception Quantity	Derived	Lost sales. The difference between expected sales and actual sales.
Out of Stock On-Hand Exception Amount	Derived	Lost sales. The difference between the sales forecast amount and actual sales amount
Out of Stock On-Hand Exception Quantity	Derived	Lost sales. The difference between the sales forecast quantity and actual sales quantity.
Overstock Exception Amount	Derived	The monetary value of the units over the customer replenishment rules' maximum on-hand quantity
Overstock Exception Quantity	Derived	The number of units over the customer replenishment rules' maximum on-hand quantity.
Promotional Price Deviation	Derived	Uses the customer promotion plan for Promotion Price Minimum.
Promotional Price Deviation Exception Amount	Derived	The sales quantity multiplied by the average selling price.
Promotional Price Deviation Exception Quantity	Derived	The sales quantity.
Reorder Point Exception Amount	Derived	The number of units below the customer replenishment rules reorder threshold. This includes the number of units on hand plus the units on order.
Reorder Point Exception Quantity	Derived	The monetary amount, based on average price, of the number of units below the customer replenishment rules reorder threshold.
Sales Forecast Accuracy Exception Amount	Derived	The difference between forecast amount and actual sales amount.
Sales Forecast Accuracy Exception Quantity	Derived	The difference between forecast quantity and actual sales quantity.
Threshold Forecast Accuracy (Org-Category-Week)	Base	An externally-loaded threshold representing the desired target for a customer's forecast accuracy percent. This goal is loaded at the customer - product category - week level.

Forecast Measures

Name	Type	Description
% Forecast Deviation	Derived	The percentage deviation of sales forecast quantity to sales quantity. Should be used with the Forecast Dimension to select the forecast type = TOTAL and forecast purpose = SALES.
Forecast Accuracy %	Derived	The accuracy of the forecast as compared to sales quantity expressed as a percentage. The inverse of Forecast Error %. Should be used with the Forecast Dimension to select the forecast type = TOTAL and forecast purpose = SALES.
Forecast Amount	Base	The monetary value associated with the forecast in the manufacturer's currency. Should be used with the Forecast Dimension to select the applicable forecast type (TOTAL, BASE, PROMO) and forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Amount (Retailer Currency)	Base	The monetary value associated with the forecast in the customer's currency. Should be used with the Forecast Dimension to select the forecast type (TOTAL, BASE, PROMO) and forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Error %	Derived	The ratio (percentage) of the absolute value of the difference between forecast quantity and sales quantity, as compared to sales quantity. Use this measure with Forecast Dimension to select the applicable forecast type = TOTAL and forecast purpose = SALES.
Forecast Quantity	Base	The quantity associated with the forecast in the primary UOM. Use this measure with the Forecast Dimension to select the applicable forecast type (TOTAL, BASE, PROMO) and forecast purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity (Alt UOM)	Base	The quantity associated with the forecast in the alternate UOM. Use with the Forecast Dimension to select the applicable forecast type (TOTAL, BASE, PROMO) and forecast purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Lost Sales Amount	Derived	The difference between the sales forecast amount and actual sales amount, expressed in the manufacturer's currency.
Lost Sales Quantity	Derived	The difference between the sales forecast quantity and actual sales quantity.

Forecast - Previous Period Measures

Name	Type	Description
% Forecast Deviation Previous Period	Derived	The percentage deviation of sales forecast quantity to sales quantity for the previous period. Use this measure with Forecast Dimension to select the forecast type = TOTAL and forecast purpose = SALES.
Forecast Accuracy % Previous Period	Derived	The accuracy of the forecast as compared to sales quantity expressed as a percentage for the previous period. The inverse of Sales Forecast Error Previous Period. Should be used with the Forecast Dimension to select the forecast type = TOTAL and forecast purpose = SALES.
Forecast Amount Previous Period	Base	The monetary value associated with the forecast in the manufacturer's currency for the previous period. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Amount Previous Period (Retailer Currency)	Base	The monetary value associated with the forecast in the customer's currency for the previous period. Should be used with the Forecast Dimension to select the Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity Previous Period	Base	The quantity associated with the forecast in the primary UOM for the previous period. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity Previous Period (Alt UOM)	Base	The quantity associated with the forecast in the alternate UOM for the previous period. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).

Forecast - Same Period Last Year Measures

Name	Type	Description
Forecast Amount Last Year	Base	The monetary value associated with the forecast in the manufacturer's currency for the same period of the previous year. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Amount Last Year (Retailer Currency)	Base	The monetary value associated with the forecast in the customer's currency for the same period of the previous year. Should be used with the Forecast Dimension to select the forecast type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity Last Year	Base	The quantity associated with the forecast in the primary UOM for the same period of the previous year. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity Last Year (Alt UOM)	Base	The quantity associated with the forecast in the alternate UOM for the same period of the previous year. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).

Forecast - Same Period Last Year YTD Measures

Name	Type	Description
Forecast Amount Last Year YTD	Base	The YTD monetary value associated with the forecast in the manufacturer's currency for the previous year. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Amount Last Year YTD (Retailer Currency)	Base	The YTD monetary value associated with the forecast in the customer's currency for the previous year. Should be used with the Forecast Dimension to select the Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity Last Year YTD	Base	The YTD quantity associated with the forecast in the primary UOM for the previous year. Should be used with the Forecast Dimension to select the applicable forecast type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity Last Year YTD (Alt UOM)	Base	The YTD quantity associated with the forecast in the alternate UOM for the previous year. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).

Forecast - YTD Measures

Name	Type	Description
Forecast Accuracy% YTD	Derived	The accuracy of the YTD forecast as compared to YTD sales quantity expressed as a percentage. The inverse of Forecast Error % YTD. Should be used with the Forecast Dimension to select the Forecast Type = TOTAL and Forecast Purpose = SALES.
Forecast Amount YTD	Base	The YTD monetary value associated with the forecast in the manufacturer's currency. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Amount YTD (Retailer Currency)	Base	The YTD monetary value associated with the forecast in the customer's currency. Should be used with the Forecast Dimension to select the Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Error% YTD	Derived	The ratio (percentage) of the absolute value of the difference between YTD forecast quantity and YTD sales quantity, as compared to YTD sales quantity. Should be used with the Forecast Dimension to select the applicable Forecast Type = TOTAL and Forecast Purpose = SALES.
Forecast Quantity YTD	Base	The YTD quantity associated with the forecast in the primary UOM. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).
Forecast Quantity YTD (Alt UOM)	Base	The YTD quantity associated with the forecast in the alternate UOM. Should be used with the Forecast Dimension to select the applicable Forecast Type (TOTAL, BASE, PROMO) and Forecast Purpose (SALES, SHIPMENT, ORDERS, RECEIPTS).

Goals & Thresholds Measures

Name	Type	Description
Deduction Amount	Base	An externally-loaded measure representing a customer's total deduction amount.
Deduction Balance	Base	An externally-loaded measure representing a customer's deduction balance.
Goal % Returns	Base	An-externally-loaded goal representing the desired target for percent returns. For example, the goal might be 2.0 which represents a goal of 2% or less in returns. This goal is loaded at the customer - product category - week level.
Goal Category Sales	Base	An-externally-loaded goal representing the desired target for sales of a product category. This goal is loaded at the customer - product category - week level.
Goal Category Share	Base	An externally-loaded goal representing the target percentage of customer sales of a product category as compared to a larger market (for example, all customers).
Goal Deduction Amount	Base	An externally-loaded goal representing the desired target for total deduction amount. This goal is loaded at the customer - product category - week level.
Goal Deduction Balance	Base	An externally-loaded goal representing the desired target for a customer's deduction balance. This goal is loaded at the customer - product category - week level.
Goal Forecast Accuracy	Base	An externally-loaded goal representing the desired target for a customer's forecast accuracy percent. This goal is loaded at the customer - product category - week level.
Goal Gross Margin %	Base	An externally-loaded goal representing the average percentage amount a retailer will earn for an item sold to a consumer before deducting operating expenses.
Goal In-Stock %	Base	An externally-loaded goal representing the percentage of items that were available out of the set of stocking locations that were evaluated.
Goal Inventory Cover	Base	An externally-loaded goal representing the amount of finished goods inventory in terms of the estimated daily demand.
Goal Invoice Accuracy %	Base	An externally-loaded goal representing the desired target percentage of seller invoices deemed accurate out of all invoices received.
Goal Item Data Accuracy %	Base	An externally-loaded goal representing the desired target for the percentage of items with accurate physically measured dimensions and weight attributes (as provided by the seller) out of all items that were physically verified.
Goal Item Data Synchronization %	Base	An externally-loaded goal representing the desired target for the percentage of items (including applicable trade item hierarchy) published and sold from the seller that are synchronized by the buyer via the Global Data Synchronisation Network (GDSN).
Goal Late Payment	Base	An externally-loaded goal representing the desired target for the percentage of late payments made within a seller’s terms of sale out of all payments received.
Goal Monetary Sales	Base	An externally-loaded goal representing the desired target for monetary sales.
Goal Number of Deductions	Base	An externally-loaded goal representing the number of deductions.
Goal On Hand Inventory	Base	An externally-loaded goal representing the desired quantity of on-hand inventory to be maintained.
Goal On-Time Delivery Date	Base	An externally-loaded goal representing the desired target for the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Goal On-Time Delivery Time	Base	An externally-loaded goal representing desired target for the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Goal Order Change %	Base	An externally-loaded goal representing the desired target for the percentage of orders placed by the customer in the trading relationship that required changes in items or item quantities prior to release.
Goal Order Cycle Time	Base	An externally-loaded goal representing the desired target for the average length of time between order placement and the time product arrived and was available for unloading at the agreed customer location.
Goal Payment Days	Base	An externally-loaded goal representing the desired target for the average number of days it takes the buyer to pay the invoice.
Goal Perfect Order %	Base	An externally-loaded goal representing the desired target for the percentage of orders placed by the customer in the trading relationship that did not required changes in items or item quantities prior to release.
Goal Retailer Gross Margin	Base	An externally-loaded goal representing the amount a Retailer will earn for an item sold to a consumer before deducting operating expenses.
Goal Service Level	Base	An externally-loaded goal representing the desired target for the percentage of product that a buyer received or the seller shipped compared to the original ordered quantity.
Goal Share of Market	Base	An externally-loaded goal representing the desired target for the percentage of sales of a subset of items and / or locations in a broader market context, which can be defined in terms of a product category, class of trade or geography.
Goal Shopper Penetration	Base	An externally-loaded goal representing the desired target for the percentage of shoppers who shopped at a given retailer.
Goal Unit Sales	Base	An-externally-loaded goal representing the desired target for unit sales.
Invoice Accuracy %	Base	An externally-loaded measure representing the percentage of seller invoices deemed accurate out of all invoices received.
Item Data Accuracy %	Base	An externally-loaded measure representing the percentage of items with accurate physically measured dimensions and weight attributes (as provided by the seller) out of all items that were physically verified.
Item Data Synchronization %	Base	An externally-loaded measure representing the percentage of items (including applicable trade item hierarchy) published and sold from the seller that are synchronized by the buyer via the Global Data Synchronisation Network (GDSN).
Late Payment	Base	An externally-loaded measure representing the percentage of late payments made within a seller’s terms of sale out of all payments received.
Measure Name	Base	A qualifier which determines which goal, threshold or external measure that was loaded into DSR.
Measure Name Type	Base	A qualifier which determines whether a Goal, Threshold, or External Measure was loaded into DSR.
Measure Value	Base	The value of the goal, threshold or measure that was loaded into DSR.
Measure Value Type Flag	Base	A flag representing the type of measure loaded into DSR.
Mfg Item Hchy Lvl	Base	A qualifier which determines the level of the manufacturer item dimension the goal, threshold or measure was loaded into DSR. For example, Division, Class, Sub-Class, SKU, and so on.
Number of Deductions	Base	An externally-loaded measure representing a customer's total number of deductions taken.
On-Time Delivery Date	Base	An externally-loaded measure representing the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
On-Time Delivery Time	Base	An externally-loaded measure representing the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Order Change %	Base	An externally-loaded measure representing the percentage of orders placed by the customer in the trading relationship that required changes in items or item quantities prior to release.
Order Cycle Time	Base	An externally-loaded measure representing the desired target for the average length of time between order placement and the time product arrived and was available for unloading at the agreed customer location.
Org Hchy Lvl	Base	A qualifier which determines the level of the organization dimension the goal, threshold or measure was loaded into DSR. For example, Area, Region, Business Unit, and so on.
Payment Days	Base	An externally-loaded measure representing the average number of days it takes the buyer to pay the invoice.
Perfect Order %	Base	An externally-loaded measure representing the percentage of orders placed by the customer in the trading relationship that did not required changes in items or item quantities prior to release.
Rtl Item Hchy Lvl	Base	A qualifier which determines the level of the customer item dimension the goal, threshold or measure was loaded into DSR. For example, Division, Class, Sub-Class, SKU, and so on.
Service Level	Base	An externally-loaded measure representing the percentage of product that a buyer received or the seller shipped compared to the original ordered quantity.
Share of Market	Base	An externally-loaded measure representing the percentage of sales of a subset of items and/or locations in a broader market context, which can be defined in terms of a product category, class of trade or geography.
Shopper Penetration	Base	An externally-loaded measure representing the percentage of shoppers who shopped at a given retailer.
Threshold % Returns	Base	An externally-loaded threshold representing the desired target for percent returns. For example, the goal might be 2.0 which represents a goal of 2% or less in returns. This goal is loaded at the customer - product category - week level.
Threshold Category Sales	Base	An externally-loaded threshold representing the desired target for sales of a product category. This goal is loaded at the customer - product category - week level.
Threshold Category Share	Base	An externally-loaded threshold representing the target percentage of customer sales of a product category as compared to a larger market (for example, all customers).
Threshold Deduction Amount	Base	An externally-loaded threshold representing a customer's total deduction amount.
Threshold Deduction Balance	Base	An externally-loaded threshold representing a customer's deduction balance.
Threshold Forecast Accuracy	Base	An externally-loaded threshold representing the desired target for a customer's forecast accuracy percent. This goal is loaded at the customer - product category - week level.
Threshold Gross Margin %	Base	An externally-loaded threshold representing the average percentage amount a Retailer will earn for an item sold to a consumer before deducting operating expenses.
Threshold In-Stock %	Base	An externally-loaded threshold representing the percentage of items that were available out of the set of stocking locations that were evaluated.
Threshold Inventory Cover	Base	An externally-loaded threshold representing the amount of finished goods inventory in terms of the estimated daily demand.
Threshold Invoice Accuracy %	Base	An externally-loaded threshold representing the minimum threshold percentage of seller invoices deemed accurate out of all invoices received.
Threshold Item Data Accuracy %	Base	An externally-loaded threshold representing the minimum threshold for the percentage of items with accurate physically measured dimensions and weight attributes (as provided by the seller) out of all items that were physically verified.
Threshold Item Data Synchronization %	Base	An externally-loaded threshold representing the minimum threshold for the percentage of items (including applicable trade item hierarchy) published and sold from the seller that are synchronized by the buyer via the Global Data Synchronisation Network (GDSN).
Threshold Late Payment	Base	An externally-loaded threshold representing the maximum target for the percentage of late payments made within a seller’s terms of sale out of all payments received.
Threshold Monetary Sales	Base	An externally-loaded threshold representing the minimum target for monetary sales.
Threshold Number of Deductions	Base	An externally-loaded threshold representing a customer's total number of deductions taken.
Threshold On Hand Inventory	Base	An externally-loaded threshold representing the desired quantity of on-hand inventory to be maintained.
Threshold On-Time Delivery Date	Base	An externally-loaded threshold representing the minimum target for the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Threshold On-Time Delivery Time	Base	An externally-loaded threshold representing minimum target for the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Threshold Order Change %	Base	An externally-loaded threshold representing the maximum target for the percentage of orders placed by the customer in the trading relationship that required changes in items or item quantities prior to release.
Threshold Order Cycle Time	Base	An externally-loaded threshold representing the maximum threshold for the average length of time between order placement and the time product arrived and was available for unloading at the agreed customer location.
Threshold Payment Days	Base	An externally-loaded threshold representing the maximum target for the average number of days it takes the buyer to pay the invoice.
Threshold Perfect Order %	Base	An externally-loaded threshold representing the minimum target for the percentage of orders placed by the customer in the trading relationship that did not required changes in items or item quantities prior to release
Threshold Retailer Gross Margin	Base	An externally-loaded threshold representing the amount a Retailer will earn for an item sold to a consumer before deducting operating expenses.
Threshold Service Level	Base	An externally-loaded threshold representing the minimum target for the percentage of product that a buyer received or the seller shipped compared to the original ordered quantity.
Threshold Share of Market	Base	An externally-loaded threshold representing the minimum target for the percentage of sales of a subset of items and / or locations in a broader market context, which can be defined in terms of a product category, class of trade or geography.
Threshold Shopper Penetration	Base	An externally-loaded threshold representing the minimum target for the percentage of shoppers who shopped at a given retailer.
Threshold Unit Sales	Base	An externally-loaded threshold representing the minimum target for unit sales.
Time Hchy Lvl	Base	A qualifier which determines the level of time dimension the goal, threshold or measure was loaded into DSR.

Goals & Thresholds - YTD Measures

Name	Type	Description
Deduction Balance YTD	Derived	An externally-loaded measure representing a customer's deduction balance.
Goal % Returns YTD	Derived	An-externally-loaded goal representing the desired target for percent returns. For example, the goal might be 2.0 which represents a goal of 2% or less in returns. This goal is loaded at the customer - product category - week level.
Goal Category Sales YTD	Base	An-externally-loaded goal representing the desired target for sales of a product category. This goal is loaded at the customer - product category - week level.
Goal Deduction Balance YTD	Derived	An externally-loaded goal representing the desired target for a customer's deduction balance. This goal is loaded at the customer - product category - week level.
Goal Forecast Accuracy YTD	Derived	An externally-loaded goal representing the desired target for a customer's forecast accuracy percent. This goal is loaded at the customer - product category - week level.
Goal Gross Margin % YTD	Derived	An externally-loaded goal representing the average percentage amount a retailer will earn for an item sold to a consumer before deducting operating expenses.
Goal Inventory Cover YTD	Derived	An externally-loaded goal representing the amount of finished goods inventory in terms of the estimated daily demand.
Goal Invoice Accuracy % YTD	Derived	An externally-loaded goal representing the desired target percentage of seller invoices deemed accurate out of all invoices received.
Goal Item Data Accuracy % YTD	Derived	An externally-loaded goal representing the desired target for the percentage of items with accurate physically measured dimensions and weight attributes (as provided by the seller) out of all items that were physically verified.
Goal Item Data Synchronization % YTD	Derived	An externally-loaded goal representing the desired target for the percentage of items (including applicable trade item hierarchy) published and sold from the seller that are synchronized by the buyer via the Global Data Synchronisation Network (GDSN).
Goal Monetary Sales YTD	Base	An-externally-loaded goal representing the desired target for monetary sales.
Goal On Hand Inventory YTD	Derived	An externally-loaded goal representing the desired quantity of on-hand inventory to be maintained.
Goal On-Time Delivery Time YTD	Derived	An externally-loaded goal representing desired target for the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Goal Order Change % YTD	Derived	An externally-loaded goal representing the desired target for the percentage of orders placed by the customer in the trading relationship that required changes in items or item quantities prior to release.
Goal Order Cycle Time YTD	Derived	An externally-loaded goal representing the desired target for the average length of time between order placement and the time product arrived and was available for unloading at the agreed customer location.
Goal Payment Days YTD	Derived	An externally-loaded goal representing the desired target for the average number of days it takes the buyer to pay the invoice.
Goal Perfect Order % YTD	Derived	An externally-loaded goal representing the desired target for the percentage of orders placed by the customer in the trading relationship that did not required changes in items or item quantities prior to release.
Goal Retailer Gross Margin YTD	Base	An externally-loaded goal representing the amount a Retailer will earn for an item sold to a consumer before deducting operating expenses.
Goal Unit Sales YTD	Base	An-externally-loaded goal representing the desired target for unit sales.
Invoice Accuracy % YTD	Derived	An externally-loaded measure representing the percentage of seller invoices deemed accurate out of all invoices received.
Item Data Accuracy % YTD	Derived	An externally-loaded measure representing the percentage of items with accurate physically measured dimensions and weight attributes (as provided by the seller) out of all items that were physically verified.
Item Data Synchronization % YTD	Derived	An externally-loaded measure representing the percentage of items (including applicable trade item hierarchy) published and sold from the seller that are synchronized by the buyer via the Global Data Synchronisation Network (GDSN).
On-Time Delivery Time YTD	Derived	An externally-loaded measure representing the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Order Change % YTD	Derived	An externally-loaded measure representing the percentage of orders placed by the customer in the trading relationship that required changes in items or item quantities prior to release.
Order Cycle Time YTD	Derived	An externally-loaded measure representing the desired target for the average length of time between order placement and the time product arrived and was available for unloading at the agreed customer location.
Payment Days YTD	Derived	An externally-loaded measure representing the average number of days it takes the buyer to pay the invoice.
Perfect Order % YTD	Derived	An externally-loaded measure representing the percentage of orders placed by the customer in the trading relationship that did not required changes in items or item quantities prior to release.
Threshold % Returns YTD	Derived	An externally-loaded threshold representing the desired target for percent returns. For example, the goal might be 2.0 which represents a goal of 2% or less in returns. This goal is loaded at the customer - product category - week level.
Threshold Category Sales YTD	Base	An externally-loaded threshold representing the desired target for sales of a product category. This goal is loaded at the customer - product category - week level.
Threshold Deduction Balance YTD	Derived	An externally-loaded threshold representing a customer's deduction balance.
Threshold Forecast Accuracy YTD	Derived	An externally-loaded threshold representing the desired target for a customer's forecast accuracy percent. This goal is loaded at the customer - product category - week level.
Threshold Gross Margin % YTD	Derived	An externally-loaded threshold representing the average percentage amount a Retailer will earn for an item sold to a consumer before deducting operating expenses.
Threshold Inventory Cover YTD	Derived	An externally-loaded threshold representing the amount of finished goods inventory in terms of the estimated daily demand.
Threshold Invoice Accuracy % YTD	Derived	An externally-loaded threshold representing the minimum threshold percentage of seller invoices deemed accurate out of all invoices received.
Threshold Item Data Accuracy % YTD	Derived	An externally-loaded threshold representing the minimum threshold for the percentage of items with accurate physically measured dimensions and weight attributes (as provided by the seller) out of all items that were physically verified.
Threshold Item Data Synchronization % YTD	Derived	An externally-loaded threshold representing the minimum threshold for the percentage of items (including applicable trade item hierarchy) published and sold from the seller that are synchronized by the buyer via the Global Data Synchronisation Network (GDSN).
Threshold Monetary Sales YTD	Base	An externally-loaded threshold representing the minimum target for monetary sales.
Threshold On Hand Inventory YTD	Derived	An externally-loaded threshold representing the desired quantity of on-hand inventory to be maintained.
Threshold On-Time Delivery Time YTD	Derived	An externally-loaded threshold representing minimum target for the percentage of shipments that arrived on the receiver’s premises within the agreed date time out of all shipments that were delivered.
Threshold Order Change % YTD	Derived	An externally-loaded threshold representing the maximum target for the percentage of orders placed by the customer in the trading relationship that required changes in items or item quantities prior to release.
Threshold Order Cycle Time YTD	Derived	An externally-loaded threshold representing the maximum threshold for the average length of time between order placement and the time product arrived and was available for unloading at the agreed customer location.
Threshold Payment Days YTD	Derived	An externally-loaded threshold representing the maximum target for the average number of days it takes the buyer to pay the invoice.
Threshold Perfect Order % YTD	Derived	An externally-loaded threshold representing the minimum target for the percentage of orders placed by the customer in the trading relationship that did not required changes in items or item quantities prior to release
Threshold Retailer Gross Margin YTD	Base	An externally-loaded threshold representing the amount a Retailer will earn for an item sold to a consumer before deducting operating expenses.
Threshold Unit Sales YTD	Base	An-externally-loaded threshold representing the minimum target for unit sales.

Manufacturer Promotion Plan Measures

Name	Type	Description
Actual Customer ACV %	Derived	Percentage of the Participating Store's Annual Sales Volume as compared to the Customer's Total Annual Sales Volume (all stores).
Expected Base Sales Amount	Base	Monetary sales (in the manufacturer's currency) that were expected to sell if the SKU was not under promotion.
Expected Base Sales Quantity	Base	Number of units that were expected to sell if the SKU was not under promotion. Related dimensions: Organization (Org Level Only), Item, Mfg Promotion, Time.
Expected Customer ACV %	Base	Expected ACV (all commodity volume) % of the customer stores that are expected to participate in the promotion.
Expected Incremental Sales Amount	Base	Incremental monetary sales (in the manufacturer's currency) that were expected to sell because the SKU was under promotion. Also known as lift.
Expected Incremental Sales Quantity	Base	Incremental number of units that were expected to sell because the SKU was under promotion. Also known as lift.
Expected Total Sales Amount	Derived	Total Monetary sales (in the manufacturer's currency) that were expected to sell because the SKU was under promotion.
Expected Total Sales Quantity	Derived	Total units that were expected to sell because the SKU was under promotion.
Number of Stores Running Promotion	Base	Number of distinct business units which had promotional sales > 0 related to the manufacturer promotion.
Promoted Price	Base	Unit price at which the SKU is being promoted. The promoted price is assumed to be in the manufacturer’s currency.
Promotion From Date	Base	The start date of the manufacturer's promotion.
Promotion Ship From Date	Base	The start date for shipments related to the manufacturer's promotion.
Promotion Ship To Date	Base	The end date for shipments related to the manufacturer's promotion.
Promotion To Date	Base	The end date of the manufacturer's promotion.

Manufacturer Shipment Measures

Name	Type	Description
Inbound Shipment Amount	Base	The monetary value of a manufacturer shipment into a business unit (e.g., store or DC), expressed in the manufacturer's currency.
Inbound Shipment Cost	Base	The monetary value of a manufacturer shipment into a business unit (e.g., store or DC) based on the manufacturer's cost and expressed in the manufacturer's currency.
Inbound Shipment Quantity	Base	The number of units the manufacturer has shipped into a business unit (e.g., store or DC), expressed in the primary UOM.
Inbound Shipment Quantity (Alt UOM)	Base	The number of units a manufacturer has shipped into a business unit (e.g., store or DC), expressed in the alternate UOM.
Shipment Amount	Base	The monetary value of a manufacturer shipment from the manufacturer's business unit (typically a DC or mfg plant) and expressed in the manufacturer's currency.
Shipment Cost	Base	The monetary value of a manufacturer shipment from the manufacturer's business unit (typically a DC or mfg plant) based on the manufacturer's cost and expressed in the manufacturer's currency.
Shipment Quantity	Base	The number of units the manufacturer has shipped from their business unit (typically a DC or mfg plant), expressed in the primary UOM.
Shipment Quantity (Alt UOM)	Base	The number of units the manufacturer has shipped from their business unit (typically a DC or mfg plant), expressed in the alternate UOM.

Manufacturer Shipments - Previous Period Measures

Name	Type	Description
Inbound Shipment Amount Previous Period	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Inbound Shipment Cost Previous Period	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Inbound Shipment Quantity Previous Period	Base	The number of units shipped in the primary UOM for the previous period.
Inbound Shipment Quantity Previous Period (Alt UOM)	Base	The number of units shipped in the alternate UOM for the previous period.
Shipment Amount Previous Period	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Shipment Cost Previous Period	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Shipment Quantity Previous Period	Base	The number of units shipped in the primary UOM for the previous period.
Shipment Quantity Previous Period (Alt UOM)	Base	The number of units shipped in the alternate UOM for the previous period.

Manufacturer Shipments - Same Period Last Year Measures

Name	Type	Description
Inbound Shipment Amount Last Year	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Inbound Shipment Cost Last Year	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Inbound Shipment Quantity Last Year	Base	The number of units shipped in the primary UOM for the same period of the previous year.
Inbound Shipment Quantity Last Year (Alt UOM)	Base	The number of units shipped in the alternate UOM for the same period of the previous year.
Shipment Amount Last Year	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Shipment Cost Last Year	Base	The monetary value of the shipped units expressed in the manufacturer's currency for the same period of the previous year.
Shipment Quantity Last Year	Base	The number of units shipped in the primary UOM for the same period of the previous year.
Shipment Quantity Last Year (Alt UOM)	Base	The number of units shipped in the alternate UOM for the same period of the previous year.
Inbound Shipment Amount Last Year YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency for the previous year.
Inbound Shipment Cost Last Year YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency for the previous year.
Inbound Shipment Quantity Last Year YTD	Base	The number of units shipped in the primary UOM for the same period of the previous year.
Inbound Shipment Quantity Last Year YTD (Alt UOM)	Base	The YTD number of units shipped in the primary UOM for the previous year.
Shipment Amount Last Year YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency for the previous year.
Shipment Cost Last Year YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency for the previous year.
Shipment Quantity Last Year YTD	Base	The number of units shipped in the primary UOM for the same period of the previous year.
Shipment Quantity Last Year YTD (Alt UOM)	Base	The YTD number of units shipped in the primary UOM for the previous year.

Manufacturer Shipments - Same Period Last Year YTD Measures

Name	Type	Description
Shipment Quantity Last Year YTD	Base	The number of units shipped in the primary UOM for the same period of the previous year.
Shipment Quantity Last Year YTD (Alt UOM)	Base	The YTD number of units shipped in the primary UOM for the previous year.
Inbound Shipment Amount YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency.
Inbound Shipment Cost YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency.
Inbound Shipment Quantity YTD	Base	The YTD number of units shipped in the primary UOM.
Inbound Shipment Quantity YTD (Alt UOM)	Base	The YTD number of units shipped in the alternate UOM.
Shipment Amount YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency.
Shipment Cost YTD	Base	The YTD monetary value of the shipped units expressed in the manufacturer's currency.
Shipment Quantity YTD	Base	The YTD number of units shipped in the primary UOM.
Shipment Quantity YTD (Alt UOM)	Base	The YTD number of units shipped in the alternate UOM.

Organization Measures

Name	Type	Description
Annual Volume	Base	Total annual sales volume of each business unit. It can be aggregated from store to larger geographical sets such as organization hierarchy, market area, region, sub-region.
Number of Retail Stores	Derived	Number of retail stores (business unit type = "RTL"). Does not include distribution centers or other business unit types.
Organization Annual Volume	Derived	The organization's total annual volume. This measure always represents the total annual sales volume of every business unit within the organization regardless of which level of the organization hierarchy is being queried. This measure is commonly used as the denominator when calculating ACV % at various levels of customer's organization hierarchy.

Point of Sale Measures

Name	Type	Description
% of Stores Not Scanning	Derived	The percent of stores not scanning.
% of Stores Scanning	Derived	The percentage of stores scanning (selling).
% Retailer Gross Margin	Derived	The percentage of gross profit in relation to monetary sales.
% Returns	Derived	The percentage of the Return Amount in relation to the Sales Amount.
% Change Average Price	Derived	The percent change in average price in relation to the previous period.
% Change Profit	Derived	The percent change in profit, compared to the previous period.
% Contribution Profit To Category	Derived	The percent of profit contribution, compared to the overall product category's profit.
% Product to Category by Amount	Derived	The percentage of monetary sales, compared to the all sales of a product category and expressed in the manufacturer's currency.
% Product to Category by Quantity	Derived	The percentage of units sold, compared to the all units sold of a product category.
Authorized Stores Not Selling	Derived	Number of authorized stores not selling.
Average Price Per Unit	Derived	The average price per unit sold expressed in the manufacturer's currency.
Average Sales Per Store Selling	Derived	Average unit sales per store selling.
Category Sales Amount	Base	The monetary sales amount for the entire product category, expressed in the manufacturer's currency.
Expected Revenue	Derived	Expected revenue based on the promotion price.
Market Share	Derived	The percentage of monetary sales for the Manufacturer's item to the monetary sales of all items.
Net Cost	Base	The cost of sales, expressed in the manufacturer's currency.
Promotion Flag	Base	A flag which determines whether or not the promotion is active.
Retailer Cost (Retailer Currency)	Base	The cost of sales, expressed in the customer's currency.
Retailer GM % Point Increase (Year/Year)	Derived	The Retailer's gross margin percentage point increase year over year.
Retailer GM Increase - (Year/Year)	Derived	The increase in the retailer's gross profit, compared to the previous period.
Retailer GMROI	Derived	The customer's gross margin return on investment/ inventory.
Retailer Gross Margin	Derived	The customer's profit, expressed in the manufacturer's currency.
Return Amount	Base	The monetary value of the units returned, expressed in the manufacturer's currency.
Return Amount - Cost Basis	Base	The monetary value of the units returned, based on the customer's cost and expressed in the manufacturer's currency.
Return Amount - Cost Basis (Retailer Currency)	Base	The monetary value of the units returned, based on the customer's cost and expressed in the customer's currency.
Return Amount (Retailer Currency)	Base	The monetary value of the units returned, expressed in the customer's currency.
Return Quantity	Base	The number of units returned, expressed in the primary UOM.
Return Quantity (Alt UOM)	Base	The number of units returned, expressed in the alternate UOM.
Sales Amount	Base	The monetary value of the units sold, expressed in the manufacturer's currency.
Sales Amount (Retailer Currency)	Base	The monetary value of the units sold, expressed in the customer's currency.
Sales Growth Amount	Derived	The percentage increase in sales, as compared to the previous period and expressed in the manufacturer's currency.
Sales Growth Quantity	Derived	The percentage increase in unit sales, as compared to the previous period and expressed in the primary UOM.
Sales Growth Quantity (Alt UOM)	Derived	The growth of current unit sales, as compared to previous period and expressed in the alternate UOM.
Sales Quantity	Base	The number of units sold, expressed in the primary UOM.
Sales Quantity (Alt UOM)	Base	The number of units sold, expressed in the alternate UOM.
Sell Through	Derived	Unit sales net of any returns. Used in calculating Expected Ending Inventory.
Total Authorized Stores	Base	Total number of stores authorized to sell.
Total Category Average Profit	Derived	Average profit for the category.
Total Category Average Sales Value	Derived	Average monetary sales for the category.
Total Category Average Sales Volume	Derived	The average sales volume for the category.
Unit Profit	Derived	The average gross profit per unit sold.

Point of Sale - Previous Period Measures

Name	Type	Description
% Change by Amount Previous Period	Derived	The percent change in monetary value from the previous period.
% Change by Quantity Previous Period	Derived	The percent change in quantity in the previous period.
% Product to Category by Amount Previous Period	Derived	The unit's percentage of the category's monetary sales amount in the previous period.
% Product to Category by Quantity Previous Period	Derived	The unit's percentage of the category's sales volume in the previous period.
Average Price Per Unit Previous Period	Derived	The average price per unit in the previous period.
Category Sales Amount Previous Period	Base	The monetary sales amount for the category in the previous period.
Category Sales Quantity Previous Period	Base	The unit sales for the category in the previous period.
Net Cost Previous Period	Base	The sales cost expressed in the manufacturer's currency in the previous period.
Retailer Cost Previous Period (Retailer Currency)	Base	The retailer's cost in the previous period, and expressed in the retailer's currency.
Retailer Gross Margin Previous Period	Derived	The retailer's gross margin for the previous period.
Return Amount - Cost Basis Previous Period	Base	The value of the units returned in the previous period, based on the customer's cost and expressed in the manufacturer's currency.
Return Amount - Cost Basis Previous Period (Retailer Currency)	Base	The value of the units returned in the previous period, based on the customer's cost and expressed in the retailer's currency.
Return Amount Previous Period	Base	The monetary amount of the units returned in the previous period.
Return Amount Previous Period (Retailer Currency)	Base	The monetary amount of the units returned in the previous period, and expressed in the customer's currency.
Returns Quantity Previous Period	Base	Number of units returned in the previous period.
Returns Quantity Previous Period (Alt UOM)	Base	Number of units returned in the previous period, expressed in the alternate UOM.
Sales Amount Previous Period	Base	Monetary sales for the previous period.
Sales Amount Previous Period (Retailer Currency)	Base	Monetary sales for the previous period, expressed in the retailer's currency.
Sales Quantity Previous Period	Base	Number of units sold in the previous period.
Sales Quantity Previous Period (Alt UOM)	Base	Number of units sold in the previous period, expressed in the alternate UOM.

Point of Sale - Same Period Last Year Measures

Name	Type	Description
% Change by Amount Last Year	Derived	The percentage change in monetary value between this period and the same period last year.
% Change by Quantity Last Year	Derived	The percentage change in quantity between this period and the same period last year.
% Product to Category by Amount Last Year	Derived	The unit's percentage change in the category's monetary sales between this period and the same period last year.
% Product to Category by Quantity Last Year	Derived	The unit's percentage of the category's sales volume between this period and the same period last year.
Average Price per Unit Last Year	Derived	The average price per unit for the same period last year.
Net Cost Last Year	Base	The sales cost expressed in the manufacturer's currency for the same period last year.
Retailer Cost Last Year (Retailer Currency)	Base	The retailer's cost for the same period last year, and expressed in the retailer's currency.
Retailer Gross Margin Last Year	Derived	The retailer's monetary gross margin for the same period last year.
Return Amount - Cost Basis Last Year	Base	The monetary value of the units returned during the same period last year, based on the customer's cost and expressed in the manufacturer's currency.
Return Amount - Cost Basis Last Year (Retailer Currency)	Base	The monetary value of the units returned during the same period last year, based on the customer's cost and expressed in the retailer's currency.
Return Amount Last Year	Base	The monetary amount of the units returned during the same period last year.
Return Amount Last Year (Retailer Currency)	Base	The monetary amount of the units returned during the same period last year, expressed in the customer's currency.
Return Quantity Last Year	Base	Number of units returned during the same period last year.
Return Quantity Last Year (Alt UOM)	Base	Number of units returned during the same period last year, expressed in the alternate UOM.
Sales Amount Last Year	Base	The monetary amount sold during the same period last year.
Sales Amount Last Year (Retailer Currency)	Base	The monetary amount sold during the same period last year, expressed in the retailer's currency.
Sales Quantity Last Year	Base	Number of units sold during the same period last year.
Sales Quantity Last Year (Alt UOM)	Base	Number of units sold during the same period last year, and expressed in an alternate unit of measure.

Point of Sale - Same Period Last Year YTD Measures

Name	Type	Description
Retailer Net Cost Last Year YTD	Base	The Retailer's net cost from the same period last year, year-to-date.
Return Amount - Cost Basis Last Year YTD	Base	The monetary value of the units returned during the same period last year, based on the customer's cost and expressed in the manufacturer's currency, year-to-date .
Return Amount - Cost Basis Last Year YTD (Retailer Currency)	Base	The monetary value of the units returned during the same period last year, based on the customer's cost and expressed in the manufacturer's currency, year-to-date.
Return Amount Last Year YTD	Base	The monetary amount of the units returned during the same period last year, year-to-date.
Return Amount Last Year YTD (Retailer Currency)	Base	The monetary amount of the units returned during the same period last year, expressed in the retailer's currency, year-to-date.
Return Quantity Last Year YTD	Base	The number of units returned during same period last year, year-to-date.
Return Quantity Last Year YTD (Alt UOM)	Base	The number of units returned during same period last year, expressed in the Alternate UOM, year-to-date.
Sales Amount Last Year YTD	Base	The monetary amount sold during the same period last year, year-to-date.
Sales Amount Last Year YTD (Retailer Currency)	Base	The monetary amount sold during the same period last year and expressed in the retailer's currency, year-to-date.
Sales Quantity Last Year YTD	Base	Number of units sold during the same period last year, year-to-date.
Sales Quantity Last Year YTD (Alt UOM)	Base	Number of units sold during the same period last year and expressed in the alternate UOM, year-to-date.

Point of Sale - YTD Measures

Name	Type	Description
% Change by Amount YTD	Derived	The year-to-date percent change in monetary value.
% Change by Quantity YTD	Derived	The year-to-date percent change in quantity.
% Returns YTD	Derived	Percentage of returned goods, compared to the monetary year-to-date sales.
Net Cost YTD	Base	The year-to-date sales cost, expressed in the manufacturer's currency.
Retailer Cost YTD (Retailer Currency)	Base	The year-to-date retailer costs, expressed in the retailer's currency.
Retailer Gross Margin % YTD	Derived	The retailer's year-to-date gross margin percentage.
Retailer Gross Margin YTD	Derived	The retailer's monetary year-to-date gross margin.
Return Amount - Cost Basis YTD	Base	The monetary value of the year-to-date number of units returned, based on the customer's cost and expressed in the manufacturer's currency.
Return Amount - Cost Basis YTD (Retailer Currency)	Base	The monetary value of the year-to-date number of units returned, based on the customer's cost and expressed in the retailer's currency.
Return Amount YTD	Base	The monetary amount of the units returned year-to-date.
Return Amount YTD (Retailer Currency)	Base	The monetary amount of the units returned expressed in the customer's currency, year-to-date.
Return Quantity YTD	Base	Number of units returned year-to-date.
Return Quantity YTD (Alt UOM)	Base	Number of units returned year-to-date, expressed in the alternate UOM.
Sales Amount YTD	Base	The monetary amount of year-to-date sales.
Sales Amount YTD (Retailer Currency)	Base	The monetary amount of year-to-date sales, expressed in the retailer's currency.
Sales Quantity YTD	Base	Number of units sold year-to-date.
Sales Quantity YTD (Alt UOM)	Base	Number of units sold year-to-date, expressed in the alternate unit of measure.

Promotion Plan Measures

Name	Type	Description
Promotion From Date	Base	The start date of the retailer's promotion.
Promotion From Date Minimum	Base	The earliest start date of the retailer's promotion.
Promotion Plan Attribute 1	Base	User-defined attribute 1.
Promotion Plan Attribute 2	Base	User-defined attribute 2.
Promotion Plan Attribute 3	Base	User-defined attribute 3.
Promotion Price	Base	The retailer's promotion price for the SKU expressed in the manufacturer's currency.
Promotion Price Minimum	Base	The retailer's minimum promotion price for the SKU.
Promotion Price (Customer Currency)	Base	The retailer's promotion price for the SKU expressed in the customer's currency.
Promotion To Date	Base	Then end date of the retailer's promotion.
Promotion To Date Minimum	Base	The earliest end date of the retailer's promotion.
Promotion Type	Base	The type of promotion. For example, Feature, Display, Feature and Display, and so on.

Replenishment Rules Measures

Name	Type	Description
Lead Time Days	Base	The customer's lead time (in days) for an item.
Maximum Days Supply	Base	The customer's target maximum number of days of supply of an item.
Maximum On Hand Quantity Primary	Base	The customer's target maximum on-hand quantity (in the primary unit of measure) for an item. Used in determining if the item is overstocked.
Maximum Stock On Hand Quantity	Base	The customer's target maximum on-hand quantity for an item.
Minimum Days Supply	Base	The customer's target minimum number of days of supply of an item.
Minimum Stock On Hand Quantity	Base	The customer's target maximum on-hand quantity for an item. Used in determining if the item is understocked.
Reorder Interval	Base	The customer's target reorder interval.
Reorder Quantity	Base	The customer's target reorder quantity.
Reorder Threshold	Base	The customer's target reorder threshold quantity. Used in determining if the item is understocked.
Replenishment Method	Base	The customer's replenishment method for an item.
Target Days of Supply	Base	The customer's target number of days of supply for an item.
Target On Hand Quantity	Base	The customers's target on-hand quantity for an item.

Sales Inventory Measures

Name	Type	Description
Back Order Amount - Cost Basis	Derived	The average monetary value of the units on order based on the customer's cost and expressed in the manufacturer's currency.
Back Order Amount - Cost Basis (Retailer Currency)	Derived	The average monetary value of the units on order based on the customer's cost and expressed in the customer's currency.
Back Ordered Quantity	Derived	The average number of units on order, expressed in the primary UOM.
Back Ordered Quantity (Alt UOM)	Derived	The average number of units on order, expressed in the alternate UOM.
Back Ordered Retail Amount	Derived	The average monetary value of the units on order based on retail price expressed in the manufacturer's currency.
Back Ordered Retail Amount (Retailer Currency)	Derived	The average monetary value of the units on order based on retail price expressed in the customer's currency.
Expected Ending Inventory	Derived	The expected ending on-hand inventory quantity for the current period based on starting with the previous period's actual ending inventory quantity plus receipts and less any sales in the current period.
In-stock %	Derived	Percentage of the number of SKU/BU/DAY instances where on-hand inventory quantity was greater than 0 as compared to the total number of SKU/BU/DAY instances.
In-Transit Amount - Cost Basis	Derived	The average monetary value of the units in transit based on the customer's cost expressed in the manufacturer's currency.
In-Transit Amount - Cost Basis (Retailer Currency)	Derived	The average monetary value of the units in transit based on the customer's cost expressed in the customer's currency.
In-Transit Quantity	Derived	The average number of units in transit, expressed in the primary UOM.
In-Transit Quantity (Alt UOM)	Derived	The average number of units in transit, expressed in the alternate UOM.
In-Transit Retail Amount	Derived	The average monetary value of the units in transit based on retail price expressed in the manufacturer's currency.
In-Transit Retail Amount (Retailer Currency)	Derived	The average monetary value of the units in transit based on retail price expressed in the retailer's currency.
Inventory Cover	Derived	The number of days of supply over a given period.
Inventory Turns (Annual)	Derived	The number of times (or turns) inventory has been sold in a given period.
On-Hand Inventory - Cost Basis	Derived	The average monetary value of on-hand inventory based on the customer's cost, expressed in the manufacturer's currency.
On-Hand Inventory - Cost Basis (Retailer Currency)	Derived	The average monetary value of on-hand inventory based on the customer's cost, expressed in the retailer's currency.
On-Hand Inventory Quantity	Derived	The average on-hand inventory quantity (for example, units), expressed in the primary UOM.
On-Hand Inventory Quantity (Alt UOM)	Derived	The average on-hand inventory quantity (for example, units), expressed in the alternate UOM.
On-Hand Inventory Retail Amount	Derived	The average monetary value of on-hand inventory based on retail price, expressed in the manufacturer's currency.
On-Hand Inventory Retail Amount (Retailer Currency)	Derived	The average monetary value of on-hand inventory based on retail price, expressed in the retailer's currency.
Overstock	Derived	The number of units over the customer replenishment rules' maximum on-hand quantity.
Quality Hold Amount - Cost Basis	Derived	The average monetary value of the units on quality hold based on the customer's cost, expressed in the manufacturer's currency.
Quality Hold Amount - Cost Basis (Retailer Currency)	Derived	The average monetary value of the units on quality hold based on the customer's cost, expressed in the retailer's currency.
Quality Hold Quantity	Derived	The average number of units on quality hold, expressed in the primary UOM.
Quality Hold Quantity (Alt UOM)	Derived	The average number of units on quality hold, expressed in the alternate UOM.
Quality Hold Retail Amount	Derived	The average monetary value of the units on quality hold, based on retail price and expressed in the manufacturer's currency.
Quality Hold Retail Amount (Retailer Currency)	Derived	The average monetary value of the units on quality hold, based on retail price and expressed in the retailer's currency.
Receipt Amount	Base	The monetary value of the units received based on retail price, expressed in the manufacturer's currency.
Receipt Amount - Cost Basis	Base	The monetary value of the units received, based on the customer's cost and expressed in the manufacturer's currency.
Receipt Amount (Retailer Currency)	Base	The monetary value of the units received, based on the customer's cost and expressed in the retailer's currency.
Receipt Quantity	Base	The number of units received, expressed in the primary UOM.
Receipt Quantity (Alt UOM)	Base	The number of units received, expressed in the alternate UOM.
Receipts Amount - Cost Basis (Retailer Currency)	Base	The monetary value of the units received, based on the customer's cost and expressed in the retailer's currency.
Understock	Derived	The number of units under the customer replenishment rules' reorder threshold.
Understock %	derived	Percentage of SKU/BU/DAY instances where on-hand inventory quantity was less than the minimum on-hand quantity (from customer's inventory replenishment rules), as compared to the total number of SKU/BU/DAY instances.

Sales Inventory - Previous Period Measures

Measure	Type	Description
Back Ordered Amount - Cost Basis Previous Period	Derived	The average monetary value of the units on order for the previous period, based on the customer's cost and expressed in the manufacturer's currency.
Back Ordered Amount - Cost Basis Previous Period (Retailer Currency)	Derived	The average monetary value of the units on order for the previous period, based on the customer's cost and expressed in the customer's currency.
Back Ordered Quantity Previous Period	Derived	The average number of units on order for the previous period, expressed in the primary UOM.
Back Ordered Quantity Previous Period (Alt UOM)	Derived	The average number of units on order during the previous period, expressed in the alternate UOM.
Back Ordered Retail Amount Previous Period	Derived	The average monetary value of the units on order for the previous period, based on the retail price and expressed in the manufacturer's currency.
Back Ordered Retail Amount Previous Period (Retailer Currency)	Derived	The average monetary value of the units on order for the previous period, based on the retail price and expressed in the retailer's currency.
In-Transit Amount - Cost Basis Previous Period	Derived	The average monetary value of the units in transit during the previous period, based on the customer's cost and expressed in the manufacturer's currency.
In-Transit Amount - Cost Basis Previous Period (Retailer Currency)	Derived	The average monetary value of the units in transit during the previous period, based on the customer's cost and expressed in the retailer's currency.
In-Transit Quantity Previous Period	Derived	The average number of units in transit during the pervious period, expressed in the primary UOM.
In-Transit Quantity Previous Period (Alt UOM)	Derived	The average number of units in transit during the pervious period, expressed in the alternate UOM.
In-Transit Retail Amount Previous Period	Derived	The average monetary value of the units in transit during the previous period, based on the retail price and expressed in the manufacturer's currency.
In-Transit Retail Amount Previous Period (Retailer Currency)	Derived	The average monetary value of the units in transit during the previous period, based on the retail price and expressed in the manufacturer's currency.
On-Hand Inventory - Cost Basis Previous Period	Derived	The average monetary value of the units on quality hold during the previous period, based on the customer's cost and expressed in the customer's currency.
Quality Hold Quantity Previous Period	Derived	The average number of units on quality hold during the previous period, expressed in the primary UOM.
Quality Hold Quantity Previous Period (Alt UOM)	Derived	The average number of units on quality hold during the previous period, expressed in the alternate UOM.
Quality Hold Retail Amount Previous Period	Derived	The average monetary value of the units on quality hold during the previous period, based on retail price and expressed in the manufacturer's currency.
Quality Hold Retail Amount Previous Period (Retailer Currency)	Derived	The average monetary value of the units on quality hold during the last period, based on retail price and expressed in the customer's currency.
Receipt Amount - Cost Basis Previous Period	Base	The monetary value of the units received during the previous period, based on the customer's cost and expressed in the manufacturer's currency.
Receipt Amount - Cost Basis Previous Period (Retailer Currency)	Base	The monetary value of the units received during the previous period, based on the customer's cost and expressed in the customer's currency.
Receipt Amount Previous Period	Base	The monetary value of the units received during the previous period, based on the retail price and expressed in the manufacturer's currency.
Receipt Quantity Previous Period	Base	The number of units received during the previous period, expressed in the primary UOM.
Receipt Quantity Previous Period (Alt UOM)	Base	The number of units received during the previous period, expressed in the alternate UOM.
Receipts Amount Previous Period (Retailer Currency)	Base	The monetary value of the units received during the previous period, based on retail price and expressed in the customer's currency.

Sales Inventory - Same Period Last Year Measures

Measure	Type	Description
Back Ordered Amount - Cost Basis Last Year	Derived	The average monetary value of the units on order for the same period of the last year, based on the customer's cost and expressed in the manufacturer's currency.
Back Ordered Amount - Cost Basis Last Year (Retailer Currency)	Derived	The average monetary value of the units on order for the same period of the last year, based on the customer's cost and expressed in the retailer's currency.
Back Ordered Quantity Last Year	Derived	The average number of units on order during the same period of the previous period, expressed in the primary UOM .
Back Ordered Quantity Last Year (Alt UOM)	Derived	The average number of units on order during the same period of the previous period, expressed in the alternate UOM .
Back Ordered Retail Amount Last Year	Derived	The average monetary value of the units on order during the same period of the previous year, based on retail price and expressed in the manufacturer's currency.
Back Ordered Retail Amount Last Year (Retailer Currency)	Derived	The average monetary value of the units on order during the same period of the previous year, based on retail price and expressed in the retailer's currency.
In-Transit Amount - Cost Basis Last Year	Derived	The monetary value of goods in-transit, based on the customer's cost and expressed in the manufacturer's currency.
In-Transit Amount - Cost Basis Last Year (Retailer Currency)	Derived	The monetary value of goods in-transit, based on the customer's cost and expressed in the retailer's currency.
In-Transit Quantity Last Year	Derived	The average number of units in transit for the same period of the previous year, and expressed in the primary UOM.
In-Transit Quantity Last Year (Alt UOM)	Derived	The average number of units in transit for the same period of the previous year, and expressed in the alternate UOM.
In-Transit Retail Amount Last Year	Derived	The average monetary value of the units in transit during the same period of the previous year, based on retail price and expressed in the manufacturer's currency.
In-Transit Retail Amount Last Year (Retailer Currency)	Derived	The average monetary value of the units in transit during the same period of the previous year, based on retail price and expressed in the retailer's currency.
On-Hand Inventory - Cost Basis Last Year	Derived	The average monetary value of on-hand inventory, based on the customer's cost and expressed in the manufacturer's currency.
On-Hand Inventory - Cost Basis Last Year (Retailer Currency)	Derived	The average monetary value of on-hand inventory, based on the customer's cost and expressed in the retailer's currency.
On-Hand Inventory Quantity Last Year	Derived	The average on-hand inventory quantity for the same period of the previous year, expressed in the primary UOM.
On-Hand Inventory Quantity Last Year (Alt UOM)	Derived	The average on-hand inventory quantity for the same period of the previous year, expressed in the alternate UOM.
On-Hand Inventory Retail Amount Last Year	Derived	The average monetary value of on-hand inventory during the same period of the previous year, based on retail price and expressed in the manufacturer's currency .
On-Hand Inventory Retail Amount Last Year (Retailer Currency)	Derived	The average monetary value of on-hand inventory during the same period of the previous year, based on retail price and expressed in the retailer's currency .
Quality Hold Amount - Cost Basis Last Year	Derived	The average monetary value of the units on quality hold during the same period of the previous year, based on the customer's cost and expressed in the manufacturer's currency.
Quality Hold Amount - Cost Basis Last Year (Retailer Currency)	Derived	The average monetary value of the units on quality hold during the same period of the previous year, based on the customer's cost and expressed in the retailer's currency.
Quality Hold Quantity Last Year	Derived	The average number of units on quality hold during the same period of the pervious year, expressed in the primary UOM.
Quality Hold Quantity Last Year (Alt UOM)	Derived	The average number of units on quality hold during the same period of the pervious year, expressed in the alternate UOM.
Quality Hold Retail Amount Last Year	Derived	The average monetary value of the units on quality hold during the same period of the previous year, based on retail price and expressed in the manufacturer's currency.
Quality Hold Retail Amount Last Year (Retailer Currency)	Derived	The average monetary value of the units on quality hold during the same period of the previous year, based on retail price and expressed in the retailer's currency.
Receipt Amount - Cost Basis Last Year	Base	The monetary value of the units received during the same period of the previous year, based on the customer's cost expressed in the manufacturer's currency.
Receipt Amount - Cost Basis Last Year (Retailer Currency)	Base	The monetary value of the units received during the same period of the previous year, based on the customer's cost expressed in the retailer's currency.
Receipt Amount Last Year	Base	The monetary value of the units received during the same period of the previous year, based on the retail price and expressed in the manufacturer's currency .
Receipt Amount Last Year (Retailer Currency)	Base	The monetary value of the units received during the same period of the previous year, based on the retail price and expressed in the retailer's currency .
Receipt Quantity Last Year	Base	The number of units received during the same period of the previous year, expressed in the primary UOM.
Receipt Quantity Last Year (Alt UOM)	Base	The number of units received during the same period of the previous year, expressed in the alternate UOM.

Sales Inventory - Same Period Last Year YTD Measures

Measure	Type	Description
Back Order Inventory - Cost Basis (Customer Currency) Last Year YTD	Derived	The YTD average monetary value of the units on order during the same period of the previous year, based on the customer's cost and expressed in the customer's currency.
Back Order Inventory - Cost Basis Last Year YTD	Derived	The YTD average monetary value of the units on order during the same period of the previous year, based on the customer's cost and expressed in the manufacturer's currency.
Back Order Inventory - Quantity (Alt UOM) Last Year YTD	Derived	The YTD average number of units on order during the same period of the previous year, expressed in the alternate UOM.
Back Order Inventory - Quantity Last Year YTD	Derived	The YTD average number of units on order during the same period of the previous year, expressed in the primary UOM.
Back Order Inventory - Retail Value (Customer Currency) Last Year YTD	Derived	The YTD average monetary value of the units on order during the pervious year, based on the retail price and expressed in the customer's currency.
Back Order Inventory - Retail Value Last Year YTD	Derived	The YTD average monetary value of the units on order during the pervious year, based on the retail price and expressed in the manufacturer's currency.
In-Transit Inventory - Cost Basis (Customer Currency) Last Year YTD	Derived	The YTD average monetary value of the units in transit during the previous year, based on the customer's cost and expressed in the customer's currency.
In-Transit Inventory - Cost Basis Last Year YTD	Derived	The YTD average monetary value of the units in transit during the previous year, based on the customer's cost and expressed in the manufacturer's currency.
In-Transit Inventory - Quantity Last Year YTD	Derived	The YTD average number of units on order during the previous period, expressed in the primary UOM.
In-Transit Inventory - Quantity (Alt UOM) Last Year YTD	Derived	The YTD average number of units on order during the previous period, expressed in the alternate UOM.
In-Transit Inventory - Retail Value (Customer Currency) Last Year YTD	Derived	The YTD average monetary value of the units in transit during the previous year, based on the retail price and expressed in the customer's currency.
In-Transit Inventory - Retail Value Last Year YTD	Derived	The YTD average monetary value of the units in transit during the previous year, based on the retail price and expressed in the manufacturer's currency.
Inventory on Quality Hold - Amount - Cost Basis (Customer Currency) Last Year YTD	Derived	The YTD monetary value of the units on quality hold during the previous year, based on the customer's cost and expressed in the customer's currency.
Inventory on Quality Hold - Quantity (Alt UOM) Last Year YTD	Derived	The YTD average number of units on quality hold for the previous year, expressed in the alternate UOM.
Inventory on Quality Hold - Quantity Last Year YTD	Derived	The YTD average number of units on quality hold for the previous year, expressed in the primary UOM.
Inventory on Quality Hold - Retail Value (Customer Currency) Last Year YTD	Derived	The YTD average monetary value of the units on quality hold during the previous year, based on the retail price and expressed in the customer's currency.
Inventory on Quality Hold - Retail Value Last Year YTD	Derived	The YTD average monetary value of the units on quality hold during the previous year, based on the retail price and expressed in the manufacturer's currency.
On Hand Inventory - Quantity (Alt UOM) Last Year YTD	Derived	The YTD average on-hand inventory quantity for the previous year, expressed in the alternate UOM.
On Hand Inventory - Quantity Last Year YTD	Derived	The YTD average on-hand inventory quantity for the previous year, expressed in the primary UOM.
On-Hand Inventory - Cost Basis (Customer Currency) Last Year YTD	Derived	The YTD average monetary value of on-hand inventory during the previous year, based on the customer's cost and expressed in the customer's currency.
On-Hand Inventory - Cost Basis Last Year YTD	Derived	The YTD average monetary value of on-hand inventory during the previous year, based on the customer's cost and expressed in the manufacturer's currency.
On-Hand Inventory - Retail Value (Customer Currency) Last Year YTD	Derived	The YTD average monetary value of on-hand inventory for the previous year, based on retail price and expressed in the customer's currency.
On-Hand Inventory - Retail Value Last Year YTD	Derived	The YTD average monetary value of on-hand inventory for the previous year, based on retail price and expressed in the manufacturer's currency.
Receipt Amount - Cost Basis Last Year YTD	Base	The YTD monetary value of the units received during the previous year, based on the customer's cost and expressed in the manufacturer's currency.
Receipt Amount - Cost Basis Last Year YTD (Customer Currency)	Base	The YTD monetary value of the units received during the previous year, based on the customer's cost and expressed in the customer's currency.
Receipt Amount Last Year YTD	Base	The YTD monetary value of the units received during the previous year, based on the retail price and expressed in the manufacturer's currency.
Receipt Amount Last Year YTD (Retailer Currency)	Base	The YTD monetary value of the units received during the previous year, based on the retail price and expressed in the retailer's currency.
Receipt Quantity Last Year YTD	Base	The YTD number of units received in the previous year, expressed in the primary UOM.
Receipt Quantity Last Year YTD (Alt UOM)	Base	The YTD number of units received in the previous year, expressed in the alternate UOM.

Sales Inventory - YTD Measures

Measure	Type	Description
Back Order Inventory - Cost Basis (Customer Currency) YTD	Derived	The YTD average monetary value of the units on order, based on the customer's cost and expressed in the customer's currency.
Back Order Inventory - Cost Basis YTD	Derived	The YTD average monetary value of the units on order, based on the customer's cost and expressed in the manufacturer's currency.
Back Order Inventory - Quantity YTD	Derived	The YTD average number of units on order, expressed in the primary UOM.
Back Order Inventory - Quantity (Alt UOM) YTD	Derived	The YTD average number of units on order, expressed in the alternate UOM.
The YTD average number of units on order, expressed in the primary UOM.	Derived	The YTD average monetary value of the units on order based on retail price, expressed in the customer's currency.
Back Order Inventory - Retail Value YTD	Derived	The YTD average monetary value of the units on order based on retail price, expressed in the manufacturer's currency.
In-Transit Inventory - Cost Basis YTD	Derived	The YTD average monetary value of the units in transit, based on the customer's cost and expressed in the manufacturer's currency.
In-Transit Inventory - Cost Basis (Customer Currency) YTD	Derived	The YTD average monetary value of the units in transit, based on the customer's cost and expressed in the customer's currency.
In-Transit Inventory - Quantity YTD	Derived	The YTD average number of units on order, expressed in the primary UOM.
In-Transit Inventory - Quantity (Alt UOM) YTD	Derived	The YTD average number of units on order, expressed in the alternate UOM.
In-Transit Inventory - Retail Value (Customer Currency) YTD	Derived	The YTD average monetary value of the units in transit, based on the retail price and expressed in the customer's currency.
The YTD average monetary value of the units in transit based on retail price expressed in the customer's currency.	Derived	The YTD average monetary value of the units in transit, based on the retail price and expressed in the manufacturer's currency.
Inventory Cover YTD	Derived	The YTD average number of days of cover of an item.
Inventory on Quality Hold - Cost Basis (Customer Currency) YTD	Derived	The YTD monetary value of the units on quality hold, based on the customer's cost and expressed in the customer's currency.
Inventory on Quality Hold - Cost Basis YTD	Derived	The YTD monetary value of the units on quality hold based on the customer's cost, expressed in the manufacturer's currency.
Inventory on Quality Hold - Quantity YTD	Derived	The YTD average number of units on quality hold, expressed in the primary UOM.
Inventory on Quality Hold - Quantity (Alt UOM) YTD	Derived	The YTD average number of units on quality hold, expressed in the alternate UOM.
Inventory on Quality Hold - Retail Value (Customer Currency) YTD	Derived	The YTD average monetary value of the units on quality hold, based on the retail price and expressed in the customer's currency.
Inventory on Quality Hold - Retail Value YTD	Derived	The YTD average monetary value of the units on quality hold, based on retail price and expressed in the manufacturer's currency.
On Hand Inventory - Quantity YTD	Derived	The YTD average on-hand inventory quantity, expressed in the primary UOM.
On Hand Inventory - Quantity (Alt UOM) YTD	Derived	The YTD average on-hand inventory quantity, expressed in the alternate UOM.
On-Hand Inventory - Cost Basis (Customer Currency) YTD	Derived	The YTD average monetary value of on-hand inventory based on the customer's cost and expressed in the customer's currency.
On-Hand Inventory - Cost Basis YTD	Derived	The YTD average monetary value of on-hand inventory, based on the customer's cost and expressed in the manufacturer's currency.
On-Hand Inventory - Retail Value (Customer Currency) YTD	Derived	The YTD average monetary value of on-hand inventory, based on retail price and expressed in the customer's currency.
On-Hand Inventory - Retail Value YTD	Derived	The YTD average monetary value of on-hand inventory, based on retail price and expressed in the manufacturer's currency.
Receipt Amount - Cost Basis YTD	Base	The YTD monetary value of the units received, based on the customer's cost and expressed in the manufacturer's currency.
Receipt Amount - Cost Basis YTD (Customer Currency)	Base	The YTD monetary value of the units received, based on the customer's cost and expressed in the customer's currency.
Receipt Amount YTD	Base	The YTD monetary value of the units received, based on retail price and expressed in the manufacturer's currency.
Receipt Amount YTD (Retailer Currency)	Base	The YTD monetary value of the units received, based on retail price and expressed in the retailer's currency.
Receipt Quantity YTD	Base	The YTD number of units received, expressed in the primary UOM.
Receipt Quantity YTD (Alt UOM)	Base	The YTD number of units received, expressed in the alternate UOM.

Store Orders Measures

Measure	Type	Description
Order Amount	Base	The monetary value of the ordered units, expressed in the manufacturer's currency.
Order Amount (Retailer Currency)	Base	The monetary value of the ordered units, expressed in the retailer's currency.
Order Quantity	Base	The number of units ordered, expressed in the primary UOM.
Order Quantity (Alt UOM)	Base	The number of units ordered, expressed in the alternate UOM.

Store Orders - Previous Period Measures

Measure	Type	Description
Order Amount Previous Period	Base	The monetary value of the ordered units for the previous period, expressed in the manufacturer's currency.
Order Amount Previous Period (Retailer Currency)	Base	The monetary value of the ordered units for the previous period, expressed in the retailer's currency.
Order Quantity Previous Period	Base	The number of units ordered during the previous period, expressed in the primary UOM.
Order Quantity Previous Period (Alt UOM)	Base	The number of units ordered during the previous period, expressed in the alternate UOM.

Store Orders - Same Period Last Year Measures

Measure	Type	Description
Order Amount Last Year	Base	The monetary value of the units ordered during the previous year, expressed in the manufacturer's currency.
Order Amount Last Year (Retailer Currency)	Base	The monetary value of the units ordered during the previous year, expressed in the retailer's currency.
Order Quantity Last Year	Base	The number of units ordered during the same period of the previous year, expressed in the primary UOM.
Order Quantity Last Year (Alt UOM)	Base	The number of units ordered during the same period of the previous year, expressed in the alternate UOM.

Store Orders - Same Period Last Year YTD Measures

Measure	Type	Description
Order Amount Last Year YTD	Base	The YTD monetary value of the units ordered during the previous year, expressed in the manufacturer's currency.
Order Amount Last Year YTD (Retailer Currency)	Base	The YTD monetary value of the units ordered during the previous year, expressed in the retailer's currency.
Order Quantity Last Year YTD	Base	The YTD number of units ordered during the previous year, expressed in the primary UOM.
Order Quantity Last Year YTD (Alt UOM)	Base	The YTD number of units ordered during the previous year, expressed in the alternate UOM.

Store Orders - YTD Measures

Measure	Type	Description
Order Amount YTD	Base	The YTD monetary value of the ordered units, expressed in the manufacturer's currency.
Order Amount YTD (Retailer Currency)	Base	The YTD monetary value of the ordered units, expressed in the retailer's currency.
Order Quantity YTD	Base	The YTD number of units ordered, expressed in the primary UOM.
Order Quantity YTD	Base	The YTD number of units ordered, expressed in the alternate UOM.

Syndicated Consumption Data Measures

Measure	Type	Description
Measure Set	Base	A name given a single set of 100 syndicated consumption data measures. For example "IRI Measures" or "ACNielsen Measures". This measure is useful if more than 100 measures are needed, or if loading data from two different sources.
Measures 1 - 100	Base	A generic set of 100 measures used to load syndicated data. Measures can vary based on what the DSR customer has purchased.
Source	Base	The source of the syndicated consumption data. For example, "IRI" or "ACNielsen".

External Measures

The following external measures can be loaded into DSR:

Measure Name	Dimensions	Calculation or Loaded Level	Allocation Method	Aggregation Method	Description
Invoice Accuracy %	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group or Retailer Customer Item: Supplier	None	N/A	Percent deviation of invoice amount from agreed price and received quantity, or percentage of invoices that fell within tolerance established.
Payment Days	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group or Retailer Customer Item: Supplier	None	N/A	Average number of days from invoice to payment.
Late Payment	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group or Retailer Customer Item: Supplier	None	N/A	Average number of days payments were late.
Number of Deductions	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group or Retailer Customer Item: Supplier	None	N/A	Count of deductions taken.
Deduction Balance	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group or Retailer Customer Item: Supplier	None	N/A	Monetary amount of deductions taken.
Deduction Balance	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group or Retailer Customer Item: Supplier	None	N/A	Monetary balance of outstanding deductions.
Item Data Accuracy %	Time, Customer Org, Customer Item	Time: Week or Month Customer Org: Retailer Group or Retailer Customer Item: Supplier	None	N/A	The percentage of items that are synchronized via the Global Data Synchronization Network (GDSN).
Item Data Synchronization %	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group, Retailer, Store Customer Item: Any	None	N/A	The percentage error of the POS forecast vs actual sales for the period.
Order Change %	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group, Retailer Customer Item: Above Category	None	N/A	Percentage of orders or line items that had to be revised prior to shipment.
Perfect Order %	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group, Retailer, RDC Customer Item: Above Category	None	N/A	The number of orders with no errors, filled correctly for every line, on time and invoiced correctly divided by the total number of orders.
Order Cycle Time	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group, Retailer, Store Customer Item: Above Category	None	N/A	The average number of days from when a PO is written until it is received.
On-time Delivery (appointment date)	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group, Retailer, Store Customer Item: Above Category	None	N/A	Percentage of shipments delivered by appointment date.
On-time Delivery (appointment time)	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group, Retailer, Store Customer Item: Above Category	None	N/A	Percentage of shipments that were delivered within the appointment window on the appointment date.
Service Level / Fill Rate	Time, Customer Org, Customer Item	Time: Above Day Customer Org: Retailer Group, Retailer, Store Customer Item: Above Category	None	N/A	Amount ordered vs amount shipped.

Loading Syndicated Consumption Measures

Syndicated consumption data (also known as All Commodity Volume or ACV measures) can be purchased at various levels of the product hierarchy and customer organization hierarchy, as well as geographic region or sub-region and then loaded into Demand Signal Repository. In order to calculate ACV %, the consumer goods manufacturer must obtain store volumes of all stores in the desired geographical area. Obtaining store volume information from syndicated data sources is expensive and can be cost prohibitive. The more common practice is to purchase pre-calculated ACV measures from the syndicated data source for the desired Product, Retailer and/or Geography, and Time Period combinations.

Since Consumer Goods Manufacturers may receive ACV consumption data from multiple sources, DSR allows the same measure to come from different sources, so long as the data is for different dimensions (for example, geographies). The system will issue an error when a measure is received from a second source for the same dimension. For example, if Kroger measures were received for the Atlanta market area from IRI, an error would be issues if Kroger data for the Atlanta market area was received from AC Nielsen (or other source).

DSR Syndicated Consumption Data references the following logical entities:

All Commodity Volume (ACV) Measures

One of the types of syndicated consumption measures are All Commodity Volume (ACV) measures. These measures are commonly used by consumer goods manufacturers to analyze market share. ACV represents the total annual sales volume of retailers, which is aggregated from the individual store level up to larger geographical sets. When dividing total sales for a store into ACV million dollar blocks, it allows for weighting across different sized markets. For example, Vision Consumer Goods (a beverage manufacturer) has its Homestyle Root Beer distributed in one supermarket in a community with five supermarkets total. A straight percentage of stores displaying Homestyle Rootbeer would read 20% display; however, the one store that handles Homestyle Root Beer is responsible for 90% of all supermarket sales in the community. The numbers that would be reflected for Homestyle root beer would be 90% ACV display activity. In this example, ACV % is the percentage of exposure to consumer spending in the class of trade being analyzed for Homestyle Rootbeer during the specified time period.

Sample Syndicated Consumption Data

The layout of syndicated consumption data varies by Consumer Good manufacturer. The order of columns, measures to be included, and date format may be different; however, the measures will always have an associated product key, geography key and time code. Below is a sample of syndicated consumption data. The product key and geography description fields (bolded) are not actually part of the file; they have been included in the file layout to make it easier for the reader to understand the data. The number of measures received will vary based on what data the Consumer Goods manufacturer has purchased.

Product Key	Product Key Description	Geography Key	Geography Key Description	Time Code (Week Ending Date)	Measure 1 (Base Dollars, No Promo)	Measure 2 (Base Volume, No Promo)	Measure 3 (% ACV, No Promo)	Measure 4 ACV $ (MM)
1001	Fit Water 1 Lt	524313	KROGER ATLANTA-RMA - FOOD	81130	4508.57	49416	6.13	3,500
1001	Fit Water 1 Lt	524317	KROGER DALLAS-RMA - FOOD	81130	6102.18	59160	7.95	4,500
1001	Fit Water 1 Lt	200996	SOUTHEAST - FOOD - STANDARD REGION	81130	7713.06	62033	9.77	3,600,000
1001	Fit Water 1 Lt	200997	NORTHEAST - FOOD - STANDARD REGION	81130	1309.71	8160	11.59	4,600,000
2001	Filtered Water	524313	KROGER ATLANTA-RMA - FOOD	81130	1506.76	8220	15.23	3,500
2001	Filtered Water	524317	KROGER DALLAS-RMA - FOOD	81130	2109.07	9001	18.87	4,500
2002	Flavored Water	524313	KROGER ATLANTA-RMA - FOOD	81130	1004.04	4213	22.51	4,500
2002	Flavored Water	524317	KROGER DALLAS-RMA - FOOD	81130	5504.12	23391	26.15	3,500
3001	Bottled Water	524313	KROGER ATLANTA-RMA - FOOD	81130	18518.57	63426	31.60	3,500
3001	Soft Drinks	524317	KROGER DALLAS-RMA - FOOD	81130	21519.57	66427	37.06	4,500

Product Key

The product key is a numeric code that represents one of the levels in a product hierarchy. For example, the data above illustrates data received at the SKU level (the first four rows), product subclass level (rows 5 – 8), and class (rows 9 & 10). To translate product key into DSR terms, you would need a table that looks like the following:

Source	Product Key	Product Name	Product Hierarchy Level	Product Code
IRI	1001	Fit Water 1 Lt	SKU	Fit Water 1 Lt
IRI	1001	Fit Water 1 Lt	SKU	Fit Water 1 Lt
IRI	1001	Fit Water 1 Lt	SKU	Fit Water 1 Lt
IRI	1001	Fit Water 1 Lt	SKU	Fit Water 1 Lt
IRI	2001	Filtered Water	Subclass	Filtered Water
IRI	2001	Filtered Water	Subclass	Filtered Water
IRI	2002	Flavored Water	Subclass	Flavored Water
IRI	2002	Flavored Water	Subclass	Flavored Water
IRI	3001	Bottled Water	Class	Bottled Water
IRI	3001	Soft Drinks	Class	Soft Drinks

Note: Since product and geography keys are unique by data source, it’s necessary to identify the source in order to translate the product key.

Geography Key

The geography key is a numeric code that represents a combination market area, retail organization (at various levels of the hierarchy), Region or Sub-region and Channel. To translate geography key into DSR terms, you would need a table that looks like the following:

Source	Geography Key	Geography Name	Market Area	Organization Level	Organization Code	Region	Sub-Region	Channel
IRI	524313	KROGER ATLANTA-RMA - FOOD	ATLANTA	Chain	KROGER	na	na	FOOD
IRI	524317	KROGER DALLAS-RMA - FOOD	DALLAS	Org	KROGER	na	na	FOOD
IRI	524321	KROGER MID-ATLANTIC-RMA - FOOD	ATLANTA	Org	KROGER	na	na	FOOD
IRI	524322	KROGER MID-SOUTH-RMA - FOOD	SOUTH	Org	KROGER	na	na	FOOD
IRI	524302	KROGER QFC SEATTLE-RMA - FOOD	SEATTLE	Chain	KROGER QFC	na	na	FOOD

The data listed above illustrates valid combinations represented by geography key. For example, market area, region and sub-region are mutually exclusive. A measure can only be associated to one. Valid combinations include:

• Channel / Region

• Channel / Sub-region

• Channel / Market Area

• Channel / Market Area / Retail Organization

• Channel / Retail Organization

Setting Goals

Demand Signal Repository provides the ability to load goals and thresholds at various levels of the organization and item hierarchy for a given time period (i.e., year, quarter, week, etc.) The main purpose of goals and thresholds is to determine whether performance targets are being met; however, these goals and thresholds are not currently used in driving the color-coded performance indicators.

You can enter a goal for each measure at any level combination that is available in the scorecard dashboard. By default, a goal applies to all periods from the present going forward. Alternatively, you can specify a beginning and ending period for which the goal being entered should apply. In this way, goals can be set retroactively, and can be set for future periods without changing the goals for current periods.

The goal is either a constant scalar value, such as 9% for sales growth, or a ratio applied to a prior result (for example, units sold last year’s sales * 1.09 = goal for sales units this year for each week of the year).

You can also enter a single goal value that is to apply to many categories and/or regions. For example, if a user wants to set the days of supply goal for each of its regions to 14 days, they can select all of the combinations to which this goal is to apply, and enter the value once. The same value will be saved for each of the affected combinations. If new regions are subsequently added at a level within this type of goal specification, they automatically inherit these goals.

Runtime Evaluation of Goals

DSR uses color-coded performance indicators which are based on the loaded goals and thresholds. For each measure, a goal is either the lower or upper bound of performance. For example, a goal for sales growth is a lower bound measure, since exceeding the performance is considered good news. In other cases, such as the goal for days of supply (an upper bound measure) a higher number of days of supply would indicate an overstock (or negative) condition. If a goal is set for a measure and data is available for the period being measured, the display for that product/location/measure combination will be green if:

• The measure is a lower bound and the value meets or exceeds the goal

• The measure is an upper bound and the value is at or below the goal

The display is red if:

• The measure is a lower bound and the value is outside the tolerance for a major issue

• The measure is an upper bound and the value is outside the tolerance for a major issue

Otherwise the display is yellow.

If there is no data for the period being displayed for a measure, the result for the most recently available prior period should be displayed, with some visual indicator (hash marks or otherwise) that the value is not current. If there is no data from any prior period that was measured against a goal, the display for that product/location/measure combination is grayed.

Setting Thresholds

You can set Demand Signal Repository thresholds that determine whether goals are in the upper or lower bounds of performance.

For example, a goal for sales growth would typically be a lower bound, since exceeding the performance would be considered good news. Meanwhile, the goal for days of supply might be an upper bound, since a higher number of days of supply would indicate an overstock condition.

Note, however, that days of supply can also be too low, creating an understock condition. In this case, a separate goal could be set for the measure as a lower bound. It would then have a separate place in the scorecard for understock and overstock monitoring.

The second aspect of threshold setting is determining whether a goal shortfall is minor (yellow status) or major (red status). Users can either set a global tolerance for this (greater than 20 percent shortfall or overshooting of the goal indicates a red status), or they can specify a tolerance (in percentage or absolute terms) for individual measures, much as they set up the goals themselves.

Note: Scorecard thresholds are only applicable to retailer hierarchies.