cancel
Showing results for 
Search instead for 
Did you mean: 

Export DataSource question

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (9)

Answers (9)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member188975
Active Contributor
0 Kudos

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?

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Mike,

You need to do manually. I will chck it out if SAP is provided any other functionality or not.

Nagesh.

Former Member
0 Kudos

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

former_member188975
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

former_member188975
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

former_member188975
Active Contributor
0 Kudos

Hi Mike,

One option is to use compounding with the sourcesystem. This way you will know the data values that come in from each source system (including your BW1) system, and the values from different source systems will not overwrite each other.

Hope this helps...

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

former_member188975
Active Contributor
0 Kudos

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...