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.
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.