In SQL 2000 AS a time dimensions containing multiple levels (year,quarter,
month,day) could be created from a single date field. The wizard auto created
each level using the datepart function within the dimension definition.

In SQL 2005 it appears that each level of a time dimension must be drawn
from a seperate field. (Defined manually as a calculated field in the data
source view schema if not already pre-built in the dataset).

This seems like a huge backward step - am I missing something?
To have to manually create 5 fields (year, quarter, quarter index, month,
month index) instead of using a single date field seems a bit silly - and a
lot of work.

So my question is: Can a multi level date dimension be created from a single
date field in SQL 2005 AS?

In AS 2000, Member Key/Name Column is actually Member Key/Name Expression in
which we can use any valid SQL expression.

So, we can make some multi level hierarchy from a single column.

I, however, understand any SQL expression works are moved to Data Source
View area. Finally, you have to define at least Named Calculations according
to each customized Member Key/Name Column.

Ohjoo

"Andrew F" <AndrewF (AT) discussions (DOT) microsoft.com> wrote

Thanks Ohjoo,

That confirms what I was finding.

Cheers

Andrew


"Ohjoo Kwon" wrote: