decimals

Options
Sébastien Breyne
Sébastien Breyne Customer
First Anniversary Advocate First Comment
in Platform

Hello, 

 

I am loading a CSV file (utf-8) with 2 decimals to fill a cube. On the reader and its ETL, the decimals appear properly but once the load is done they don't appear in the cube. In this example, the cube contains the value 2602,00. 

 

image

In my other CSV files, I see that the decimals are separated by a dot instead of a comma. I have tried to modify the separator in my excel options to have a dot instead of a comma but then the load doesn't work properly and the cube remains empty. 

 

Thank you for your help. 

Tagged:

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    First Anniversary Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights Name Dropper
    Options

    Dear Sébastien Breyne,

     

    your Cube is defined to which type? Is it possible that you are using Integer?

     

    For that reason please use Single or Double (https://help.board.com/Chapter_6_-_Database_Design_and_Management_files/Infocubes/Numeric_data_types.htm)

     

    Otherwise you also can try to multiply your figures by 100 to see if the figures are loaded for that case

     

    hope it helps

     

    regards

     

    Alexander Kappes

  • Sébastien Breyne
    Sébastien Breyne Customer
    First Anniversary Advocate First Comment
    edited March 2020
    Options

    Dear Alexander, 

     

    Thank you for your help. I finally figured out a way to have it running properly. Here are the answers to your questions and the solution I used.

     

    My cube is a double (I have tested the data reader when changing it into a single and currency with same result). 

    I also tested tried to multiply the amount by 100 in the ETL but the amount recorded in the cube still doesn't take the numbers after the comma in its calculation. 

    2602,84*100 becomes 260200.00

     

    The solution I found: 

    1. In Excel, File>Options>Advanced. Change the Decimal separator to . and Thousands to ,

    image

    When saving the excel into csv. It changes the csv separator to "," (was previously ";"). 

    2. Modify the csv separator in the datareader. (setp I was missing previously I guess)

     

    This might not be the best way to do it but it works. 

     

    Thanks again,

    Sébastien

Categories