SAP BEx Variable Screen inputs through VBA

[Former Member]

Can some on help on how to give inputs to the SAP BEx Analyzer variable screen through VBA or VB.Net ?

when i say refresh query it is giving a pop-up screen where i have enter some mandatory fields in the the screen. please help on this if there is a way to handle this process to automate through VBA ot Vb.Net .

Thanks a Bunch.

Sukumar Challa

[former_member215107]

Hello,

1-Open your vba window.

2- View -> Properties window

3- on your VBA Project, you will see Sheet1 (SapBEXqueries)

4- Click on it, and in properties change Visible field: xlSheetHidden --> xlSheetVisible

5- On excel, you can now see the Sheet SAPBEXqueries. Look at column FZ (about) and you will see

a list of variables. you can enter value with your VBA code and refresh all your queries.

Other modification: for each query of your workbook:

Change the properties to select "Save and reuse variable values"

Regards,

Rodolphe.

[Former Member]

Hi Rodolphe,

It working absolutely fine Thanks a LOT for the turn around. It is working fine with one entry. How about multiple entries. like ....

if i want to refresh the query for single employee it is working fine. but I have a query in which i usually import some 100 Employee ID in to the Employee ID field. how can i do that through this method.

should i insert 100 rows in the required employee ID field and give the 100 employee id's or any alternative or best method to do that ...

Thanks.

Edited by: Sukumarchalla on Dec 21, 2010 8:27 PM

[Former Member]

Hi Rodolphe,

I'm sorry to bring this back up again.  But your answer below is for older version.  What about Bex Analyzer 7.2 version.  Are you able to achieve the same thing in the newer version?

Thanks,

-Dan

[former_member181999]

Hi,

I think you have ENTERED some ERROR. If you enter any undesired PARAMETERS the system may give VBA error. Firstly you IDENTIFY what is the desired VARIABLE inputs to be supplied.

For Exp: If the input is 10-2010 and if you enter 10/2010 the SYS may throw this error. -This is a error from Presentation Layer.

Hope this is useful..

Regards

[Former Member]

Hi Ashok,

i was not talking about the ERROR in the input. This variable screen is a type of input where we can give our required inputs dynamically. of course we have query in excel sheet, but when you say refresh it will pop up a SAP BEx variable screen window there it will ask for the dynamic values of the query.

that is what i am talking about.

thanks

..