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:

  1. Connect to metadata and obtain authorisation
  2. Access info map and generate query
  3. Pass query to Oracle
  4. Oracle passes data to WRS
  5. WRS renders report

To make this faster we have been looking at configuring report scheduling to see if we can pre-cache the reports