none
Errors in the OLAP storage engine

    Question

  • Hi,

    While deploying a ssas package, finding the below error message.

    Errors and Warnings from Response
     Internal error: The operation terminated unsuccessfully.
     Server: The operation has been cancelled.
     Internal error: The operation terminated unsuccessfully.
     Internal error: The operation terminated unsuccessfully.
     Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Employee', Name of 'Dim Employee' was being processed.
     Errors in the OLAP storage engine: An error occurred while the 'Gender' attribute of the 'Dim Employee' dimension from the 'TestCube1' database was being processed.
     Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimDate', Column: 'CalendarQuarter', Value: '4'. The attribute is 'Calendar Quarter'.

    Does anyone can help to fix this error.

     

    Thanks.

    Tuesday, February 15, 2011 11:10 AM

Answers

  • You need to change the KeyColumn values of the attributes in Date Dimension to be collection of Keys.

    Currently i am assuming the KeyColumn for Quarter could be Quarter. Instead have Year+QuarterNo as the Key column and have the Quarter Name in ValueColumn. This will make the quarter unique across years. 

    Similarly revisit all other attributes with Date Dimension.

    A good reference for this is the Date Dimension in Adventure Works


    vinu
    Tuesday, February 15, 2011 1:01 PM

All replies

  • Check your dimension table 'dbo.DimDate',might be your dimension table contains duplicate key.
    Aniruddha
    Tuesday, February 15, 2011 11:14 AM
  • You need to change the KeyColumn values of the attributes in Date Dimension to be collection of Keys.

    Currently i am assuming the KeyColumn for Quarter could be Quarter. Instead have Year+QuarterNo as the Key column and have the Quarter Name in ValueColumn. This will make the quarter unique across years. 

    Similarly revisit all other attributes with Date Dimension.

    A good reference for this is the Date Dimension in Adventure Works


    vinu
    Tuesday, February 15, 2011 1:01 PM