May 22, 2020 at 9:22 am
Hi all
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:-
iif(PrimaryDiagnosisKey=-1,-1,AppointmentKey)
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?
TIA
Richard
May 23, 2020 at 10:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply