hierachy changes

26 Views

Hello all,

With reference to profit centre hierarchy, currently, we are loading a hierarchy called PROFCENTRE_HIER into SAP BW production which is used in all the queries.

However, in SAP R/3 this is not the standard hierarchy. It's just created as a profit center group.

Out standard hierarchy is called COMPANY_HIER.

However, we want to maintain the standard hierarchy rather than a profit center group.

So the idea was to change COMPANY_HIER completely in SAP R/3 production. We want to (probably it's not that simple, but just to make it easier to explain) move the whole PROFITCENTRE_HIER( SAP BW) with all sub-nodes under COMPANY_HIER.

That means the hierarchy looks like that:

COMPANY_HIER

- PROFITCENTRE_HIER

- node 1 - tier 3

- node A - tier 4

- node 2 - tier 3

- node B - tier 4

.....

Then we think that all changes we do to COMPANY_HIER will also be done under PROFITCENTRE_HIER(cause it's sitting unter COMPANY_HIER). When can then keep on loading PROFITCENTRE_HIER into BW and always have the latest version in BW but don't need to change all the queries to use the COMPANY_HIER.

Would this approach work - please let me know of any issue/considerations I would need to keep in mind? Also please confirm the steps so i dont miss anything out.

thanks in advance

richa