Putting days of the week in order

#1

I have a cube with a dimension DayOfWeek, which has values like
"Monday" or "Tuesday". I'd like to put these in Sunday through Saturday
order when somone views the data in a pivot table. It's SQL Server 2000
Analysis Services. How can I do this?

Thanks!

Jim

#2

The easiest way to do this is to have your DoW Dimension table look
something like this:

DoWID DayName

1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday

Then when you create the dimension off of the table, set the "Order By"
property to Key instead of Name. That will order the dimension how you
like it.

HTH

V

#3

Voorshwa,

Thanks! This was just what I was looking for.

Jim

Voorshwa wrote:

Quote:

The easiest way to do this is to have your DoW Dimension table look
something like this:

DoWID DayName

1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday

Then when you create the dimension off of the table, set the "Order By"
property to Key instead of Name. That will order the dimension how you
like it.

HTH

V

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

Putting days of the week in order

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

Putting days of the week in order - 02-16-2006 , 02:24 PM

Re: Putting days of the week in order - 02-16-2006 , 04:06 PM

Re: Putting days of the week in order - 02-17-2006 , 09:06 AM