greetings,

i'm having problems creating week dimension for my fact table. my
fact table contains column "Date", so I try to add dimension, which
type is time, level type is week (i tried setting these to
standart/regular
aswell), and set this for both key and name properties:

DATEPART(week, Date)

Now when I try to process this cube, it fails with an error:
"Detected two sibling members with the same name"

but when I try to run the query it runs via query explorer, i get this
result:

50 50
48 48
49 49
45 45
46 46
47 47

eg, i don't have any dupes! so what's the problem

thank you.