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.