I'm getting the following error when I process my time dimension (SQL 2008).
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'ODS_DimTime', Column: 'fyQtr', Value: '3'. The attribute is 'Fy Qtr'.
I've stripped down everything to a simple hierarchy of FY and Qtr.
Screen shots below show my attribute relationships and key setup for Quarter. I'm sure it has something to do with the key. When I let the system wizard generate a time dimension it has the key as generated, not column binding as I have.
Should I bind to the Key (date)?