Globalization Support for MSAS 2000

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.