lohan.me

SSAS "attribute key cannot be found" message.
Originally uploaded by lohanj.

Here’s how to interpret the SSAS “attribute key cannot be found” message.

Example error:

Errors in the OLAP storage engine: The attribute key cannot be found: Table:

dbo_vw_cs_categorysales, Column: cs_sto_id, Value: 50. Errors in the OLAP

storage engine: The record was skipped because the attribute key was not

found. Attribute: Store of Dimension: dimStores from Database: b2s, Cube:

CatSales Lab, Measure Group: Vw Cs Categorysales, Partition: Vw Cs

Categorysales, Record: 17.

Errors in the OLAP storage engine: The attribute key cannot be found:

Table: dbo_vw_cs_categorysales, Column: cs_sto_id, Value: 50. Errors in the

OLAP storage engine: The record was skipped because the attribute key was

not found. Attribute: Store of Dimension: dimStores from Database: b2s,

Cube: CatSales Lab, Measure Group: Vw Cs Categorysales, Partition: Vw Cs

Categorysales, Record: 17. Errors in the OLAP storage engine: The process

operation ended because the number of errors encountered during processing

reached the defined limit of allowable errors for the operation. Errors in

the OLAP storage engine: An error occurred while processing the ‘Vw Cs

Categorysales’ partition of the ‘Vw Cs Categorysales’ measure group for the

‘CatSales Lab’ cube from the b2s database.

Solution – see picture:

_____

::BI