Decimal mismatch from Flatfiles to BI

[ramesh_duraisamy]

Hi Gurus,

While loading data from flat file (.CSV) to BI following data mismatch occurs,

1. We represent the data 37.5, but in PSA its displaying as 375.

2. The settings are correct and when we run in our colleague User ID it runs good, but if we run in our ID its has the above mismatch.

Appreciate your help on this?!

Thanks and Regards,

Ramesh D

[Former Member · Accepted solution]

Hi Ramesh,

May be whatever you did for point 1 will help you to correct your issue, can you tell what u did to fix first issue.

Regards,

Ganesh

[ramesh_duraisamy · Accepted solution]

Hi Ganesh,

The decimal part is working for particular user id and for most of user id there is decimal mismatch?!  It's concern to any settings?!

[Former Member · Accepted solution]

Hi Ramesh,

So this is User related settings, you can check decimal places settings in SU01D for user ID which is working and which is not working. check settings like decimal notation.

Regards,

Ganesh

[ramesh_duraisamy]

Hi Ganesh,

Thanks for the reply, but where to check the settings decimal notation?! in Roles/Profiles/parameters?!

[ramesh_duraisamy]

Thanks Ganesh, I got it.

[Former Member]

Hi Ramesh,

Is issue is solved? May be you can share so that will avoid future discussions.

Regards,

Ganesh

[Former Member]

Hi Ganesh,

This is working as we have changed the decimal notations for the specific user id. Thanks for the input.

Thanks and Regards,

Ramesh D