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