Posted - 07/14/2012 : 10:31:21
| Hello everyone,
I was doing a SSAS test using "AdventureworksDW2008". I chose table "dbo.dimdate" as a dimension and created an hierarchy whose structure is as below:
Month number of Year
Day number of Month
when I processed this Dim at this time, everything was working fine. Bur if I add attribute relationships as below:
DateKey->Day number of Month->Month number of Year->Calendar Quarter->Calendar Semester->Calendar Year, when I processed again, it was giving me an error stating "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimDate', Column: 'CalendarSemester', Value: '2'. The attribute is 'Calendar Semester'."
Could anyone give me some advice on this? Thank you very much.