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…

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Oliver Sviszt

    Hi Andrew,

    Although at the moment  I can not test the behaviour (because SAPMoveDimension does not work for me at all, it returns 0 and does nothing beginning with the second drilldown dimension) if it is really that way I totally agree with you!

    Also, it is a pity that as it seems SAPSetVariable will not work with a freshly opened workbook if the datasources have not been refreshed before.

    What a lot of developers – including us – need is a way to get a workbook opened, the variables submitted and a drilldown plus filters set with as few roundtrips as possible. These operations can be quite time intensive and if they add up, our users keep waiting for a long time until the application even launches.

    Oliver

    (0) 

Leave a Reply