I have a member properties on a date dimension at the day level. It is supposed to be the day of the week (1-7). Its code is datepart(dw,"dbo"."Date Values"."Dates") in the Source Column. The result is 1/1/1900 (For example). Any ideas??
It is a dimension with two hierarchies, and the member is applied to only one hierarchy at this point.