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.