2 Replies Latest reply: May 12, 2011 10:02 AM by 599500 RSS

    What is the difference between different alter sandbox comamnds

    599500
      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
          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
            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