Skip to Content
Former Member
Oct 26, 2007 at 07:27 AM

How to set default variable value in the workbook


Dear experts,

I used several queries in a workbook and one of these queries contained a variable, so when every time the workbook is opened there is a window popping up to ask user to input the value for the variable.

Now I wanna set an default value for this variable so that the variable input window will not pop up when the workbook is opened.

I searched the forum and found most solutions is to use the SAPBEXqueries to set value for the variable.

But in my BEx analyzer I can not find this sheet named SAPBEXqueries. and I also found some difference between my analyzer and the ones descripted in the forum.

My BEx analyzer version is 6.40. I think it's a new version.

Do you know how to solve my problem with this version BEx analyzer?

Thanks in advance!

Best regards