Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating Cubes using DSO...

Status
Not open for further replies.

Rob999

Programmer
May 23, 2002
98
US
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...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top