We currently have a multidimensional database that contains 5 cubes.
We want to process these via an SSIS task (for flow control) but we need to do them individually (it's part of our loading strategy for our data warehouse) but we're struggling to get things processing correctly.
At the moment, we load all the relvant tables and then process all the cubes at the same time by just processing the entire database (if that makes sense).
We've tried to do the cubes individually but it keeps coming with with errors along the lines of :-
[Analysis Services Execute DDL Task] Warning: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'Dim_Uncoded_Spell_Measures', Column: 'SpellKey', Value: '86649241'. The attribute is 'Spell Key'.
[Analysis Services Execute DDL Task] Error: Errors in the OLAP storage engine: An error occurred while processing the 'Dim Patient Measures' partition of the 'Patient Measures' measure group for the 'APC Activity Cube' cube from the DataWarehouseCubes database.
(The above are just two out of a list).
Things we've tried so far:-
- Process the cube on it's own
- Process the DIMs, process the cube
- Process the DIMs, process the measures, process the cube
All of the above give us a similar error to the one's list below.
I've made sure that the value mentioned above is in the correct table (and it is) but it just doesn't want to recognise it for some reason.
We could process the entire database (i.e. all 5 cubes in one go) but that would defeat the object of what we're trying to do.
We're using an "Analysis Service Processing Task" object in SSIS to do what we want to do (and we've had it working in the past when processing everything at once).
I'm fairly certain I will have missed some info that someone will need so feel free to ask for anything else.
Has anyone any idea on what we're missing?