This short post show you one of the ways to resolve the error “SSAS The record was skipped because the attribute key was not found. Attribute” when processing a cube is SSAS.
The more detail error as below:
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: ‘dbo_FactRTGMove’, Column: ‘StaffId’, Value: ‘003006’. The attribute is ‘Staff Id’.
Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Staff Id of Dimension: Dim Operator from Database: SsasIncentive, Cube: Ssas Incentive, Measure Group: Fact RTG Move, Partition: Fact RTG Move, Record: 1.
For me is because I tried to process the cube before process the dimension after adding the fact table. Right click your dimension to Process… them before process the cube. This works for me.