We want to load transaction data into our cost center BPC model. Our model consists of several dimensions, among them COSTCENTER and PROFITCENTER. Additionally we are maintaining profit_center as an attribute of COSTCENTER dimension.
If possible we would like to remove PROFITCENTER dimension from the file and instead look up for PROFITCENTER either in profit_center attribute of COSTCENTER or in the conversion file.
Any idea how we could achieve this? Is it actually viable option?