Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

How to Enable Localization Support for SQL Server Analysis Services Dimension Attributes


By:   |   Last Updated: 2016-08-25   |   Comments (1)   |   Related Tips: > Analysis Services Dimensions

Problem

In any SQL Server Analysis Services (SSAS) solution that has global users, one of the common requirements is the localization of data based on users locale. Users prefer to have the visual cues for the understand the data in their local language. In this tip we would understand how to add localization support to dimension attributes.

Solution

SSAS provides a feature called Translations that can be used to add localization support for a dimension.  Let's walk through an example with a sample Customer dimension.

1: Consider we have a cube dimension named Customer with a few attributes as shown below.

SQL Server Analysis Services Dimension Structure

2: Click on Translations tab, right-click and select "New Translation" tab. This should bring up a language selection tab. Select the language of your choice and click OK.

Language Selection in SQL Server Analysis Services

3: After the translation is created, based on the language selected, add the translated caption against the attributes. You can use translators like translate.google.com and find the translation in the target language, and add the same to the translation as shown below.

SQL Server Analysis Services Translations

4: Deploy the cube, and browse the same using SQL Server Management Studio (SSMS). On the top of the browser you should be able to see a Language option, from where the user can select the language of choice. Select the target language as shown below.

Select the Language in SQL Server Management Studio to Translate the Dimension

5: Once the language has been selected, the captions in the translated / localized language would be displayed as shown below. Only the attribute captions would be selected in the localize language. This would help users to identify attributes of a dimension in a localized language.

Translated language displayed for the headings and data
Next Steps
  • There are also translations available at the cube level. Try creating translations at the cube level to add localization support.
  • Learn more about SQL Server Analysis Services:


Last Updated: 2016-08-25


get scripts

next tip button



About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Thursday, August 25, 2016 - 10:34:50 AM - Kris Maly Back To Top

 It is an usful TIP.

 

Thanks for sharing the TIP.

I read it and liked it.

Keep publishing such tips.

Thanks for educating the community and appreciate your volunteership.

 


Learn more about SQL Server tools