BEx Analyzer - execute some code after data is loaded

[Former Member]

Hi there,

I want to know if it's possible to execute some custom VBA-Code after the query of a the BEx Analyzer is loaded (and the excel sheet is populated with data).

Maybe it's possible to "hook" in an query event or something like that?

Greets,

ben

[former_member182470]

I believe it is possible. You need to write Macros from excel menu in a second sheet. I mean your macro should read data from sheet 1 and execute with your code in sheet2 and display the result.

[Former Member]

Thanks for you reply Suman.

I'm still not sure how to determine that the data from sheet 1 (the data that comes from the query) has been loaded completely...

[former_member182470]

Yeah, you want to execute your VBA code after you get the query result only, right?

That's why i gave you Sheet2 logic. Think about it..

[Former Member]

Hi Suman,

yes, exactly - I need to execute some code after I got the query results.

And yes, I thought about it and tried some things and also asked some collegues, but nobody has a clue what you mean with "Sheet2 logic" - so I would be very graceful if you could give me another hint

Thanks a lot and greets,

ben

[former_member223480]

Hi Ben

Search the SCN for vbscript code. Bex vb code has changed based on the gui version that you use.

You can have a look on the following doc an example

http://scn.sap.com/people/eugene.khusainov/blog/2006/06/05/long-texts-in-sap-bw-displaying-in-bex-an...

Thank you

Yiannis