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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Platform: ASP.NET Web Forms |
Control: PivotGauge |
Published Date: May 5, 2015 |
Last Revised Date: May 5, 2015
  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 find “Locale 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.

 
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon