I have problem while processing cube in SSAS, everytime I have an error: enter image description here

I tried to process every dimension separately and it looks like something bad was going on after processing 'Date' dimension.

Any ideas why?

Best regards, Ana

  • 2
    the error itself is self-describing, A duplicate attribute key has been found, Table 'Dimension Date, Column – Biju jose Feb 18 at 4:54

If you take a look at your dimension table and run a query like the following:

Select count(suspect_column) as count_suspect_column, suspect_column
from Dimension_Date
GROUP BY suspect_Column
HAVING COUNT(suspect_column) > 1

It is likely that there is a duplicate value causing the process to fail. These values in that column need to be unique for the process to work. Also worth noting is that SSAS treats nulls as empty strings according to this excellent article: https://www.sqlservercentral.com/articles/ssas-error-duplicate-attribute-key-found-when-processing

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.