I have an Integration Services package and in it I have Analysis Services Processing Tasks
I have a task for each dimension rather than have them all in one package to update the dimensions
Then 2 Procesing tasks for the cube updates.
The dimensions run successfully. But the two cubes fail due to the Attribute keys can’t be found etc. It is as if the cubes have been run within the dimensions being processed first, which is incorrect because I have run the dimensions.
I then run it in Analsis Services. Dimensions first, then the cubes and it is successful.
I then try again in the IS package and its also successful. Presumably because its been processed in Analysis Services.
So clearly even through Integrated Services says that the dimensions have run successfully isnt true.
Can anyone give me any tips on this? Unless I manually process the cubes and dimensions I cant be sure its working. I cant do overnight processing which is… well rubbish.
BTW Everything is on Processing Options = Update. I took this to be process updates only to save time. I am really at a loss here at the moment.