Multiple hierarchies for 0ORGUNIT ?

[Former Member]

We currently extract the hierarchy ORGEH from SAP R/3 (HR). A new organizational structure is now being created in R/3 which needs to be extracted in to BW (v3.5). However, with the mixture of users we have, some still want to use the old structure while others want to use the new structure. This poses a few questions:

1) Can you have more than one hierarchy associated with 0ORGUNIT? I assume you can.

2) For any reports that use the old hierarchy but now need the new hierarchy, is it a case of changing the hierarchy in the query or is it more complicated than that?

3) For some existing reports, there is a requirement to report historical data but this would mean using both hierarchies. Is this possible and if so how?

4) Could the change in hierarchy structure mean changes are required to roles & authorisations? How can we identify if changes are needed or not?

Any advice will be welcome.

[ravishanker_cheedepudi · Accepted solution]

1) Yes , You can have more than one hierarchy.

2) It is easy you have to change the hierarchies in a report, even in Local view after running the query ...

3) Both hierarchies in single report is not possible ,but you can switch the hierarchies in Local view for historical data and current data.

4) If you have authorizations at hierarchy node level you might need changes to authorization roles ..

Ravi

[Former Member · Accepted solution]

Thanks Ravi.

Can you expand on your answer to question 3 please?

[Former Member · Accepted solution]

You can't have both hierarchies of a single infoobject displayed on a non structured report at the same time (i.e. in cases where you aren't using a structure and just drilling in 0ORGUNIT).

You can however, setup a variable so that as part of the report parameters, the user selects the hierarchy for viewing meaning they can view the data in the old hierarchy and then click refresh/change variables, select the old hierarchy and compare.

Alternatively, you will need to have a fixed structured report. In such a case, you can have a selection within the report that displays the same KF against each of the hierarchy. In such cases, you are usually only displaying a single node of the hierarchy at a time which is less flexible.

e.g.

HIER1 OTHER CHARS KF1

HIER2 OTHER CHARS KF1