I got the following when attempting to process and deploy a cube today:

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'tbl', Column: 'ID', Value: '12345'. The attribute is 'ID'. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute:  ID of Dimension: dim from Database: db, Cube: cube, Measure Group: fact, Partition: TBL, Record: 1.

I looked around for about 5 minutes on Google and really didn’t find much. Then I located a post from a guy that had ‘scoured’ the internet looking for a solution for hours but couldn’t find one. At that point, I simply pushed it to a new SSAS database and it worked fine; optionally I could have blown away the old and pushed again, but I’m doing development work.

Does anyone have a solution for this problem?  I couldn’t find one!

Lee

UPDATE 7/18/2011 - In VS right click and process on the dim or dims that are erroring out.  This should fix the problem.

-----------------------

There are occasions where I ask the reader for the answer – this is one of those occasions!


Posted in: SQL Server 2008/R2  Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog