Skip to Content
avatar image
Former Member

Analysis Office Planning Sequence Refresh all data sources

Hi experts,

We have a large workbook with many sheets and in each sheet we have datasources/queries. When we execute planning sequece we know only one datasource will be affected but all datasources trying to refresh.

With macro we have tried to set SAPSetRefreshBehaviour to Off but plan data is not submitted in this case. So my planning sequence works and refreshes in 3 seconds if there is no other query in workbook but since planning sequence tries to refresh all queries "which may be necessary or unnecessary" client is waiting for 30 seconds at least.

I would like to know If there is a parameter which will exclude refresh when we call planning sequence? It would be handy and I think it is "a must" because customer has HANA but because of unnecessary refresh, render they are losing performance.

Best Regards, thanks in advance

Ergin Ozturk

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • May 04 at 05:18 PM

    Hello Ergin,

    I recommend posting this issue in SAP Answers for AO or PAK.

    Best Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

  • May 06 at 07:37 AM

    Hi,

    I'm not sure it is "doable" at all (mean that it will be extremely complex to control the application), but ...

    1. while opening wb set for example Application.Run("SAPExecuteCommand", "AutoRefresh", "Off", "DS_1;DS_2")

    2. right after executing sequence (let's say DS_1 is relevant) call auto refresh of DS_1 - Application.Run("SAPExecuteCommand", "AutoRefresh", "On", "DS_1")

    3. in other occasion (according to your WB design) call auto refresh of DS_2 - Application.Run("SAPExecuteCommand", "AutoRefresh", "On", "DS_2")

    BR,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07 at 08:37 AM

    Abdrey, thanks for the response we had exactly tried same thing but in this case when you input entries to DS_1, DS_2 planning sequence does not get these figures. For example, Ds_1 have some rates which are used by Planning Sequence but after this sequence run DS_1 (Rates) should not need to be refreshed, but these rates should be used in sequence.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07 at 02:28 PM

    Hi Anand,

    Are you sure when planning function executed all datasources refreshing or not?

    BR

    Add comment
    10|10000 characters needed characters exceeded

  • May 07 at 11:58 AM

    HI,

    Just try this:

    Try to execute planning sequence in process chain and trigger this process chain with the help of planning function.

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded