Cost center Hierarchy management : it is better in BW or in SAP R3?

[Former Member]

Hi gurus,

We would like to use the cube "0CCA_C11", and we would like to know what is the better to manage Cost center hierarchy (creation and update in the future) : is it better to managhe it in BW or in SAP R3 ?

Thank you in advance

[Former Member]

Thank you for your help

[Former Member]

Standard Hierarchies should be maintained in R/3 and loaded to BW and this is the practice.

However, if you have any external chars in the cost cenrte hier like for example cost centre manager in the hierarchy, then you can do in BW.

Ravi Thothadri

[Former Member]

What do you mean by manage in BI?

The only time you need to manage the hierarchy in BI, is when you dont have a hierarchy created in R/3. if you have in R/3 and want to mirror the same in BI, it wouldnt make sense, as just loading it daily is much easier to keep both the hierarchies insync is much easy and effortless.

[Former Member]

Hi voodi,

We have not hierarchy yet in R3, we are thinking to set un hierarchy.

For information, we will have a consolidate hierarchy from the local SAP R3 hierachy.

[Former Member]

What is the advantage to manage hierarchy in R3 for you, knowing that we have 3 source systems (SAP R3) ?

[Former Member]

The most important advantage of managing hier in R3 is integrity. The users will see the reports in same hier with R3 so they will trace the costs in same way that they have entered.

Second advantage is you will save time. If you maintain hier also in BW you have to apply the changes also in BW manually.

Sarhan.

[Former Member]

What is the advantage to manage hierarchy in R3 for you, knowing that we have 3 source systems (SAP R3) ?

Adv part has been already dealt with. Now coming to the multiple source systems, the only way to make this work and have all the hierarchies from diff source systems available is to compound ur costcenter to source system. That way all the 3 hierarchies are available on the same IO and can be made available to user in the report - either by hardcoding or having a hierarchy variable.

[Former Member]

Hi Sarhan,

We have not hierarchy yet in R3, we are thinking to set up it.

For information, we will have a consolidate hierarchy from the local SAP R3 hierachy (source system hierarchy that are different between several source system).

[Former Member]

It appears that you are partially answering the question of where/how to maintain "Master Data"?

SAP's answer to the issue is MDM. Take a look at the link:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20c5eb85-f070-2910-6e9f-c8c97cb9...

In my view there is no single answer. The specific solution depends on where your business is and how it's master data needs are going to change?

Good luck, BB

[Former Member]

Hello Pontoise,

If you want to in line with cost center hier in R3 then do not think to maintain it in BW. This will cause some integrity and maintenance problems.

I recommend you maintain it in R3 and load to BW.

Sarhan.