Create Forecast Model in Anaplan - Customer and SKU by different Unit
I got some question about how to create a forecasting model in Anaplan by Customer and SKU level in different organization.
For example, I have 3 units (A , B , C) and they are selling to different customers and items.
How can I setup the relationship that if I select A and it only show customer 1 forecast item ABC and customer 2 forecast items BCD. No duplication cross the unit, customer and items.
I tried to pick up the Organization + Customer + Item dimension in a new model but the data is keep repeating even the customer not exist in that organization / the item not exist in that customer ...
I have attached a chart for better understanding. Since I got over 5,000 customer and 10,000SKU, it created a workspace issue to me as well if the data keep repeating. I am thinking I missed out some Parent relationship in between but doesn't got a clear idea how to proceed.
Thanks, it seem more close to the end. I have created those things as you mentioned. However, those all three filter checkboxes seem not work in conjunction.
When I click Australia and refresh the table, the table can show only Australia data in the right hand side. When I click the Customer table like Singapore Customer, the data table still showing Australia. Is it some step is missing / wrong from my side ?
Also, how can we filter the customer filter when we select the Unit. Like we select Australia and the Customer and Item may only show the related combination.