cancel
Showing results for 
Search instead for 
Did you mean: 

Data in PSA getting rounded

Former Member
0 Kudos
74

Hi Gurus,

While loading data from SQL database, data in PSA getting rounded off.

e.g if the quantity is 15.273 in source ,the value in PSA is 15.000.

if it is 20.986 ,in PSA it is 21.000.

Can anybody help on this why this is happening.

Regards,

Sunita

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member188080
Active Contributor
0 Kudos

also check decimal setting in keyfigure..

ofcourse as mentioned above type is imporatnt..DEC is the correct type for KF..

But check the complete flow and mapping at each and every step and see whether mapping is correct and type definition is correct..

Thanks and regards

Kiran

Former Member
0 Kudos

Hi Sunita,

The PSA structure is copied from the definition of the data source. Please check the Field Definition of the field holding the value in the datasource . I think its set as a NUMC or INT so it can not hold decimal values. Change the Field definition to a type which can hold decimal points to you should be ok

Hope it helps.

Regards

Chandra Malavalli

Former Member
0 Kudos

Dear Chandra,

I checked in the source system and the field is maintained as Decimal.

Regards,

Sunita

Former Member
0 Kudos

Hi Sunita,

it will be decimal in the source system since it is holding decimal values, however in the datasource within BW, if the Field is defined as NUMC or INT, it will truncate all decimal values and round it up or down. You need to check the datasource strucutre in BW.

Regards

Chandra Malavalli