Question:
Hi all
I have a workbook with 4 queries. Query A is the replacement path for the other three. Every time I refresh I have to select the input variable 4 times, one for each query. This is seriously painful!!
I have tried selecting outside the query and refreshing all queries with the same result.... I have to input 4 times.
We are on 3.0B patch 15.
Does anyone know how I can refresh the entire workbook withough inputting the variable values 4 time?
Thanks
Tress
Answer:
Hi Tress
I have exactly the same problem.
BW recognises similar variables if used in the same workbook, unfortunately this only goes as far as the first layer of queries, if you have any prequery's feeding those, BW is not able to do this recognition.
I have not found a solution to this. I have tried to lesten the impact of this through various workarounds by trying to limit the amount of queries i use in the workbook(through very nasty multiproviders and cell restrictions in the queries) or not having any user input variables on the pre query(fixed filter values or exit variables only)
Good luck, if you find anything to resolve this please post it here.. many will be interested.
cheers
Answer:
Try going to Properties in each worksheet for your queries and tick the box save and reuse Variables for each one, that way when the report fires up it will reuse the same variables you defined. - But you will still have to execute the queries four times.
Alternative solution : could precalculate the queries in advance, therefore when the are executed they have already been executed in the background.
Answer:
Please describe the pre-calculate process?
Answer:
There's a white paper on Precalculating Queries on sapnet. have a look, it talks about precalculated Web queries but you can use it also for workbooks.
Answer:
Thanks Anil for your response.
This report needs the variable (pre-query) to be flexible to users so I am not sure that pre calculation is the answer.
I am now looking at using some visual basic [SAPEXcopyFilterValue] to populate a normal characteristic variable with the contents of query A as opposed to using the replacement path.
Will let you know if it works, although I may go insane in the meantime!!
Thanks
Tress