Question:
Hello All,
Is there a way via VBA to force a BEX query to use a variant when the query is refreshed? I'm trying to do some automated reporting and I would like the ability to use the query in different excel spreadsheets and thus different variants accordingly.
Thank you in advance for any assistance.
Answer:
Wh don't you put the values you want to filter on as filter, instead of variables at query run ? If you only want 1 variant per sheet, this is the best (easiest ?) way, for me.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
I thought the filters were executed on the client side and the variables on teh server side. I didn't want too much unneccessary data going accross the network. It this not correct?
Answer:
No, Filters are also processed on server side. no "client memory filtering" for BEx.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.