Extracting Hierarchies from ECC / R3

Hi all,

We have some custom reports now recreated in BI based on versions initially developed in R3.

The R3 reports made extensive use of 'groups' for Cost Center, Cost Element, and Internal Orders, and few if any hierarchies were maintained in R3.

Fortunately, BI7 has built in functionality to ETL user created 'Groups' on these R3 characteristics into hierarchies in BI. However, there are a couple restrictions that we are wondering if there is a way to work around:

1) only Top level nodes in R3 are available for extraction when configuring the InfoPackage - is there a way to select lower level nodes also?

2) only one hierarchy can be loaded per infopackage - is there a way to select and load multiple (or even all) R3 hierarchies at once?

Many thanks for any help you can offer!

Darryl

Edited by: Darryl Goveas on May 5, 2009 2:54 PM