Hello Dojo,
I have a scheduler task to send out an email of a Dashboard report with the CSV option enabled. There are values in the table that have values greater than 1000. Those values, when viewed in Excel, are being interpreted as decimal values, so 12,345 is showing up as 12 because the decimal part is being removed.
So is there a configuration that can be done to remove the comma from the CSV export?
Simon Mestdagh [SLC] [DevOps Advocate] Answered question 25th November 2024
Hi Gabriel,
This depends on the locale settings of your system and office package. In the Regional tab of the dataminer cube settings, you can change the "CSV separator to match the Regional settings of your system. By default, this is "Windows Culture", but you can explicitly change it to comma, semicolon, or tab. 
Gabriel Borges [SLC] [DevOps Advocate] Posted new comment 13th November 2024
Hello Michiel, the issue is not the delimiter, it is using the semicolon separator and the CSV is being parsed correctly when it comes to the columns. The issue is one of the columns has a comma in it to show more than 1000 I.E. 12,345 instead of 12.345 or 12 345. This is causing excel to think 12,345 is a decimal and only showing 12.