Hi
Currentely i am using analysis Services with SQL SERVER 2000
OS:- Windows 2000 Server
Datasource:-Oracle
We need to show the data in the cubes for multiple countries.
But we are not able to show the data for diferent languges at the same time becoz
in windows 2000 default language on the server can be set to only one language
and the data in the cube can be shown in same language
Ex Let say we wud liket see the data in the cube for Russia and turkey on the same server.If we set the default language of the server as "Rusia" or "Cyrlic"
Then we are able to see data for Special Russian chars but then we are not able to see special turkey characters.
Please let me know if anybody has the answer for this.
Pl also let me know if same thing can be achieved using sql server 2005
You can reply me on email :- pankaj.bidwai@.uy-tcs.com
Thx and regards
Pankaj
Analysis Services 2000 allows you to serve up different translations from the same server, however they will all use the same coallation (used for sorting and comparison) which is I think the issue you are dealing with. The ability to display characters is detemined by the characterset of the client application.
In Analysis Services 2005, you can set the coalation for each translation of members.
