This discussion is archived
2 Replies Latest reply: May 12, 2011 8:02 AM by 599500 RSS

What is the difference between different alter sandbox comamnds

599500 Newbie
Currently Being Moderated
aAlter sandbox set batch mode
Alter sandbox calculate
Alter sandbox restructure


Thanks,
Venkat
  • 1. Re: What is the difference between different alter sandbox comamnds
    828580 Newbie
    Currently Being Moderated
    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.
  • 2. Re: What is the difference between different alter sandbox comamnds
    599500 Newbie
    Currently Being Moderated
    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)
    Thanks,

    Edited by: Laksh on May 12, 2011 10:00 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points