cancel
Showing results for 
Search instead for 
Did you mean: 

could not able to load the data from BODI to SAP BW

Former Member
0 Kudos

Hi Experts,

I have to migrate the data from oracle to SAP BW

Using

Oracle -10g

BODI version - Data Services XI 3.0

BW Veriosn - 7.1 MS

O/S Version - Windows XP

Unfortunately i am not able to migrate the data in the BW tables ,

the data has been loaded to BODI Intermediate Tables from Oracle.

The following checks were successful :

1. Data count and data in source matches data count and data in the BODI intermediate Table.

2. Data Type in oracle are same as for Intermediate as well as for my target tables(In SAP

BW).

3. Data count in Intermediate and Source table are equals to the data count in BW Tables but

i am not able to retrive the data in the same BW tables.

4. Connections and schema are working fine and tested successfully.

5. Its a direct column to column mapping from oracle to BW.

Can someone help me identify the steps i might have missed out in this process , also what

can be the unidentifying issues.

Please help me in resolving this issue.

Thanks in Advance

Srujan.

Edited by: srujan Kumar surampudi on Jun 22, 2010 12:25 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I think there are two steps which you have to do in bw side.

1 create datasouce in tcode rsa1 screen

2 create infosource to receive the the data.

Please using tcode sm59 to confirm whether your logical system for your datasource is work well.

Former Member
0 Kudos

Hi Loucas Lu,

I have already done these steps and checked the logical system connection also .

Right now I'm able to see record count in BW that is extracted from BODI.Only first colum i.e. record is having values remaining all columns contain blank values.

I hv created below structure in BW

ZPFORM - char 25 - master infoobject

ZSNPPFORM - char 25 - attribute of ZPFORM

ZSNPSPPLO - char 25 - attribute of ZPFORM

In BODI I'm using Oracle table "MST_UD_PFORM_SPPLOC_MAP" . all three fields are of VARCHAR(25) datatype in BODI.

Pls help further.

Regards,

Srujan.

Former Member
0 Kudos

Hi Loucas Lu,

I got the solution for the data loading problem from BODI to BW.

This is the code page format in the edit option in bw datastore as it is set to default. I have changed it to utf18.

Then I am able to load the data to BW.

Regards,

Srujan....

Former Member
0 Kudos

congratulation.