Skip to Content
0

Information Design Tool number format

May 02 at 08:04 AM

28

avatar image

I have a problem with the information design tool and concerns the representation of the number format as well as the removing by decimal separator.

The Information Design Tool uses a MS SQL server 2014 with an ODBC connection. All database columns own the data type "FLOAT". In the relational connection the column values are correctly shown (decimal separator is a comma). However, all decimal separators are removed from the data basis and therefore the numerical values are shown wrong. How is able prevented that the decimal separators are removed?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

netsanet kebede
May 02 at 01:19 PM
0

Hello,

BO does not write on the database. I'm not sure what you mean by removed from the database.

Normally, FLOAT data types from database are mapped to FLOAT in the Data Foundation and Numeric in the Business Layer.

Please give us more information on what data type you see for each column from Data Foundation and Business Layer.

Thanks,

Sonet

Share
10 |10000 characters needed characters left characters exceeded