SSAS dimensions hierarchies: A duplicate attribute key has been found when processing

cube, olap, ssas

Solution

This approach solved my problem:

Instead of having the attributes following chained relationships, I simply leave the relationships as they were by default.

Player id (SK) -> Conference
Player id (SK) -> Division  
Player id (SK) -> Team 
Player id (SK) -> Player Name 
Player id (SK) -> Salary

Problem

I am completely new to SSAS an I am trying to deploy a simple cube with only one dimention comprised of multiples attributes. What I did already was to create a DSV from my data source and then I created a dimension from my fact table. It seams that no matter what happens, I get the following error message: `Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Fact_Statistics', Column: 'Team', value: 'ANA'. The attribute is 'Team'.` This is my hierarchy: Id (SK) -> Player id -> Team -> Player Name -> Salary I don't understand, obviously the problem is not that the value is null, like I've seen in other threads, telling me to set `NullProcessing` under `KeyColumns` to something else than automatic, but this is not the problem in this context. Any help would be greatly appreciated.

Original source