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,