You can use Analysis API functions to pause the variable submission, so you can make numerous changes before Analysis will “submit” the changes.
The documentation states that:
When PauseVariableSubmit is in mode “On”, all Analysis formulas and most of the Analysis macros will not be executed. The following macros will be executed: SAPAddMessage, SAPSetVariable, PauseVariableSubmit “Off”
So that means you can’t use SAPMoveDimension while PauseVariableSubmit is On…. However, you can manually move dimensions in the Analysis Task Pane while PauseVariableSubmit is On, so it seems that it is possible, but that the SAPMoveDimension method is unnecessarily disabled while PauseVariableSubmit is On….
If an Analysis engineer is reading this, can you please allow/execute VBA calls to SAPMoveDimension while PauseVariableSubmit is On?
I’m experiencing this behaviour under Analysis 1.4 SP4_1, Office 2007 (32-bit), Windows XP. IS this fixed in SP5, or an upcoming SP? Please let me know in the comments…