Skip to Content
avatar image
Former Member

Step by step document for writting VBA code for EPM reports

Hi Folks ,

Is there any step by step document for writting vba code for EPM reporting .

If somebody can help me with the document . I do have programming experience but not with excel macros. I do have some understanding with vba or macro code

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 04, 2018 at 11:53 AM

    Sorry, but there is no difference between writing generic VBA code and VBA code using EPM API.

    Just reference the required library statically or dynamically. Then use procedures and functions described in EPM help - API section.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2018 at 02:12 PM

    A couple of points to keep in mind to avoid some common problems:

    1) Read up on early binding and late binding and if possible use late binding. This can prevent errors from occurring when upgrading the EPM Add-in to a later Service Pack. See SAP Note 1931195 regarding this.

    2) Keep in mind that the EPM Add-in API and the Analysis for Office API have different names. This is important because the Analysis for Office add-in can also run classic EPM reports, so if you have end users who may have a mix of EPM Add-in or Analysis for Office Add-in, or if you plan on changing from EPM to AO add-in in the future, you need to call a different API. SAP Note 2451876 provides an example of code that can be used to detect which Add-in is installed and call the appropriate API.


    Peter Kreutlein

    Add comment
    10|10000 characters needed characters exceeded

    • Just a small correction: the API (collection of functions and procedures) is the same for standalone EPM and EPM as a part of AO. The library is different and the object reference has to be set differently like in the sample from note: 2451876