cancel
Showing results for 
Search instead for 
Did you mean: 

BPC transaction data load from flat file - master data lookup

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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

Former Member
0 Kudos

thank you for responding my question that really required the answer.

Not really sure what you mean by:"It's better to ask question that requires an answer".

John

former_member186338
Active Contributor
0 Kudos

You incorrectly created a discussion without:

Vadim

Former Member
0 Kudos

Vadim,

thanks for clarification. I am new to this community.

John