Alter sandbox set batch mode - used to set the sandbox in batch mode. Another mode the sandbox can be set in is the interactive mode. In batch mode multiple commands are executed once when sandbox is submitted.
Alter sandbox calculate - does cube calculation.
Alter sandbox restructure - does cube calculation and publishes objects as well.
Thanks much for the response. Greatly appreciate it.
One more q -
Is Publish is required only when any data definition /metadata of objects(dimensions and measures) related to the cube changes. Also if we have cross cube measures in a cube using which rollup is being done, do we need to still recalculate and restructure cube after dimesnions are refreshed.
Also do we need system downtime(maintenance mdoe where users cannto login)
1. when we are running alter sandbox
2. While just loading dimensions(do we need to publish after loading dimensions)
Edited by: Laksh on May 12, 2011 10:00 AM