Is it possible to get the output of an ABAP program in Excel using the Analysis plug-in

[mitko1994]

Hello Experts,

I'm interested in doing some VBA customization based on the execution and output of a program. Is there a way to retrieve the program's output in Analysis somehow? I've looked at the user guide for Analysis but I haven't seen anything in the API that would do the trick. It looks like the only output is a boolean for successful/failed execution of a command.

Thanks,

Dimitar

[mitko1994]

Are these bookmark FMs used to power the bookmarking functionality in BW built-in query displays( like BICS or HTML) only?

[mitko1994]

Hi tammy.powlas3 and gregor.dieckmann ,

Thanks for your reply. I'm not too sure how BAdI's work but if I understand it correctly they are an enhancement to standard SAP functionality and the implementation is processed as soon as the connection to BW is established, as stated in the example of the Analysis user guide. The problem is that I will need to pass parameters to the piece of code I want to execute. Perhaps I should give you more details as to what I'm trying to achieve. I would like to implement a bookmarking solution in Analysis where users can save a snapshot of their query state and be able to load that state at any time. I have applied this functionality in Lumira applications and am now looking to implement something similar in Analysis workbooks. What I notice is that there's a Function group called "RSAO_CORE" that contains a few bookmark related Function Modules which seem to take care of all bookmark related operations. It appears as though they were implemented but no one told the world about them. They weren't marketed or presented anywhere by SAP (or maybe I missed it). Is there a way to take advantage of these FMs in Analysis and implement a Lumira-like bookmarking feature using native framework functionality?

https://archive.sap.com/discussions/thread/3426618

According to the link above, this is possible using the SAP .NET Connector, however the post is quite old and perhaps there are more innovative ways of achieving this nowadays. I have never worked with such a connector before so it's all new to me and I would really appreciate your guidance and suggestions as to how I should tackle this. I look forward to your input on the matter.

Thanks,

Dimitar

[gregor_dieckmann]

Hi Dimitar,

have you checked Analysis Office documentation, cf. section 'Using BAdI information'?

Regards,

Gregor

[TammyPowlas]

I am thinking something like the free ABAP2XLXX project may help you more - see https://wiki.scn.sap.com/wiki/display/ABAP/abap2xlsx