Duplicate attribute key on Time Dim (SSAS)

Hi,

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

Thanks,
Todd
SSAS-Time-Relationships.jpg
SSAS-Qtr-Key-Definition.jpg
Todd_FieldsAsked:
Who is Participating?
 
Todd_FieldsConnect With a Mentor Author Commented:
The key needs to be defined as a collection of fields in order.  See the screen shot below.
SSAS-Hierarchy.jpg
0
 
Todd_FieldsAuthor Commented:
Some additional information.  When I changed the Key column to FyFyQtr (ie. 2010-01, 2010-02), I don't get this error, but my desire is to have  Q1, Q2 etc show when I use this dimension within the hierarchy.
0
All Courses

From novice to tech pro — start learning today.