Below fields are used in Basic Analysis Dashboard:
-
Product ID
-
Product Name
-
Product Group
-
Customer ID
-
Customer Name
-
Customer Class
-
Customer Type
-
Invoice Price
-
Quantity
-
Pricing Date
-
Pricing Date Week
-
Pricing Date Month
-
Pricing Date Quarter
-
Pricing Date Year
-
(Gross) Margin
-
(Gross) Margin Percentage
-
Sales Channel Discount (optional)
-
Promotion Discount (optional)
-
Competitor Discount (optional)
-
Volume Discount (optional)
-
Customer Negotiated Discount (optional)
Please keep in mind that only proper data is needed, there is no need to match name/label with POP’s predefined names. Mapping Datamart fields to the dashboard is done in the next step.