Overview of Stored Process Reports

A stored process report consists of stored process output that is cached. The output can be viewed without re-executing the stored process. A stored process report is a view of a stored process. Stored process reports are targeted at stored processes that might involve substantial processing, but do not require real-time updates. A stored process report generated by a stored process can change on a daily, weekly, monthly, or quarterly basis and these stored process reports can now be easily generated without needless repetition of the stored process execution.
SAS Management Console is the design-time environment for stored process reports. Stored process report definitions can be created and modified in the SAS Management Console Folder view. When you create a stored process report, you must specify a stored process and the prompt values that are used to generate the stored process report. All prompt values must be fixed when the stored process report is created. These values are used each time new stored process report output needs to be generated. You can export, import, copy, and paste the stored process report definition, but not the associated stored process report packages.
The output of a stored process report is a result package. Result packages are saved in the SAS Content Server and managed by the stored process report. All cached result packages are deleted when a stored process report is deleted. A stored process report client accesses the stored process report by retrieving the result package through the object API. If a package exists and has not expired, the package is returned to the caller with no additional processing. If no package exists or the package has expired, the stored process is executed to create an up-to-date result package (if the user has permission to execute the stored process and to save data on the SAS Content Server). After the stored process has been executed, the new result package is returned to the client and any expired packages are deleted.
The SAS Stored Process Web Application provides a run-time or end-user environment for stored process reports. Users can navigate to a stored process report, specify it by path, or find it by searching and then display the contents of the stored process report. When a request is made for a stored process report, the latest output is returned or new stored process report output is generated. The stored process report is displayed by the SAS Package Viewer. Controls are provided to force a stored process report refresh (if this is allowed by the permission settings) or to view prior generations of the stored process report (if there are any available). The refresh method forces the creation of a new package regardless of whether the existing package has expired. You can also purge all cached output, or purge a specified package generation.