Question:
Hello everybody,
I'd like to start a BEx query and save its results daily and automatically.
Does anyone know how to proceed?
Thanks and regards,
Terry
Answer:
You could try to save the results as a workbook, which would eman that the results would remain as it is, that is they cant be updated once u store them as a workbook.
Answer:
TerryZ,
Are you looking to have each as a daily snapshot? (Not overwritten each day?)
- Stephen
Answer:
I believe it is the Reporting Agent your looking for. I tallows you to setup background jobs for particular queries and so on and retienve them.
Answer:
SBobcat, Yes I want to have a daily snapshot.
Andrew, how can I launch the Reporting Agent?
Thanks for your help.
Terry
Answer:
In Admin Workbench RSA1, there is a Reporting Agent tab in the navigation column on the left.
You can create a scheduling package for printing / web templates etc and then schedule it.
You should be able to find the detailed steps in the help files.
Also consider another approach : If teh users can make better use of soft copy of the report you are trying to generate, you can use the BEx download scheduler to schedule a download of the report directly onto user's PC.
Hope this helps.
-ACH
Answer:
Thanks.
It's working now
Terry
Answer:
you can use the BEx download scheduler to schedule a download of the report directly onto user's PC.
Could you please explain how do you do that?
Thanks,
HF
Answer:
I don't know, we have developped a VBA application.
And as BW_ACH is a guest user, I'm not sure he will answer in this post...
Answer:
I don't know, we have developped a VBA application.
I also did that, the question is if there is any other solution?
You can run reporting agent for queries and write an ABAP to convert the spool request to a normal file. But this will not work with workbooks.
TerryZ,
By the way, what frontend version did you modify?
HF