Todd_Fields
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER