Need to delay processing OLAP cubes

  • richardmgreen1

    SSCrazy Eights

    Points: 9927

    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

  • Site Owners

    SSC Guru

    Points: 80375

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply