Ah a little more of idea than I did have,

Right I have processed in IS and the cubes have failed.

Ive gone to the bottom of the screen and there are no errors warnings or messages .

But there are some warnings in Progress

[Analysis Services Execute DDL Task] Warning: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'fact_SEN_Fact', Column: 'DW_Prov_ID', Value: '368613'. The attribute is 'DW Prov Child ID'.

[Analysis Services Execute DDL Task] Warning: Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute DW Prov Child ID of Dimension: Provision from Database: CAYA_DataWarehouse_Dev, Cube: SEN, Measure Group: COP Stage Pupil Business Measures, Partition: SEN Fact, Record: 146611.

[Analysis Services Execute DDL Task] Warning: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'fact_SEN_Workflow_Steps', Column: 'DW_Prov_ID', Value: '368606'. The attribute is 'DW Prov Child ID'.

[Analysis Services Execute DDL Task] Warning: Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute DW Prov Child ID of Dimension: Provision from Database: CAYA_DataWarehouse_Dev, Cube: SEN Workflow Steps, Measure Group: SEN Workflow Steps, Partition: SEN Workflow Steps, Record: 796998.

Which does make me think, something is wrong that can be dealt with. A data issue....

So I go into Analysis Services and process the dimensions and its fine

I then run the cubes on full and..... it processes successfully,

Which leads me right back to the start of the problem again. How can I trouble shoot this when this is happening.

I now go back and run again in IS and re run and its fine

So I go back to quare 1 again.

Tonight it will fail. Ill run it in IS and get warnings.

Ill process in Analysis Services and it will work

I go back to IS and run it and its fine.......

:crying: