|
|
You're in the
sql server data warehouse
group:Multilingual Data Warehouse
sql server data warehouse:
Hi all,
I have a small question. Is it possible to create multilingual data warehouses (cubes). I have to create a Data Warehouse for one of customers who has data in couple of countries. They need to query the data according to their culture setting. Atpresent I'm using XMLA for analysis because they need web-base analysis. Please let me know if this can be done and if so, how. Highly appreciate all your reply. Dinesh
I don't understand exactly what you need. Currency?, language?, name
products?. Carlos -- Lic. Carlos E. Ortiz Maldonado INFOTEC [quoted text, click to view] "Dinesh Priyankara" <dinesh@dineshpriyankara.com> wrote in message news:eZt9T6ziEHA.2436@TK2MSFTNGP09.phx.gbl... > Hi all, > > I have a small question. Is it possible to create multilingual data > warehouses (cubes). I have to create a Data Warehouse for one of customers > who has data in couple of countries. They need to query the data according > to their culture setting. Atpresent I'm using XMLA for analysis because they > need web-base analysis. > > Please let me know if this can be done and if so, how. > > Highly appreciate all your reply. > > Dinesh > >
Hi Carlos,
Thanks for reply. Let's say; client has three applications running at Japan (DB maintains with Japanese Language), China (DB maintains with ChineseLanguage), Austrialia DB maintains with English Language). Fist I have to create three DWs to three contries according to their culture setting. (Eg, Japanese Manager needs to see his DW in Japanese Langauge). Then after that I have to create one consolidated DW (with all three countries DBs) that my client can see the entire picture. But again if Japanese Manager wants to see the consolidated DW in Japanese language, How do I do it? Is it possible to create the final DW (consolidated) as multilingual DW? If possible how? If not, any suggestion? Thanks Dinesh [quoted text, click to view] "Carlos Ortiz" <Correofalso@hotmail.com> wrote in message news:#7h7MC7iEHA.2660@TK2MSFTNGP15.phx.gbl... > I don't understand exactly what you need. Currency?, language?, name > products?. > > Carlos > > -- > Lic. Carlos E. Ortiz Maldonado > INFOTEC > > "Dinesh Priyankara" <dinesh@dineshpriyankara.com> wrote in message > news:eZt9T6ziEHA.2436@TK2MSFTNGP09.phx.gbl... > > Hi all, > > > > I have a small question. Is it possible to create multilingual data > > warehouses (cubes). I have to create a Data Warehouse for one of customers > > who has data in couple of countries. They need to query the data according > > to their culture setting. Atpresent I'm using XMLA for analysis because > they > > need web-base analysis. > > > > Please let me know if this can be done and if so, how. > > > > Highly appreciate all your reply. > > > > Dinesh > > > > > >
in AS you can only setup multilanguage at member level.
So the members of a dimension can be displayed in the user language but you cannot setup the cube name, measure name or dimension name in multi language. So you'll have : Product (always displayed in english) |--> Glasses (in english for english users, or in japanese for japanese users) SQL 2005 will support full multilanguage features (cube, dimensions, measures, members...) "Dinesh Priyankara" <dinesh@dineshpriyankara.com> a écrit dans le message de news: uVCp8B9iEHA.1356@TK2MSFTNGP09.phx.gbl... [quoted text, click to view] > Hi Carlos, > > Thanks for reply. > > Let's say; client has three applications running at Japan (DB maintains > with > Japanese Language), China (DB maintains with ChineseLanguage), Austrialia > DB > maintains with English Language). Fist I have to create three DWs to three > contries according to their culture setting. (Eg, Japanese Manager needs > to > see his DW in Japanese Langauge). Then after that I have to create one > consolidated DW (with all three countries DBs) that my client can see the > entire picture. But again if Japanese Manager wants to see the > consolidated > DW in Japanese language, How do I do it? Is it possible to create the > final > DW (consolidated) as multilingual DW? If possible how? If not, any > suggestion? > > Thanks > > Dinesh > "Carlos Ortiz" <Correofalso@hotmail.com> wrote in message > news:#7h7MC7iEHA.2660@TK2MSFTNGP15.phx.gbl... >> I don't understand exactly what you need. Currency?, language?, name >> products?. >> >> Carlos >> >> -- >> Lic. Carlos E. Ortiz Maldonado >> INFOTEC >> >> "Dinesh Priyankara" <dinesh@dineshpriyankara.com> wrote in message >> news:eZt9T6ziEHA.2436@TK2MSFTNGP09.phx.gbl... >> > Hi all, >> > >> > I have a small question. Is it possible to create multilingual data >> > warehouses (cubes). I have to create a Data Warehouse for one of > customers >> > who has data in couple of countries. They need to query the data > according >> > to their culture setting. Atpresent I'm using XMLA for analysis because >> they >> > need web-base analysis. >> > >> > Please let me know if this can be done and if so, how. >> > >> > Highly appreciate all your reply. >> > >> > Dinesh >> > >> > >> >> > >
you can only setup the multilanguage for members only, not level labels.
to do this. your source table must have 1 column for each language : Label_EN; label_JP... use the Label_En column as the member name property of the product level for example. then add Label_JP as a property for the level "product", go in the advanced tab of this property. Choose the type "CAPTION", then choose the language as "JApan" (repeat these 2 tasks for each language you want) now a japanese user will see the product name in japanese instead-of english labels, and if an english uiser send an Excel report connected to the cube to a japanese user, the japanese user see the japanese labels. any user with a language not setup in the dimension will see the default language (english in my sample steps) "Dinesh Priyankara" <dinesh@dineshpriyankara.com> a écrit dans le message de news: OiENNERjEHA.3664@TK2MSFTNGP12.phx.gbl... [quoted text, click to view] > Thanks for the reply. > > Ok, if I can set levels as mutilingual, How do I set? I can't find any > setting for this type of things when creating dimensions. > > Dinesh > > > "Jéjé" <willgart@BBBhotmailAAA.com> wrote in message > news:ekPAjgKjEHA.4032@TK2MSFTNGP09.phx.gbl... >> in AS you can only setup multilanguage at member level. >> So the members of a dimension can be displayed in the user language >> but you cannot setup the cube name, measure name or dimension name in > multi >> language. >> So you'll have : >> >> Product (always displayed in english) >> |--> Glasses (in english for english users, or in japanese for japanese >> users) >> >> SQL 2005 will support full multilanguage features (cube, dimensions, >> measures, members...) >> >> "Dinesh Priyankara" <dinesh@dineshpriyankara.com> a écrit dans le message > de >> news: uVCp8B9iEHA.1356@TK2MSFTNGP09.phx.gbl... >> > Hi Carlos, >> > >> > Thanks for reply. >> > >> > Let's say; client has three applications running at Japan (DB maintains >> > with >> > Japanese Language), China (DB maintains with ChineseLanguage), > Austrialia >> > DB >> > maintains with English Language). Fist I have to create three DWs to > three >> > contries according to their culture setting. (Eg, Japanese Manager >> > needs >> > to >> > see his DW in Japanese Langauge). Then after that I have to create one >> > consolidated DW (with all three countries DBs) that my client can see > the >> > entire picture. But again if Japanese Manager wants to see the >> > consolidated >> > DW in Japanese language, How do I do it? Is it possible to create the >> > final >> > DW (consolidated) as multilingual DW? If possible how? If not, any >> > suggestion? >> > >> > Thanks >> > >> > Dinesh >> > "Carlos Ortiz" <Correofalso@hotmail.com> wrote in message >> > news:#7h7MC7iEHA.2660@TK2MSFTNGP15.phx.gbl... >> >> I don't understand exactly what you need. Currency?, language?, name >> >> products?. >> >> >> >> Carlos >> >> >> >> -- >> >> Lic. Carlos E. Ortiz Maldonado >> >> INFOTEC >> >> >> >> "Dinesh Priyankara" <dinesh@dineshpriyankara.com> wrote in message >> >> news:eZt9T6ziEHA.2436@TK2MSFTNGP09.phx.gbl... >> >> > Hi all, >> >> > >> >> > I have a small question. Is it possible to create multilingual data >> >> > warehouses (cubes). I have to create a Data Warehouse for one of >> > customers >> >> > who has data in couple of countries. They need to query the data >> > according >> >> > to their culture setting. Atpresent I'm using XMLA for analysis > because >> >> they >> >> > need web-base analysis. >> >> > >> >> > Please let me know if this can be done and if so, how. >> >> > >> >> > Highly appreciate all your reply. >> >> > >> >> > Dinesh >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
Thanks for the reply.
Ok, if I can set levels as mutilingual, How do I set? I can't find any setting for this type of things when creating dimensions. Dinesh [quoted text, click to view] "Jéjé" <willgart@BBBhotmailAAA.com> wrote in message news:ekPAjgKjEHA.4032@TK2MSFTNGP09.phx.gbl... > in AS you can only setup multilanguage at member level. > So the members of a dimension can be displayed in the user language > but you cannot setup the cube name, measure name or dimension name in multi > language. > So you'll have : > > Product (always displayed in english) > |--> Glasses (in english for english users, or in japanese for japanese > users) > > SQL 2005 will support full multilanguage features (cube, dimensions, > measures, members...) > > "Dinesh Priyankara" <dinesh@dineshpriyankara.com> a écrit dans le message de > news: uVCp8B9iEHA.1356@TK2MSFTNGP09.phx.gbl... > > Hi Carlos, > > > > Thanks for reply. > > > > Let's say; client has three applications running at Japan (DB maintains > > with > > Japanese Language), China (DB maintains with ChineseLanguage), Austrialia > > DB > > maintains with English Language). Fist I have to create three DWs to three > > contries according to their culture setting. (Eg, Japanese Manager needs > > to > > see his DW in Japanese Langauge). Then after that I have to create one > > consolidated DW (with all three countries DBs) that my client can see the > > entire picture. But again if Japanese Manager wants to see the > > consolidated > > DW in Japanese language, How do I do it? Is it possible to create the > > final > > DW (consolidated) as multilingual DW? If possible how? If not, any > > suggestion? > > > > Thanks > > > > Dinesh > > "Carlos Ortiz" <Correofalso@hotmail.com> wrote in message > > news:#7h7MC7iEHA.2660@TK2MSFTNGP15.phx.gbl... > >> I don't understand exactly what you need. Currency?, language?, name > >> products?. > >> > >> Carlos > >> > >> -- > >> Lic. Carlos E. Ortiz Maldonado > >> INFOTEC > >> > >> "Dinesh Priyankara" <dinesh@dineshpriyankara.com> wrote in message > >> news:eZt9T6ziEHA.2436@TK2MSFTNGP09.phx.gbl... > >> > Hi all, > >> > > >> > I have a small question. Is it possible to create multilingual data > >> > warehouses (cubes). I have to create a Data Warehouse for one of > > customers > >> > who has data in couple of countries. They need to query the data > > according > >> > to their culture setting. Atpresent I'm using XMLA for analysis because > >> they > >> > need web-base analysis. > >> > > >> > Please let me know if this can be done and if so, how. > >> > > >> > Highly appreciate all your reply. > >> > > >> > Dinesh > >> > > >> > > >> > >> > > > > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |