on 02-10-2016 3:29 PM
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
Hi John,
It is possible to look up profit center from a property or using conversion file.
It will be more dynamic to use the routine to read the property and assign it to the profit center.
unless you have a fixed amount of profit center to cost center link, then you can use conversion file.
just a hint, in your transformation file you still need to map profit center dimension to something, you can't just delete it, once mapped let the conversion file or routine over write those values.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
2 options:
1. you can create a ROUTINE badi with lookup
2. You can load data to some dummy profit_center and then run script that will move data to the correct profit center like PROFITCENTER=COSTCENTER.profit_center
Vadim
P.S. It's better to ask question that requires an answer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.