Information Design Tool number format

[former_member578292]

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?

[former_member578292]

The data type of the columns is preserved as a FLOAT. This changes neither in the Data foundation nor in the business Layer. For example, it is written 1.6 in the data base but in the Data foundation and in the business Layer this value is shown as 15999999046325684. The decimal separator was removed and the value was changed.

[sonet_kebede]

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