Data Type Issuee On Reading Data From MSSQL to SAP BW

[former_member242731]

Hi

I'm creating BW info Cube Based on MSSQL table Contain column named "Salary" contain value (10000) , I created DB Connect from Source System which read the Field salary as "Int4" the issuee the "10000" is MSSQL is Readed in the BW as "10.000"

Data In the Source MSSQL Salary 10000

Data in Source system SAP BW 10.000

any help about the issuee ?

[bhavinvyas · Accepted solution]

Try to change the user specific setting for decimal points,

Go to SU3 tcode and change the decimal notation.

Thanks,

Bhavin Vyas