Changing the OLAP Locale Identifier in Excel to See Other Language Translations
Overview
This article details the process of enabling translations from an OLAP server.
Note: Excel does not use Windows locale settings when retrieving translations from an OLAP server, but instead uses the installation language for Office. This can be overridden on a single connection by specifically setting the locale identifier.
Translations only work when connecting to a cube using the native Excel functionality. This means translations will not work when using the Jet Excel add-in.
Process
-
On the DATA tab in Excel click 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 the File Name, click Browse... → Copy the path from the address bar, for example 'C:\Users\Username\Documents\My Data Sources'. Click SaveClick 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> tag enter ;LocaleIdentifier=code
Note: There should be no space within the LocaleIdentifier tag
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.
For a full list of Locales, see LCID_Strings.pdf.