Skip to content
March 31, 2011 / Erik Svensen

Let your pivottable speak spanish

After using the feature in SQL Server Analysis Services to translate the captions of different attributes…

I still saw the English names in my Excel 2010 pivot table field list.

So I tried to change the regional settings in the control panel, my location, my dateformat and also the default language in Microsoft Office … without any luck L

Finally found the solution … I simply changed the connection string to the cube and specified an Extended property in the connection string to the OLAP Cube..

And voila after a refresh… the pivot table field list now retrieves the Spanish translation…

You can find a list of locale identifiers here…. http://msdn.microsoft.com/en-us/library/0h88fahh.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: