Monday, July 27, 2015

How to enable SSAS cube translations in excel



Using Locale Identifier connection string  Property we can enable cube translations in EXCEL.
Change the connectin string using properties tab or in ODC file.
Some times properties tab not working properly. So prefer ODC file.
Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Localhost;Data Source=SSAS;MDX ; Lcale Identifier=1033

By defauly we have one default translation in English(United States ) language.

Please follow the below link for different locale id's.
https://msdn.microsoft.com/en-us/library/ms912047%28v=WinEmbedded.10%29.aspx

Delete translations from SSAS cube


We can specify translations at dimesion lever or cube level.
To delete existing trnslation just right click on translation at TRANSLATIONS tab and select delete option.
We need to drop it from each dimension and cube in the database.

No comments:

Post a Comment