Member Caption Translations in MDX
Analysis Services 2005 has strong support for translations. Most of the translation support is about metadata translations, i.e. names of cubes, hierarchies, measures etc. But there is also a way to specify translations for the attribute members. For example, Adventure Works database has French and Spanish translations for Category and Product attributes in the Product dimension. What is the best way to retrieve these localized captions through MDX ? The standard way to do so is through the use of LocaleIdentifier session property. I.e., if we will connect with LocaleIdentifier=3082 (Spanish), and issue the following query