BPC transaction data load from flat file - master data lookup

Dear Experts,

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?

Thanks,

John