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

1 min read

On the Data tab in Excel: Select 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.
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.

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.

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>

Edit, 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 uses the new Locale setting.

Did you find this information helpful?

Yes

Comments (0)

Please sign in to leave a comment