Wednesday, August 11, 2010

Excel Multilingual connectivity to SQL Server Analysis Services (SSAS) 2008

-->

1.       Create a new connection
2.     Select the Perspective


3.       Press Finish
4.       Go to Properties à Definition
The connection string should look like a default SSAS connection string with the appended attribute:
Locale Identifier=XXXXX
Where XXXXX is the locale id for the language you set up in SSAS e.g. 14337 is the locale id for Arabic U.A.E

To get a complete listing of all the Locale ID mappings please visit the below URL
http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx
So the connection string would look like the below:
Data Source=ServerName;Initial Catalog=Datamart;Provider=MSOLAP.4;Persist Security Info=True;Integrated Security=SSPI;Locale Identifier=14337;
You should then see the below screen where the red highlighted box has the name of the perspective or Cube you are connecting to.
5.       The next screen will show you the below
 
6.       The results above are also incorrect, as you can see it still displays English names. Go to Data à Properties à Definition
Replace the clause
“;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error”
With
“;Locale Identifier=14337;”
Go to Usage tab and UNCHECK “Retrieve data and errors in the office display language when available”
7.       Press Ok. The below screen will appear showing the Arabic names.


No comments:

Post a Comment