SSAS cube: "attribute key not found" error

The Wrecking Bawl Destructuring query language, one keyword at a time.

<< CPU percent limit in .Net | Home | adding a fact table to a SSAS 2005 cube >>

I just spent over an hour trying to figure out why my data tables were correct but I was getting an error about an attribute key not being found (i.e. an unlinkable foreign key). I finally figured out that processing one dimension at a time before processing the cube can get fix whatever is out of sync. [Right-click on the dimension in Solution Explorer to process it separately.] Posted on Wednesday, February 6, 2008 11:05 AM all tech stuff , SQL Server | Back to top

Comments on this post: SSAS cube: "attribute key not found" error

# re: SSAS cube: "attribute key not found" error

Thanks so much for posting this! I was having the same problem. Was getting ready to kill myself!

Left by Jordie on Oct 21, 2008 4:23 AM

# re: SSAS cube: "attribute key not found" error

THANK YOU!!!!!!

Left by Edward Moemeka on Jan 14, 2009 5:54 PM

# re: SSAS cube: "attribute key not found" error

This depends highly what exactly happened.
You are right, if you run into that error during normal development on the same server and the same SSaS database.

But if you run into that error during deployment of the XMLA script on a second server, let's say the production system and you got this error, check the default collation of the server/database. I run into that stuff, because someone configured the server to use Latin1_General_CI_AI as default collation!
See details at http://www.sysarc.de/knowhow.nsf/0E22A6B28E8399B7C12574BA0038A26A/92A52EB30D2056F5C125756700419AF4!OpenDocument

Left by Joachim Mutter on Feb 25, 2009 10:06 AM

# re: SSAS cube: "attribute key not found" error