CODEWITHSUNDEEP
translationssasolap
Galiya
Galiya

Reputation: 1

SSAS 2008, Translate Hierarchy members in parent-child hierarchy

I'm creating my dimensions and parent-child hierarchies using AMO objects. One of the requirements is to translate the hierarchy members into another language.

While accessing the newly created cube in the BIDS, I am able to provide translation for the attributes in Dimension Editor, but I'm not sure how do I do the same for the hierarchy. My DimCompany table has a few fields, including CompanyKey, CompanyParent, CompanyName, CompanyRusName. The last one is to be used to translate attributes and hierarchy members.

I have provided a couple of screenshots explaining the existing situation.

Unfortunately, I can't post images, so just a couple of links here:

I'd very grateful for any hints and suggestions!

Regards, Galiya

Upvotes: 0

Views: 1577

Answers (1)

Patrice Calvé
Patrice Calvé

Reputation: 694

I can't see the images. Both links aren't working.

Since your table has both CompanyName and CompanyRusName, you translate your dimension like this:

  • Open the Dimension Editor
  • Click on the Translations Tab
  • Right click on the view and choose New Translation (or Menu Dimension > New Translation
  • Choose the Language
  • The new Language will appear as a column.

Now,

  • Next, for the Attribute you want to translate (in your case, CompanyName would be an attribute, if you don't see the attribute, you have to make it an attribute first), click in the cell and a button with a "." will appear, click on the button and
  • The Attribute Data Translation dialog will appear
  • In this dialog box, you can choose the Translation Caption and the Translation Column
  • In the Translation Column, choose the (in your example) CompanyRusName.

Let me know if this help.

Upvotes: 1

Related Questions