Geeks With Blogs

News
The Wrecking Bawl Destructuring query language, one keyword at a time.
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
Requesting Gravatar...
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
Requesting Gravatar...
THANK YOU!!!!!!
Left by Edward Moemeka on Jan 14, 2009 5:54 PM

# re: SSAS cube: "attribute key not found" error
Requesting Gravatar...
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
Requesting Gravatar...
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
Left by Chris M on Jul 22, 2009 11:33 AM

# re: SSAS cube: "attribute key not found" error
Requesting Gravatar...
You could create XMLA scripts and schedule them using the SQL Agent, right?
Left by Alex on Jul 22, 2009 11:37 AM

# re: SSAS cube: "attribute key not found" error
Requesting Gravatar...
thnx. helped me a lot.
Hennie
Left by Hennie de Nooijer on Oct 28, 2010 12:52 AM

# re: SSAS cube: "attribute key not found" error
Requesting Gravatar...
Thank you! That solved it!!
Left by C on Aug 11, 2011 10:54 AM

# re: SSAS cube: "attribute key not found" error
Requesting Gravatar...
Te amo!! You have saved my life :D
Left by Andrés on Oct 01, 2012 12:47 AM

Your comment:
 (will show your gravatar)


Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net