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!