Geekswithblogs.net

The Wrecking Bawl

Destructuring query language, one keyword at a time.


News

My Stats

  • Posts - 126
  • Comments - 181
  • Trackbacks - 22

Recent Comments


Recent Posts


Archives


Post Categories


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

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.]
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Posted On Wednesday, February 06, 2008 11:05 AM
Filed Under [ all tech stuff SQL Server ]

Comments

Gravatar # re: SSAS cube: "attribute key not found" error
Posted by Jordie on 10/21/2008 4:23 AM
Thanks so much for posting this! I was having the same problem. Was getting ready to kill myself!
Gravatar # re: SSAS cube: "attribute key not found" error
Posted by Edward Moemeka on 1/14/2009 5:54 PM
THANK YOU!!!!!!
Gravatar # re: SSAS cube: "attribute key not found" error
Posted by Joachim Mutter on 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
Gravatar # re: SSAS cube: "attribute key not found" error
Posted by Chris M on 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
Gravatar # re: SSAS cube: "attribute key not found" error
Posted by Alex on 7/22/2009 11:37 AM
You could create XMLA scripts and schedule them using the SQL Agent, right?
Gravatar # re: SSAS cube: "attribute key not found" error
Posted by Hennie de Nooijer on 10/28/2010 12:52 AM
thnx. helped me a lot.
Hennie
Gravatar # re: SSAS cube: "attribute key not found" error
Posted by C on 8/11/2011 10:54 AM
Thank you! That solved it!!
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: