Report Portal

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

Read more...

Tags: mdx, customize

 

2007-2015 VidasSoft Systems Inc.