Marcus Aurelius
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER