I've set up a Data Source Connection to the Adventure Works DW database using the services credentials.
I'm creating a dimension using the DimDate table. To simplify things I'm using only the Calendar Quarter, Calendar Year, Day Number of Month, English Month Name, and the Date Key columns.
Each of these attributes have been set to AttributeHierarchyVisible = False.
I dragged the Calendar Year into Hierarchies followed by calendar Quarter, English Month Name, Day Number of month.
I set the attribute Relationships to Date Key -> Day Number Of Month -> English Month Name-> Calendar Quarter -> Calendar Year
All relationships are set to rigid.
When I try to deploy this set up I get the following errors:
Error 2 Internal error: The operation terminated unsuccessfully. 0 0
Error 3 Server: The current operation was cancelled because another operation in the transaction failed. 0 0
I also receive this warning
Warning 1 Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimDate', Column: 'CalendarQuarter', Value: '2'. The attribute is 'Calendar Quarter'. 0 0
I can't figure out what is going on or why this is erroring. The book I'm using gave me the steps listed above and Goggle has failed me thus far (a very scary thing).
Any help you guys can give to help me figure out what I'm doing wrong would be greatly appreciated.