Problem with start of the week (DATEFIRST)

#1

Hi,

When we view data within a specific cube, it has the start of each week set
to a Sunday. When we look at another cube (built from the same SQL 2005
database), it has Monday as the start of it's weeks. Is this possible? I
thought the DATEFIRST option was specific to a user's login, but somehow the
same login in this case is getting different results from two different cubes.

The cube is based on a view, and so we can't use SET statements to set the
DATEFIRST option at that stage. Is there some other way to standardise this
across all cubes for all users? The default language is US English, and all
users/logins use the default language (ie. none have been changed).

Dave

#2

DavidCur wrote:

Quote:

Hi,

When we view data within a specific cube, it has the start of each week set
to a Sunday. When we look at another cube (built from the same SQL 2005
database), it has Monday as the start of it's weeks. Is this possible? I
thought the DATEFIRST option was specific to a user's login, but somehow the
same login in this case is getting different results from two different cubes.

The cube is based on a view, and so we can't use SET statements to set the
DATEFIRST option at that stage. Is there some other way to standardise this
across all cubes for all users? The default language is US English, and all
users/logins use the default language (ie. none have been changed).

Dave

In your dimension property go to source , go to firstdayofweek property
and set frist day of week

Regards
Amish Shah

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

Problem with start of the week (DATEFIRST)

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

Problem with start of the week (DATEFIRST) - 09-04-2006 , 11:15 PM

Re: Problem with start of the week (DATEFIRST) - 09-05-2006 , 04:52 AM