Follow

How do I change the Locale Identifier in Excel to see other translations?

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.

  1. On the Data tab in Excel: From Other Sources -> From Analysis Services
  2. Enter the server name and click next
  3. Select the OLAP Server database and cube that you want to use, and click Next
  4. 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.
  5. Using Windows explorer, locate the *.odc file in the directory in your clipboard. Open this file in Notepad
  6. 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>
  7. Save and close the connection file.
  8. Open a new WorkBook in Excel
  9. On the Data Tab, click Existing Connections, Locate the edited connection file and click Open. This connection will now use the new Locale Settings.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Deli-ICT Applicatiebeheer

    Apparently this does not function in OLAP 2012 and Excel 2010. When I add ;Locale Identifier=1043 it removes it in the actual connection string in Excel. Any help appreciated

  • 0
    Avatar
    Nestor Jarquin

    One thing I tried, and it worked out of the box, was to create the pivot table (for the cube) by using the Pivot Table and Pivot Chart Wizard. 

    This option is hidden by default in Excel 2010, so you'll have to add it to your ribbon or toolbar.

    Once you create your Pivot Table connection with this wizard the translation will work.

    I tested this on two environments (English and French) after adding the corresponding translation to the SSAS 2012 cube and it works perfectly.

    Give it a try.

Please sign in to leave a comment.