Skip to Content
Former Member
Sep 22, 2005 at 05:08 AM



Hi All,

ORGUNIT is having datasource 0ORGUNIT_HR01_HIER , having one field. in BW I generated reports on this hierarchy structure, working fine for one level.

I want to add two more fields(two more levels) to this r/3datasorse.This master data is using in several cubes.

For all DataSources 0ORGUNIT_HR01_HIER, 0COSTCENTER_0101_HIER, 0PROFIT_CTR_0106_HIER, 0MATERIAL_LPRH_HIER and 0PROFIT_CTR_0106_HIER are using Extract structure is ROHIEROS,

Problem is if I enhance(rsa6) 0Orgunit, I think it effects and disturbs all others.

Q1.Howmany ways are there to enhance this standard structure without effecting others

in BW2.X version?

Q2. Before doing enhancement this hierarchy data source, . Shall I remove data in cubes

and master table 0rgunit(Attr, Text, one level Hier data??)

Q3. Shall i pickup all 3 levels data from r/3 put it in a flat file, from flatfile i will extract data? Is it possible? if possible pls tell steps.

Please advise me.

Thanks & Regards,