Hi everyone. I'm having problems updating my cubes automatically, as it seems I must both 'Full Process' (I've chosen this above others for a reason I won't go into here) AND 'Incrementally Update Dimensions' to get the cube to process, both in Analysis Manager via a Right Click and in VB code with DSO.
The cubes will not process either way unless the Dimensions are updated, but once they are updated, it will work either way (via Analysis Mgr interface or VB code with DSO). Obviously, I'd rather use the code than right click and wait 10 - 40 minutes for each cube, but I can't find the appropriate commands for updating the dimensions. Here's the code I'm using for processing the CUBE (which fails IF the dimensions haven't been updated):
Set dsoCube = dsoDb.MDStores.Item("ObsPerDay18"
dsoCube.Process processFull
Does anyone know how to update the Dimensions included with these cubes, either right before the cube is processed above, or by stepping through each dimension initially and refreshing them?
Thanks...
The cubes will not process either way unless the Dimensions are updated, but once they are updated, it will work either way (via Analysis Mgr interface or VB code with DSO). Obviously, I'd rather use the code than right click and wait 10 - 40 minutes for each cube, but I can't find the appropriate commands for updating the dimensions. Here's the code I'm using for processing the CUBE (which fails IF the dimensions haven't been updated):
Set dsoCube = dsoDb.MDStores.Item("ObsPerDay18"
dsoCube.Process processFull
Does anyone know how to update the Dimensions included with these cubes, either right before the cube is processed above, or by stepping through each dimension initially and refreshing them?
Thanks...