Org Unit Hierarchy extraction

[#1]

Hello,

I have newly joined a project and ave a requirement where customer wants to display a report on Org Unit which displays the hierarchy.

I checked teh Hierarchy maintainence and extraction.On Infoobject Maintain Hierarchy is defined and 0ORGUNIT_HR01_HIER extractor(Bw3.5 version) is used though we are in BI7.0.I could see the datasource vesion shows as Modified.But the infopack runs everyday.Th monitor shows everyday 5 records are extracted.But I could not see any hierarchy structure maintained.When I click on Hierarchies All I could see is root node ,no nodes are maintained.

I am new to hierarchies, I know to create hierachies using flat file,But no idea on Hierarchies from ECC.Please help on how to setup the org unit structure in BW.

Regards,

Haritha

[Former Member]

Note that 0ORGUNIT_HR01_HIER uses evaluation path ORGEH, check with the R3 guys what the evaluation path is, maybe they went for a non standard one.

In that case you'll have to create a custom flow or try (as I'm doing for a requirement to extract hierarchies with a different evaluation path) datasource 0DF_IS_DFS_24 which is for defence forces but actually extracts orgunit hierarchies witht the ability to define yourself the evaluation path (see note 871802).

It's not very much orthodox but I think it's the only way to extract hierarchies with an evaluation path different from ORGEH without coding (and customers should not be left on their own on this as it's a pretty normal requirement ...).

[Former Member]

I checked with ECC team and they confirmed that they used only Standard evaluation path.

Not getting any clue..

Suggestions are highly helpful..

Thank you,

Haritha

[Former Member]

Hi Haritha,

Can you please paste screen for monitor, remove content which you can't share. It will help us to understand what is happening.

Regards,

Ganesh

[Former Member]

This is what the monitor shows and when I go in to the hierarchies I would get only the root node.

Regards,

Haritha

[Former Member]

Thanks Haritha,

Can you check InfoSource Name and Hierarchy Name if it is correct in monitor.

Also check on thing in InfoSource >Transfer Structure name of a InfoObject.

Regards,

Ganesh

[Former Member]

Hello P M,

thank you for your hint with datasource 0DF_IS_DFS_24 and SAP note 871802. This really helped us and now we can extract any OM hierarchy we like.

Lorenz