Load data from Hierarchy Infoobject to a regular infoobject with attributes

[Former Member]

We're pulling in a COPA hierarchy from ECC to BI. The hierarchy has the Region -> District -> Territory -> County with county at the lowest level. Now, I have to read this hierarchy infoobject and populate another infoobject ZCOUNTY with attributes District and Territory. I generated a datasource from the hierarchy infoobject but am not sure how to link this to the ZCOUNTY infoobject since there is no option for transformation at this datasource which is an emulated datasource. There is no option to migrate it either. Any ideas?

[Former Member · Accepted solution]

Create a generic datasource in BW against the hierarchy table. You can find the hierarchy table if you go into the characteristic (change), select the hierarchy tab and identify the hierarchy table.... something like /BIC/H<<infoobject name>>.

So, once you find the table name, go into RSO2 and create a datasource off of it.

Brian

[Former Member · Accepted solution]

When I try to create a datasource out of the H table, I get the message:

Database table /BI0/HG_CWW111 is a local object -> long text

Message no. RJ059

Diagnosis

You have chosen a local table as the basis for the DataSource.

This causes problems if the DataSource is defined as a DataSource that can be transported: when it is imported into the target system, the transport is terminated because the missing table causes inconsistency.

But the way, I got around it was to create a DTP from the infoobject and derive the attributes in the start routine by reading the H table. It was a good idea, anyway..