AFO Workbook - Integrated Planning - avoid call of BICS_PROV_GET_RESULT_SET

[Gunter_Cokl]

Hi,

I use AFO for BI IP solution. I have a SAVE Button and the macro executes following 3 steps:

1. SAVE Data

2. Planning Sequence

3. SAVE Data

After each Step BICS_PROV_GET_RESULT_SET ist called for the whole Workbook (3 Queries) - and therefore the performance is not the best.

How can I avoid e.g. the first 2 calls of BICS_PROV_GET_RESULT_SET as from my point of view it would be only necessary after the last step?

I tried to use "SAPSetRefreshBehaviour" with parameter "OFF" before 1. Step and with "ON" after 3rd step, but it had no effect.

Best regards

Gunter

[former_member186338]

It's better to provide your macro code.

[Gunter_Cokl]

thank you, but unfortunately no effect-

I replaced SAPSetRefreshBehaviour command with "AutoRefresh" command for all datasources.