Skip to Content

Information Design Tool number format

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 02 at 01:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded