Duplicate Keys in a dimensional hierarchy

Posted by Jeff Rix on January 13, 2012 under SSAS | Be the First to Comment

This  date hierarchy has year at the highest level and date at the lowest level. Months and quarters are between the highest and lowest levels in this data hierarchy.

Each year has a fourth quarter and each Quarter has the month of December.

The default property for dimensions in SSAS are set up to treat this as an error.

For most dimensions this would align with the business rules. If you had a football

league roster you would want the dimension to throw an error if it had a player

playing on more than 1 team.

Change the Key Duplicate Error Configuration to Ignore Error.