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

Post Reply
Emixam
Posts: 84
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

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

Post by Emixam » Thu Nov 19, 2020 2:51 pm

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 !
Sorry for my English :)

User avatar
Steve Rowe
Site Admin
Posts: 2111
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe » Thu Nov 19, 2020 3:04 pm

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.
Technical Director
www.infocat.co.uk

Emixam
Posts: 84
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

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

Post by Emixam » Thu Nov 19, 2020 3:22 pm

Thanks for your answer Steve, I'll have a look at the DatasourceASCIIThousandSeparator.
Steve Rowe wrote:
Thu Nov 19, 2020 3:04 pm
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.
Sorry for my English :)

User avatar
Steve Rowe
Site Admin
Posts: 2111
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe » Thu Nov 19, 2020 4:01 pm

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.
Technical Director
www.infocat.co.uk

Post Reply