Cube Fails with Attribute Key Cannot be Found

SSAS and SSRS
1

Hi experts, this is a new one to me. MSSQL 2014 SSAS

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_RoyaltyDetail', Column: 'LicenseNu', Value: '10716'. The attribute is 'LIVE Franchises'. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute LIVE Franchises of Dimension: LIVE Franchises from Database: SMCleanAnalysis, Cube: SMClean Analysis, Measure Group: Royalty Detail, Partition: Royalty Detail, Record: 121704.

Can anyone tell me how I can identify the bad record(s)? Thanks

2

It tells you the table and value ('dbo_RoyaltyDetail', Column: 'LicenseNu', Value: '10716'.). These look like early arriving facts (inferred members). You may have to insert inferred members to the dimensions, then change the SCD to update them accordingly

1 Like
3

So, mike01.... when I run the Dimension, it completes successfully. But the Measure Group Fails. The Partition also fails when I try to process it.
So how would I insert rows into the Dimension?

4

hi

please see the below links if they help !! :slight_smile: