How can I make sure exported data are using the same decimal separator [English vs French]

[Emixam]

Hello everyone

I have a client with offices all around the world. A user is in France and everything is in French (OS, Microsoft Excel, Architect, ..) so when he opens a cube view, the numerical values are display using a comma as decimal separator (0,95 instead of 0.95). That same user needs to run a bunch of TI to export data to CSV as well as ODBCOutput. As you can imagine, it causes a lot of issues because of the format.

I changed the language in the tm1p.ini (%ProgramData%\Applix\TM1\) so now Architect is in English, but the numerical values that are displayed in a cube view are still in "French". I changed my Architect to French, but the numerical values still appear in "English"..

How can I make sure that the values exported in CSV or into an ODBC data source are in English ? My only solution right now is to ask the IT department to change the OS in English, but I'm sure there is a better solution.

Thanks and have a good day !

[Steve Rowe]

If you are using TI then have a look at the TM1 Local variables such as DatasourceASCIIThousandSeparator, if you set this you can fix the output.

Where are you running the export from though? If you are running it client side then I think that's going to be more of a challenge.

[Emixam]

Thanks for your answer Steve, I'll have a look at the DatasourceASCIIThousandSeparator.

Where are you running the export from though?

They are using PA on prem so the client is running the export either from Architect/Perspective or TM1Web. TM1 Server is on a VM and everything is in English.

[Steve Rowe]

To clarify there are some ways to directly produce an ascii file from the client itself.

From what you say the users are running a TI and so you should be able to configure the output as you please.