Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
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'.

Answered 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'.

  • Wednesday, February 20, 2013 12:30 AM
     
     
    Sign In to Vote
    0

    Hi All

    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'.

    Regards

    Mira



     

All Replies

  • Wednesday, February 20, 2013 2:07 AM
     
     Answered
    Sign In to Vote
    0

    Try processing your DimDate dimension first using Full Process then re-deploy and re-process your cube.

    • Marked As Answer by Mira Pimbi Wednesday, February 20, 2013 5:13 AM
    •