I'm building a time dimension table in my DW in order to use it in SSAS. I will be having column like Day Name and Mont Name and Month Number. When I try to create the dimension in SSAS, i get an error saying that every value in a column has to be unique. Is this true? Any ideas how to work around this?
No, it's not true.
Change your ErrorConfiguration Property on the dimension. It's probably customized. Try "default".
You can find it by opening the time.dim file and selecting the root of all your attributes which is usually named "time dim" (replace the words time dim with your dimension name). Then right-click, properties and change ErrorConfiguration.
Thanks! I'll try this.