Skip to Content
0

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

Dec 12, 2017 at 11:06 AM

222

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tobias Meyer Dec 12, 2017 at 06:58 PM
0

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?

Show 1 Share
10 |10000 characters needed characters left 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?

0
Sergey Musatov Dec 15, 2017 at 11:28 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded