on 09-22-2005 6: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,
Sri.
Hi Roberteo,
Thanks for your valuable replies.
Based on your answers:
1.You can enhance a hierarchy standard structure without effecting the others one because in your userexit (dedicated to hierarchies enhancements), thanks to a CASE statement, the code will be effective only for your specific datasource !
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 with OLTPDATASOURCE field(internally it is having one / two/ three filelds i.e depends on application hier)
Shall I go case A or B?
<b>
Case A:</b>
1) SE11->ROHIEROS(STRUCTURE) -->Click on APPEND STRUCTURE --> add fields.
But there it is showing OLTPDATASOURCE(intenally having one filed i.e orgunit, one level). Shall I add person, position fields under that? .
2) Save & activate this structure
3) I am confused how this changed structure is coded in hier fumnction module (EXIT_SAPLRSAP_004). means what code shall i write? I think we need not go in RSO2.
4) replicate this datasource and other things.
<b>
CaseB</b>
Is there any possibility to Create a custom object by copying from standard structure and add fields? how we maintain in "rso2". There is no option for hierrachy datasource.
Please is tell steps.
Basis team didt allow to me to change this structure (Case A)
Please help me.
Regards,
Sri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi dear!
1.You can enhance a hierarchy standard structure without effecting the others one because in your userexit (dedicated to hierarchies enhancements), thanks to a CASE statement, the code will be effective only for your specific datasource !
2.This is not necessary...new data will "overwrite" (in the presentation of your data) all the old content...no attribute and text involvement, anyway!
3.
hope it helps!
Bye,
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all
Issue is urgent pls help me.
pls clarify my Q1,Q2,Q3.
thnks in advance
sri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.