Analysis Services Translations in Performance Point Services (SharePoint 2010)
Last week I had to build some PPS Dashboards in an existing SharePoint 2010 environment.
One of the requirements for the dashboards was to support English, Dutch and French. Because the data was loaded from an Analysis Services Cube, I added the extra required translations to the Analysis Services Project: Dutch-Belgium and French-Belgium.
The SharePoint site was already configured to support the 3 display languages:
The Analysis Services Translations were working correctly in every other environment but for some strange reason not in the PPS Components (Analytic Grids, Charts, …)
A very smart guy at Microsoft (Thanks, Wesley ) gave me the tip to use the profiler to have a look at the MDX that PPS sends back to Analysis Services. In the details of the “Query Begin” event I found this MDX:
Okay, it looks like PPS sends the requested locale identifier to Analysis Services. But 1036 is the language code for France and I am in Belgium:
- French – France: 1036
- French – Belgium: 2060
- (More language codes: http://msdn.microsoft.com/en-us/goglobal/bb964664)
But why is Performance Point using the wrong language code? The answer is actually very simple: Because of the installed language packs for SharePoint.
When you have a look at the available language packs for SharePoint (http://technet.microsoft.com/en-us/library/ff463597.aspx), you will see that there is only 1 French language pack, with language ID 1036.
So I solved the problem by adding yet another translation to the Analysis Services Project: French-France.
Enjoy the translations!