Hi,

I have time dimension (like Year, Week) in my cube. Default first day of the
week is set to 7 (select @@DateFirst)
How can I change this value to 1 permanently.

SET DATEFIRST 1 works only for current connection

Best regards
Oleg

The most straightforward is probably to change the language for the login
that you use to connect to SQL Server to one that has Monday as the first
day of the week. You can find which languages use Monday as the first day of
the week in the master.dbo.syslanguages table.

--
Jacco Schalkwijk
SQL Server MVP


"Oleg Boyko" <olb (AT) bigfoot (DOT) com> wrote

Hi Oleg,

I had a similar Problem and found out that
the functions
DatePart and DateName
for the part "week" had different results.
I also wanted "my" weeks to start on mondays,
so I changed the MemberKey-Column-Property for
"week" in my Time-Dimension from "DatePart(...)"
to "DateName(...)" and everything worked fine.
(Make sure that the MemberName-Property uses the same function.)

Does that solve your problem ?