How can I easily measure the performance of my SAP IBP Planning Templates (Refresh) in MS Excel

2 months ago 7

Please notation to integrated-business-planning-excel-addin-vba-samples/VBA samples/Samples for SAP IBP APIs released w....

The template volition springiness you the Time Elapsed for, for illustration 'Refresh'.

vincentverheyen_0-1734085466080.png
Edit the VBA of the .xlsm record if required, if (for example) you are lone funny successful measuring the 'Refresh' performance, past delete the unnecessary sections of the code:

vincentverheyen_1-1734085636999.png

Note that you tin alteration the variable Test 1 and/or ActiveWorkbook.Sheets("Test 1") according to the requirements of your Planning View / Template to test.

If you are funny successful investigating the show of different functions (Simulate, Run Forecast successful Simulation and/or Save), support those sections of the code.

Further mentation and the codification comments tin besides beryllium recovered in integrated-business-planning-excel-addin-vba-samples/VBA samples/Samples for SAP IBP APIs released w....

Read Entire Article