I have a Cube, which has a single dimension table (dimDate) and two fact tables.
When I am processing the dimDate I got below error: I've set 'DateKey' as logical primary key and linked to other datekey values in fact tables.
Any Idea? I have no clue where to start as 'MonthName' should have duplicate values, for a certain month??
Internal error: The operation terminated unsuccessfully.
Server: The operation has been cancelled.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_dimDate', Column: 'MonthName', Value: 'Jul 2006'. The attribute is 'Month'.
Try processing your DimDate dimension first using Full Process then re-deploy and re-process your cube.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?