Excel does not use windows locale settings when retrieving translations from an OLAP server, but it uses the installation language for Office. This can be overridden on a single connection by specifically setting the locale identifier, but it can be difficult to do this without overwriting the connection file immediately. This document describes how to do that.
This requires the user to define Translations on the OLAP Server in timeXtender.
- On the Data tab in Excel: From Other Sources -> From Analysis Services
- Enter the server name and click next
- Select the OLAP Server database and cube that you want to use, and click Next
- At File Name, click Browse... -> Copy the path from the address bar, for example 'C:\Users\[username]\Documents\My Data Sources'. Click Save. Click Finish and OK.
- Using Windows explorer, locate the *.odc file in the directory in your clipboard. Open this file in Notepad
- In the end of the <odc:ConnectionString> node enter ;Locale Identifier=[code] (find the code in the Microsoft Knowledge Base)
This should now look something like this:
<odc:ConnectionString>Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Data Source=.;Initial Catalog=OLAP;Locale Identifier=1033</odc:ConnectionString>
- Save and close the connection file.
- Open a new WorkBook in Excel
- On the Data Tab, click Existing Connections, Locate the edited connection file and click Open. This connection will now use the new Locale Settings.