Data in PSA getting rounded

[Former Member]

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

[former_member188080]

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]

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]

Dear Chandra,

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

Regards,

Sunita

[Former Member]

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