Thursday, June 14, 2012 7:13 PM
Product: SQL Server 2005 Analysis Services, SQL Server 2005 RDBMS
Problem: When trying to perform a “process full” against a Analysis Cube the following error is returned:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_FactCase, Column: PatientKey, Value: 125395; Table: dbo_FactCase, Column: CustomerKey, Value: 310. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Fact Case of Dimension: Dim Case from Database: OrametrixDWCubes, Cube: CaseCube, Measure Group: Fact Case, Partition: Fact Case, Record: 59769.
Verified that the the keys exist in the underlying relational database and the table records are complete.
- No nulls for keys on any fact table or dimension in the underlying relational database. We are using surrogate keys in all tables per Kimball method.
- Underlying relational database is straight star schema – no snowflake design.
- Reprocess full on all dimensions first and then process on the affected cube generates the same error message.
- Allowing for continued processing despite errors it will complete but with errors for those unidentified attribute keys.
This process has been running nightly for years. On the rare incident when this has occurred in the past – reprocessing and deploying the cube has fixed the problem.
Thursday, June 14, 2012 7:21 PM
Should be no need to reploy, just wait for the next data load to complete. It's a data problem.
It's an issue with a record existing in the fact table with no corresponding record in the dimensional table.
Thursday, June 14, 2012 8:56 PMAny suggestions on how to locate the offensive record?
Friday, June 15, 2012 7:29 AM
You have some tools to identity bad records. if you right clik the fact table and choose "Explore Data" option you will have four different exel like tabs/tools you can use along with the info of the error message to discrimintate the faulty records :
(table/pivot table/chart/pivot chart)
- Edited by VHteghem_Ph Friday, June 15, 2012 7:37 AM
Thursday, June 21, 2012 4:48 AMModerator
This issue occurs because a fact table for a cube has one or more records that contain an attribute key, and this attribute key does not exist in the corresponding dimension table. I recommend you that refer to the article below:
Error messages when you try to process a database or a cube in SQL Server 2005 Analysis Services: "The attribute key cannot be found" and "The record was skipped because the attribute key was not found"
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, June 25, 2012 10:43 AM