Hi,

1.)i try to create a WEEKDAYNAME dimension based on a date-column from a
MSSQL database.

I am able to create a WEEKDAY dimesnsion:
Member Key Column: DatePart(weekday,"dbo"."Tbl_2001-2004"."Datum_Ein")
Member Name Column: DatePart(weekday,"dbo"."Tbl_2001-2004"."Datum_Ein")

I tried this but it didnt work:
Member Key Column::
WEEKDAYNAME(DatePart(weekday,"dbo"."Tbl_2001-2004"."Datum_Ein"))

any idea?

2.)If WEEKDAYNAME works, i wanted to have the german words instead of
english.

thx
Sefer

MSSQL 2000
AS 2000

Is "dbo"."Tbl_2001-2004"."Datum_Ein" a separate Time dimension table or
fact table?

Milind

Milind schrieb:
This is a fact table!
Type is date!

Sefer