How to map one to many products in Anaplan?
Hello, I have the following problem. I am trying to associate Customer Part Number, which is a unique product code in the customer's store with the SKU that exists in my store. For example, the customer sells a set of furniture, a table and 4 chairs, as one code in his store, and in my store there will be two separate SKU codes for products for the table and for the chair. Hence, when receiving an order from a customer with his code, I have to remap it to two separate codes along with the number of products that the customer's code corresponds to.
I created the first SYS04 SKU CPN Mapping module, where I have two lists: Customer Part Number and SKU and Line Item Quantity. This module is intended to be used to copy the given Customer Part Number to the appropriate number of SKUs that must be counted when loading furniture from a customer order.
The second module is DEM00 CPN Sales, where orders are imported from a customer without converting to SKU quantities. That is, there is a customer order with the original Customer Part Number and its quantity. I use the Customers and Customer Part Number lists for it.
In the third module DEM01 SKU Sales I would like to show sales in terms of furniture that I produce, i.e. my SKU for a given customer. I have Line Item Quantity and lists of SKUs and Customers. What formula do I need to use to convert the values from DEM00 CPN Sales based on the SYS04 SKU CPN Mapping module for the appropriate SKU and Customer Part Number?
Best Answer
-
Yes, since its a many-to-many relation (Ikea x SKU x customer part) it'd need all those dimensions.
An alternate approach to this is to create a valid combination list & have data across it, but I'd avoid it unless the model shoots up way too much in size.
For the output view, your final line item can then have only the "Konsola" list & the customer "Ikea stockholm" as it'd automatically sum up the values at top level from the prior module & give you the original desired output-
0
Answers
-
Hi @KacperSzafranski13 ,
How are the 2 dimensions linked?
In the module SYS04 SKU are the numbers supposed to sum up to the total in DEM00 CPN where we have 36 for Jan23? If so, is the requirement to get that breakdown in the final module?0 -
36 is the number of the given Customer Part Number that the customer ordered. At this point, I want in DEM01 SKU Sales if I have a customer IKEA-Stockholm and I know that for customer part number TJ87TDG4 this customer ordered this product 36 times, then based on the mapping from SYS04 SKU CPN Mapping, I want to calculate the quantity in DEM01 SKU Sales. So the quantity in DEM01 SKU Sales for the customer IKEA - Stockholm and the SKU, which is the "stół jadalniany", should be:
1 {for the intersection of SKU ("Stół jadalniany") and Customer Part Number (TJ87TDG4) from SYS04 SKU CPN Mapping} * 36 (DEM00 CPN Sales)0 -
@KacperSzafranski13 - So similarly for Konsola it should be 36x3?
If so, create another module / line item with all the 3 dimensions & multiply both the line items.
SYS SKU.QTY * DEM00 # of orders = Final value.0 -
Yes, that's exactly it. After changing the dimension for the module it works, but is this the best way to solve this problem?
It seems to me that we are overwriting a lot of memory, which is probably not the best solution. And to get a view that satisfies us, we have to use a filter, which has to be refreshed every time with changes in other modules, which is annoying.
0