Some SSAS databases setup to support various Translations in addition to the default language. These translations are partly embedded in the database (Captions), but they can also be acquired from the underlying SQL database during processing (dimension member aliases etc.).
A particular language can be activated by inserting a specific Locale Identfier in the Connection String used to connect to SSAS.
Example:
Provider=MSOLAP;Persist Security Info=True;Data Source=cxo-sql2016-01\v2019;Initial Catalog=hfm;User Id=;Password=;Client Cache Size=25;Auto Synch Period=10000;Locale Identifier=1033
1033 is the Locale Identifier Id for English (United States).
With this task, we will:
Enable the selection of an alternative Language for connecting to an SSAS database. This selection is on the level of the CXO Source System:
The checkbox ‘Use Default Language’ can be checked if no alternative langage will be selected. This will gray-out (disable) the Language selector. By default the box will be checked.
The Languages in the selectot correspond to an integer number whic represents the Locale Identifier Id (LCID).
Use the selected Language to extend the Connection String to SSAS implied by the settings of the Source System. If a language is selected for which no Translations exist in the SSAS database then automatically the Default Language is used.