Link to home
Start Free TrialLog in
Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America

asked on

SSAS Duplicate Key Error during Dim Load...of SNAPSHOT Dim

Experts,

I have a Dimension that contains numerous "Snapshots" that get loaded into it.

When attempting to load the Dim I get the error:  "A duplicate attribute key has been found while processing table:...."

There are also duplicate key errors in the dim on a few attributes because it is a snap dim. This is my only dim with multiple snapshots that get loaded and that I need to build attribute relationships on due to the MDX requirements.  Microsoft told me to drop attribute relationships on the other snap dims to avoid duplicate keys.  

Is there another way to solve this duplicate keys issue with a snapshot dimensions?

Any input is greatly appreciated!
Thanks
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Marcus Aurelius

ASKER

thanks
thanks