We are using a combination of SAS Web Report Studio, for report creation/rendering and an Oracle database for data storage.
When users run reports, they effectively invoke this process:
- Connect to metadata and obtain authorisation
- Access info map and generate query
- Pass query to Oracle
- Oracle passes data to WRS
- WRS renders report
To make this faster we have been looking at configuring report scheduling to see if we can pre-cache the reports