Numeric Values Getting Rounded Off - SAP HANA

[muhammedraleen]

Hi everyone,

Please help me to solve the below issue as soon as possible.

When extracting Data from SAP HANA to QVD, all the numeric values are getting rounded off.

Ex:- SAP figure 101.65   was rounded off  as 102 while loading

Qlik Sense Business  Qlik SAP Connectors 

[marcus_sommer]

At first make an inquiry if the values have really changed because the displayed values might be just formatted and didn't show the decimals.

If the values are really missing their decimals it couldn't come from a normal Qlik loading. Therefore the driver / connector might be involved in any way, for example if this field isn't treated as float else as an integer.

- Marcus

[muhammedraleen]

Thanks for the information.

But we face this issue not only one table, in across all the tables.

Is there anything we can do in the configurations ?

[marcus_sommer]

I don't have own experiences with connecting Qlik to SAP and therefore I couldn't give precise hints to what might be wrong. Within the following posting is an older manual for the SAP connectors which seems not to include SAP HANA (probably there are also newer versions) but I could imagine that the most approaches and settings differentiate very much to the other connectors and should be therefore a good starting point for further inquiries:

Solved: SAP Connector manual - Qlik Community - 554307

 - Marcus

[muhammedraleen]

Really thank you very much for the above information you have mentioned.

I'll go through the connector manual and thanks for sharing it.

-Muhammad

[muhammedraleen]

The below attachment is the reply we got from SAP Team for the above issue.

Can anyone help on this issue at your earliest convenience ?

-Muhammed

[muhammedraleen · Accepted solution]

The above issue was solved by re configuring the connection issue. The connector did not the support the Hana version.

Thank you everyone for your support

-Muhammed