Issue in updating profitcenter from Datasource to cube

[Former Member]

Our req is whenever new profit center or cost center is added in R/3, it should be reflected in BW side.

In our R/3 system, while creating cost center, it is mandatory to assign profit center but while creating profit center it is not mandatory to assign cost center.

In our cube, we have master data IO cost center and profit center is its nav attr.

So whenever a new cost center is added in R/3, after loading the cost center master data in BW, we will get both cost center and profit center.

But suppose a new profit center is added, it wont be reflected in cost center master data because for creating profit center, assigning cost center is not mandatory.

We cannot use master data profit center because it is not present in our cube.

How to proceed in this case?

[RamanKorrapati · Accepted solution]

Hi Arun,

Guessing, there must be a cost center for that profit center, if you source have the cost center, then at transformations you can use master data look up with profit center.

regards

[Former Member · Accepted solution]

Dear KR,

In our case u can have a profit center without a costcenter, but while creating costcenter it is mandatory to assign profitcenter... and the issue is that in 0profit_cntr master data there is no Costcenter as attribute...  to lookup.

BR,

Arun

[oliver_uy2 · Accepted solution]

Hi Arun:

does the business logic of 1 profit center to multiple cost center exist? i think you need to check with the business first why it is not required to put cost center when creating a profit center.

also, i think if a new profit center is created with the corresponding cost center, the cost center masterdata will be updated also once you push the cost center masterdata.

[TammyPowlas]

This is the top level BI space, not BW.

Your question is related to BW

Please post this question in the BW space in the future.

I will try to move this thread

Tammy (Moderator)