Pass the Parameter Bex Analyzer With the Help of VBA
I have to run more than 1000 reports every month, Now I am entering criteria to the variable manually in pop up window. Now, how I can pass the parameter i.e. month/Year and some ID in the Bex Analyzer with the help of VBA so that I don't have to manually enter it in the pop up window?
And where is the variable values actually stored in workbook?
Thanks in advance guys.