on 10-20-2005 2:18 PM
We are trying to integrate two BW different systems (BW1 and BW2). BW2 currently has some objects and data in it. It has some standard InfoObjects from the BC that have been customized and have data in them.If i do a export datasource from BW1 to BW2, will it overwrite the already existing InfoObjects in BW2.Thanks in advance for all the help and suggestions in this regard.
Mike
Hi Mike,
If the infoobject start with 0 means it's standard one. So you need to activete these from Business content. Don't create new objects. Follow in the same manner how it is customized for BW1 system. If there is any custom defined object that is starts with A-Z, these you need to create in BW2. Keep one thing in your mind if it starts with 0 means it's sap provided.
Create all the BW objects similar to BW1.
If it is clear plz reward points for me.
Nagesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes Bhanu, the 0MATERIAL values in BW1 and BW2 will be different. As the data in BW1 will be used only for historical purposes in BW2, can we create objects in BW2 exact in structure to objects in BW1 but with a different naming convention so that they dont have a conflict. Do let me know.
Thanks and Regards
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nagesh,
What if in BW2 those objects are already being used in their existing InfoCubes. (i mean the standard SAP objects like 0MATERIAL). Will it not create a conflict with the existing objects in BW2? Let me know.
I have already awarded you your well deserved points.
Thanks
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi MIke,
It will not create any conflict with the existing objects, unless you have a situation where like 0MATERIAL in BW1 has 2 extra attributes that are not present in 0MATERIAL in BW2. You need to make a decision about what needs to be done in such a case: Add those attributes, or go without them. Extending the same example, will the material values from BW1 and BW2 be different?
Nagesh,
When i do it manually what do i do when i have to replicate the InfoCubes containing the standard InfoObjects like 0MATERIAL etc? Do i create them as it is or do i have to change their names so that it does not clash with the existing standard InfoObjects in the target system. Thanks for all the info.
Regards
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here is the big picture. BW1 is for company 1 and BW is for company 2. We have to integrate these BW's into BW2 so that we can shut down BW1 with a cutoff date. Now remember that both BW1 and BW2 alredy have data existing in them and we need to get BW1's structures/data in BW2. Going foward there will be only BW2 and the data of BW1 will only be used for historical purposes. I hope i clarified it to some extent. Thanks guys for the patience with me.
Regards
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nagesh,
Thanks for responding. Can you please elaborate on process of creating the objects manually in BW2. Can we create the InfoObjects, InfoCubes, ODS manually and load the data from R/3 (for BW1)? If so what other things should be kept in mind before doing that?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mike,
Can you give us a view of the bigger picture. As I understand, you have a BW1 system and will be setting up a BW2 system. Is the BW2 system to contain all of the objects of the BW1 system...what is the purpose of BW2? This info will help everyone to give better advice as these seemingly little decisions (0MATERIAL or ZMATERIAL) can have a very large impact down the line.
Regards,
Bhanu
Bhanu,
What i meant is this. Lets say if BW1 has 0MATERIAL infoObject. Then i will define a similar InfoObject in BW2 with a change in the name (say ZMATERIAL) and then load the data from R/3 (for BW1) into BW2. Our functional requirement is that the data from BW1 to BW2 will only be used for historical purposes. Please correct me with the above if i am wrong.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bhanu, Is there any documentation on compounding that can help me do it. Also i was thinking if i create the object definitions manually in BW2 as is in BW1 and manually load the data. Will there be any foreseeable problems with that. Please suggest.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mike,
You can take a look at this link:
http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6399e07211d2acb80000e829fbfe/content.htm
Also wanted a bit of clarification: Are the InfoObjects (in question) different in BW1 and BW2, or will they be different. Or are you thinking of the same definitions ?
"if i create the object definitions manually in BW2 as is in BW1 and manually load the data. " ...this confused me.
Bhanu.Thats was quick man..... I want to maintain the data in the existing BW2. Please suggest a way to do that.
Thanks again for the prompt reponse.
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mike,
you need to do manually in the other system. I don't think there is no other way to replicate the metadata of BW data containers. You could get the metadata of Datadources(datamarts), you can't get the metadata of BW objects(Infoobjects, ODS and infocubes)
Let me know ur view?
Nagesh.
Hi Mike,
As per my knowledge, you need check all the settings and technical attributes of all the BW objects manually. I don't think SAP provided any facility to do Remote comparison.
Do one thing, transfer very less records and compare that data with source data? if u find any problem then u could change accordingly. While checking the technical attributes check at the table level i.e. RSDODSO table. at least that will reduce time.
Nagesh.
Hi Mike,
I have given one table for ODS like that we could see different tables for different objects. Execute table with specified object technical name and compare with source. Make sure all update rules, transfer rules and all dependant objects are activated. We have different predefined tables. I have used those tables for Regression testing in my project.
Nagesh.
Hi Mike,
Using an export datasource you can move data from one BW system to the other, but this will not overwrite the definition of the InfoObjects. It may of course change the data values stored in these InfoObjects. Do you want to maintain the data that is currently in the BW2 InfoObjects, or are you just concerned about their definition...
Hope this helps...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.