I am trying to use the BEx Download Scheduler to dump Excel format reports onto the application server. I have:
a) Created my Web Template
b) Created & assigned Reporting Agent Settings to the web template
c) Assigned my UserID in the Reporting Agent Setting
c) Created a Scheduling Package & assigned my RA Setting to it.
Now when I try to use the Download Scheduler I select Excel format and then select a local drive on my PC just to test it. However, it appears to download OK, but whenever I pull up the file, the Excel sheet always yields blank resuts: it is a blank spreadsheet. Is there some other setting I am not aware of? We are on BW v3.5 SP20.
P.S. My Preview in the Reporting Agent Setting yields results, so I know it is a good web template.
Thanks!