Skip to Content

How to to call function module from BW in VBA from Analysis for Office workbook?

Dear Experts,

I need to convert some BEx workbooks into Analysis for Office. These workbooks have VBA macros in order to call function modules from BW by RFC (using the function GetBExConnection to establish connection). I have found some quite an old information

(2013 year), that Analysis for Office does not support RFC by macro. Please let me know maybe in new versions of product this opportunity exists and how to use it?

Best Regards,

Sergey Musatov.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 12, 2017 at 06:58 PM

    What do you want to do? You could build a .Net Application with the .Net Connector from SAP and call RFC.

    Or what is your goal with VBA?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tobias!

      I want to call function module by RFC to get calculated data from BW infoproviders. I'll try to explain why using FM and not Bex queries:

      While executing, function module gets data from one or more BW infoproviders (cube, DSO) and then does a lot of complex detailed calculations using and analyzing the structures of two or more infoobject hierarchies. All calculations are made by the application server and are saved to memory, not to query dataproviders in Bex excel worksheet. Bex query is only used to show selection screen to the user and to get variable values from it. Then these values are sent to function module as input parameters. The result of function module execution is a table with data. This data is then copied to report sheet without any calculations. It's very fast and convinient way to get complex structure report on BW data.

      I have been using this approach in Bex, and now it's time to try the same method in Analysis.

      Could you please share some wisdom how to build a .Net Application with the .Net Connector from SAP and call RFC? Maybe you have a simple example?

  • Dec 15, 2017 at 11:28 AM

    If someone supports this idea, you can vote fot it :
    https://influence.sap.com/sap/ino/#/idea/144230

    Add comment
    10|10000 characters needed characters exceeded