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
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 ?