hi!

we have a time dimension, with its own time table:
=============================================
CREATE TABLE [MyTime] (
[PKMyTime] [int] IDENTITY (1, 1)
[date] [datetime]
[Day] [varchar] (50)
[Month] [varchar] (50)
[Year] [smallint] NULL
[Quarter] [varchar] (50)
) ON [PRIMARY]
GO
=============================================
The Fact Table is referenced by tie PKMyTime with an
Foreign key,
everything works fine, except the oorder of the day.

when i wanna see the days (1st to 12th) for october, i get:
1
10
11
12
3
4
5
6
7
8
9

the main problem., also functions like lastperiods use
this sorting, so everyhting gets wrong!
how can i change this from string- to numeric order ?
the orderby field in the Dimension editor doesn't change
anything , even if i change the field type from wchar to
integer.

thanks for any help,
Thomas

In the dimension editor, highlight the field that's in the wrong order, go
to the properties pane, select advanced and set the "order by" property to
Name rather than ID. Re-process the dimension and all should be well.

Rob


"Thomas Gugler" <tg (AT) immobilien (DOT) net> wrote