We've got an OLAP cube that comprises several FACT tables.
We use SSIS for program flow and load the DIMs and FACTs and then process the cubes (using an Analysis Services Processing task).
The issue this morning was that it tried to process a record in the FACT table that had been removed (which is normal).
When I processed the cubes manually in SSMS, they processed without an issue.
I'm thinking that there an issue where the cubes are processing old data (i.e. trying to process the record that has been removed) and then realising the record has been removed and failing.
This is todays error message:-
"Process DataWarehouseCubes:Warning: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_Fact_NAC_Activity', Column: 'DiagnosisCodedAppointmentKey', Value: '2547708'. The attribute is 'Pk Appointment Key'."
DiagnosisCodedAppointmentKey is a named calculation:-
The value for "Pk Appointment Key" is no longer in the FACT table so I can't figure out why it's trying to process it.
Has anyone got any ideas?