Thank you for your speedy reply.

OK, I got the value/label business - that's in Visual Studio when editing the dimension.

(value would be the month number and the label the month name ?)

I would appreciate a bit more help - on how to setup the hierarchy within the date table.

The columns are

[font="Courier New"]

DateKey (primary key, type: date), contiguous range of everyday from Jan 1 2007 up to Dec 31 2016)

DateString (varchar(10), date formatted as yyyy-mm-dd)

DateYear (integer YEAR(DateKey))

DateMonth (integer MONTH(DateKey))

DateDay (integer, DAY(DateKey))

MonthYear (integer, YEAR(DateKey) * 100 + MONTH(DateKey))

EnglishMonthName (varchar(20), DATENAME(mm, DateKey))[/font]

I am a still a bit confused as to what should be "pointing" to what.

Finally, the use of the hierarchy would mean I did not need to create an extra table to use as filter ?

Regards