We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to change the language of OLAP Cube connected in Excel?

  1. On the Data tab in Excel: Select 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. In the File Name, click Browse... -> Copy the path from the address bar, for example 'C:\Users\[username]\Documents\My Data Sources'. Click Save, Finish and OK.

 

 

  1. By using Windows Explorer, open the path copied from the address bar (as pointed in step 4) and locate the *.odc file in the directory. Then open this file in Notepad.

 

 

  1. At the end of the <odc:ConnectionString> node, you can findLocale Identifier=[code] 

<odc:ConnectionString>Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Data Source=.;Initial Catalog=OLAP;Locale Identifier=1033</odc:ConnectionString>

 

  1. Edit, save and close the connection file.
  2. Open a new WorkBook in Excel.
  3. On the Data tab, click Existing Connections, locate the edited connection file and click Open. This connection uses the new Locale setting.

 

Article ID: Published Date: Last Revised Date: Platform: Control:
4749 05/05/2015 05/05/2015 ASP.NET Web Forms PivotClient
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.