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:

image

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 Knipogende emoticon) 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:

<PropertyList xmlns=”urn:schemas-microsoft-com:xml-analysis”>
<DbpropMsmdMDXCompatibility>2</DbpropMsmdMDXCompatibility>
<Catalog>Titanium</Catalog>
<LocaleIdentifier>1036</LocaleIdentifier>
<Format>Multidimensional</Format>
<AxisFormat>TupleFormat</AxisFormat>
<Content>SchemaData</Content>
<Timeout>300</Timeout>
</PropertyList>

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:

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!

Share
  1. Jul 27th, 2011 at 15:43 | #1

    We have not yet built our single-language SSAS/PPS BI solution, but I’m looking ahead to see what would be involved if we eventually decide we need to localize into other languages. I’ve seen the Translations feature in SSAS and your blog post demonstrates that you should be able to get PPS to send the correct LocaleIdentifier to SSAS so that you get measure and member names to display in a specific language.
    One thing I’m curious about is how one would go about localizing the strings entered into the PerformancePoint Designer like the Title property for a PPS report web part. Are you doing anything like this with your dashboard pages so that a single dashboard can get localized into all supported languages?

  2. Sanjeev
    Jul 6th, 2012 at 19:27 | #2

    Thank you for this! I was having the same problem.

    I do have another question related to translation….

    How does one translate the titles for the Analytical Charts or Analytical Grids? This title is entered into the PPS Dashboard Designer tool but I haven’t found a way to make it language dependent.

  3. Jul 10th, 2012 at 13:46 | #3

    It does not seem to be supported (checked it with Microsoft).
    However some objects in sharepoint can be translated by swithing to that language and changing the title in the webpart editor.
    But I never tried this for PPS webparts. Let me know it it works ;)

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>