SSAS cube: "attribute key not found" error

SSAS cube: "attribute key not found" error: 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 06, 2008 11:05 AM Print

Comments

# re: SSAS cube: "attribute key not found" error: Jordie; 10/21/2008 4:23 AM; Thanks so much for posting this! I was having the same problem. Was getting ready to kill myself!

# re: SSAS cube: "attribute key not found" error: Edward Moemeka; 1/14/2009 5:54 PM; THANK YOU!!!!!!

# re: SSAS cube: "attribute key not found" error: Joachim Mutter; 2/25/2009 10:06 AM; 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

# re: SSAS cube: "attribute key not found" error: Chris M; 7/22/2009 11:33 AM; Thanks a lot, this really did the trick and I never knew this to be possible...

Can I ask you how you can schedule this too?

Thanks,

Chris

# re: SSAS cube: "attribute key not found" error: Alex; 7/22/2009 11:37 AM; You could create XMLA scripts and schedule them using the SQL Agent, right?

Post Comment

Enter the code shown above

Archives

Post Categories

The Wrecking Bawl