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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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