Establish Relationship between two dimensions
I am trying to figure out the mapping that can exists between two dimension that gets exported from the data base.
One dimension is Profit Center and other Customer Code. These two columns appear as every time data is downloaded.
How can i determine the relationship between both? Is it one to one Mapping or One to Many.
i can do this in excel by running pivots and Count ifs but i want to build this in Anaplan.
You can do it in a similar way that you would in excel.
Start with a numbered list which contains the combination of profit center and customer codes, and add a fixed value of one as a record counter:
Fig 1. Profit Center_Customer Code
You can then check for the relationships by Profit Center and/or Customer code by adding lists for Profit Center and Customer Code, and then summing the record counter like the below:
Fig 2. Profit Center Properties - showing multiple customers associated with a Profit Center
So here you would point to the Profit Center_Customer Code.Record Counter and sum on the list formatted Profit Center
Fig 3. Customer Code Properties - showing a customer is only assigned to one Profit Center
Here you would point to the Profit Center_Customer Code.Record Counter and sum on the list formatted Customer Code.0