Names of months in national language

#1

Hi all,

please, say me, how can I, show names of months in my my national language
(in data cube),

thank you

Lada Dvorak

#2

if you take your month name from sql table, then before loading month names
into table, add "SET LANGUAGE <your language>". Then populate you date table
with month names.
Or, if you create a time dimension and represent month level as DatePart
('m', your_date_column), then add your current language under data source->
right click -> Edit -> All tab -> Current Language and Locale Identifier.
Hope this help.

Ramunas

"Lada Dvorak" <LadaDvorak (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi all,

please, say me, how can I, show names of months in my my national language
(in data cube),

thank you

Lada Dvorak

#3

Yes,

it's working,

thank you

"Ramunas Balukonis" wrote:

Quote:

if you take your month name from sql table, then before loading month names
into table, add "SET LANGUAGE <your language>". Then populate you date table
with month names.
Or, if you create a time dimension and represent month level as DatePart
('m', your_date_column), then add your current language under data source-
right click -> Edit -> All tab -> Current Language and Locale Identifier.
Hope this help.

Ramunas

"Lada Dvorak" <LadaDvorak (AT) discussions (DOT) microsoft.com> wrote in message
news:C6F4A67A-9E38-4BF5-9155-3ECE9F70F5B5 (AT) microsoft (DOT) com...
Hi all,

please, say me, how can I, show names of months in my my national language
(in data cube),

thank you

Lada Dvorak

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Names of months in national language

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Names of months in national language - 05-12-2005 , 11:20 AM

Re: Names of months in national language - 05-16-2005 , 05:01 AM

Re: Names of months in national language - 05-16-2005 , 02:13 PM