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"
We are able to see data for Special Russian chars but then we are not abale to see specilal turkey characters.
Please let me know if anybody has the answer for this.
Pl also let me know if same thing can be achived using sql server 2005
You can reply me on email :- pankaj.bidwai@uy-tcs.com
Thx and regards
Pankaj
Multilingual Support in Analysis Services
RobinsonT
Look in books-online for the topic:
Multi-language support using member properties.
The net-net is that with AS2K, you can customize the data to return different languages for member names; but not other objects, such as levels, cubes, etc.
In AS2K5, we now support translations which allows you to rename virtually every object name in the system.
_-_-_ Dave
vikesh
Hi dave
Thx for ur reply
Let me explain now.. We have product dimension and we are stroring product names.Ex "Ariel" I think this is nothing but member names
So for each language this product name requires diff set of characters.
Let say we have two OLAPDbs one for Russian data and another for turkey data.
When i set a default charset of server as Russain ,I can see the chars correctely
for the product names in Russian OLAPDB but I can see either or some other
incorrect characters for Turkey OLAPDB. for SQL SERVER 2000 with windows Server
2000.
My objcetive is to see russian and turkey characters correctely on same server.
It would be gr8 if you can send me your email id
Thx and regards
Pankaj
autonomousDE
Hi Dave
I went through the following article
http://msdn.microsoft.com/library/default.asp url=/library/en-us/olapdmad/agmemberprops_8ier.asp
To achieve multilingual support but when i changed the Language of member property from All to any particular language ex.Spanish,I am not able to see that member name/value when the dimension is browsed,Any ideas
Thx and regards
Pankaj
Kyriakos
I am confused and would like to better understand what you are trying to get access to. In Analysis Services, things are divided into either "dimensions" or "facts". Dimensions have text data (member names) and keys (which for the best performance should be integers if at all possible). Fact tables consist of two different parts: foreign keys that point to the grain of the dimensions; and numeric "measures" which represent data that will be aggregated based on the structures in the dimensions. There is no such thing as "text" data in facts. You have text fields in the fact table, but you don't get access to them as facts -- instead you have to create a fact dimension which then has an attribute which is the text fields.
_-_-_ Dave
wwwj
Look in books-online for the topic titled:
"Multiple Language Implementation Using Member Properties"
It shows you exactly how to do this.
_-_-_ Dave
Dennis Chung
Hello
Thx for ur reply but i am interested to see data and not member names.The data is stored in different languages.And we are not able to see the characters correctly for different languages at same time
Thx and regards
Pankaj