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

[vincentverheyen]

How can I easily measure the performance of my SAP IBP Planning Templates (Time Elapsed for Refresh)?

P.S.: Posted this one for sharing the answer with the wider SAP IBP community.

[vincentverheyen · Accepted solution]

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

The template will give you the Time Elapsed for, for example 'Refresh'.

Edit the VBA of the .xlsm file if required, if (for example) you are only interested in measuring the 'Refresh' performance, then delete the unnecessary sections of the code:

Note that you can change the variable Test 1 and/or ActiveWorkbook.Sheets("Test 1") according to the requirements (name) of your Planning View / Template to test, for example in the Active Workbook.

Please note that you need to have an appropriate value for Global Configuration parameter EXCEL_PLANNING_VIEW_APIS : planning view APIs for Visual Basic for Applications code should be enabled to Read at the very least:

For more information on this Global Configuration Parameter, see SAP Help Portal > Global Configuration Parameters Hide/Show Columns > EXCEL_PLANNING_VIEW_APIS.

Here is an example of a result:

If you are interested in testing the performance of other functions (Simulate, Run Forecast in Simulation and/or Save), keep those sections of the code.

Further explanation and the code comments can also be found in integrated-business-planning-excel-addin-vba-samples/VBA samples/Samples for SAP IBP APIs released w....