im going through an exercise book with examples of SSAS cube creation and deployment.
One exercise is to create a time dimension in a cube. The dimension is created from a date column already in the fact table.
The Time Dimension has 4 attributes:
when i try to process the dimension i get the error:
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_ManufacturingFact', Column: 'YearOfManufacture', Value: '2008'. The attribute is 'Quarter'.
I have completely emptied all dimension and fact tables and repopulated them but issue still exists.
I have recreated the time dimension, ensuring to set up the hierarchy correctly so that each child can have only one parent ( see this article: http://blog.programmingsolution.net/ssas-2008/period-dimension-time-dimension-creation-with-year-month-day-hierarchy/)
I have tried setting MemberNamesUnique to false, and setting the trim property to NONE, but still facing the issue.
I ran a trace when trying to process the dimension, and only two queries are run, first returning all the distinct quarters, and the second returning all distinct years and their quarters.
I cant see any duplicates so i cannot see where this error is comming from. any ideas?