Using Report Manager

This chapter provides an overview of Report Manager and discusses how to:

• Administer Report Manager.

• View reports.

• Maintain reports.

• Use the My Reports pagelet.

Understanding Report Manager

As part of PeopleSoft Process Scheduler, Report Manager provides several different methods of viewing reports, based on the level of access granted. For example, only users who are assigned to a Report Manager Administration role in PeopleSoft Security can delete reports from the database using the Report Manager - Administration page.

Using Report Manager, you can see all of the reports that you are authorized to view by opening your report list in a browser. Folders are provided to assist in organizing reports and reducing the size of the report lists.

Note. A warning message appears the first time you open the page if more than 1000 reports are in your view or when changing the filter criteria causes more than 1000 reports to appear.

Administering Report Manager

This section discusses how to:

• Grant Report Manager administrative roles.

• Understand report folders.

• Configure Integration Broker.

• Monitor the status of reports.

Pages Used to Administer Report Manager

Granting Report Manager Administrative Roles

Access the User Profiles - Roles page.

Any user who maintains the content of Report Manager must be assigned a Report Manager administrator role in PeopleSoft Security. With this administrator role, the user can:

• Change the distribution list by adding or deleting a user or role ID.

• Delete a report from Report Manager.

• Alter the report’s expiration date.

A super user role is also available that allows you to delete and update all report output in Report Manager. Super users are allowed to delete the report entry and update the distribution list or expiration date of report entries.

The difference between the administrator (ReportDistAdmin) and super user (ReportSuperUser) roles is that the administrator role can access and update any report in the Report Manager. The super user role can update only reports that they are authorized to view.

To grant a Report Manager administrator role to a user ID:

1. In the role list, insert a new row, if necessary.

2. Click the search button next to the Role Name field.

3. Select ReportDistAdmin or ReportSuperUser.

4. Save your changes.

Understanding Report Folders

The Distribution Agent determines the report folder in which the report is viewed in Report Manager using the following rules:

• The report folder was specified at the time that the request was scheduled, either through the Process Request Dialog page or the PeopleCode ProcessRequest class.

• If the report folder was not specified when the process request was scheduled, the Distribution Agent verifies whether a folder was set in the process definition.

• If the report folder was not specified when the process request was scheduled or in the process definition, the Distribution Agent assigns the default folder that is specified in the Report Folder Administration page.

See Also

Defining Report Folders

Configuring Integration Broker

To view reports on the Report Manager - Explorer and Report Manager - List pages, the service operations that are used to send reports must be added to the local node and the domain must be activated.

To add service operations to the local node:

1. Select PeopleTools, Integration Broker, Integration Setup, Service Operations.

2. Open the service operation PSRF_FOLDER_CREATE.

3. Make sure the Active field is checked in the Default Service Operation Version section.

4. Save the service.

5. Perform the same steps as listed above for all of these services:

   • PSRF_FOLDER_CREATE

   • PSRF_REPORT_CREATE

   • PSRF_REPORT_DATE_CHANGE

   • PSRF_REPORT_DELETE

Note. Reports that have already run do not appear on the Report Manager - Explorer and Report Manager - List pages. To distribute previously run reports to the List and Explorer pages, you must rerun them.

Note. Integration Broker must be configured and your domain must be active.

See Activating Pub/Sub Server Domains, Configuring Service Operation Definitions.

Monitoring the Status of Reports

When a report fails to post to the Report Repository or fails to send the message to have the report added on the Report Manager - Explorer or Report Manager - List page, check the following sources to trace the problem:

• The distribution status on the Report Manager - Administration page and the Process Monitor - Process List page.

• The message log on the Report Manager - Report Detail page.

• The run status on the Process Monitor - Process List page.

• The Service Operations Monitor in PeopleSoft Integration Broker.

• The Distribution Agent log files.

See Understanding PeopleSoft Integration Broker.

Distribution Status on the Report Manager - Administration Page

The Report Manager - Administration page displays the current state of a report. The distribution status of the report shows the process of a request without having to check the Process Monitor. The following table lists the available statuses.

Message Log on the Report Manager Detail page

When the Distribution Agent receives the request to post the report, the agent inserts information into the Message Log table, detailing any important event. This information can be helpful in tracking down problems that the Distribution Agent encountered. If HTTP is used to transfer reports to the Report Repository, the message log includes error messages that are received from the Java servlet (SchedulerTransfer). This example illustrates a message log entry.

Run Status on the Process Monitor Detail Page

The Process Monitor − Process Detail page in PeopleSoft Process Scheduler displays the run status of a scheduled request. As PeopleSoft Process Scheduler processes the reports, it updates the status of the request. The following table shows:

• The different stages that a process request, with an output destination type of Web, goes through from the time that the PeopleSoft Process Scheduler Server Agent initiates the process to the time that the Distribution Agent transfers the files to the Report Repository.

• How the Report Manager distribution status changes as each stage is completed.

Note. The table illustrates only process requests with an output destination type of Web. Other process requests can be tracked through the message log.

See Viewing Process Details.

Service Operations Monitor in PeopleSoft Integration Broker

Select PeopleTools, Integration Broker, Service Operations Monitor, Monitoring, Asynchronous Details to access the Asynchronous Details page.

Note. This page can also be accessed by selecting the Details link for a specific transaction ID on the PeopleTools, Integration Broker, Service Operations Monitor, Monitoring, Asynchronous Services, Publications Contracts page.

After the Distribution Agent posts the report to the Report Repository, the final task is to send a message to have the entry added to the report folder table. The Distribution Agent writes the transaction information, which includes the transaction ID and the report folder. The transaction ID can be used to monitor the status of the sent message in PeopleSoft Integration Broker.

See Understanding Messaging, Using the Service Operations Monitor.

Distribution Agent Log Files

Additional information can be found in the Distribution Agent log files.

See Understanding Logging Systems.

Viewing Reports

This section provides an overview of the Report Manager views and discusses how to:

• View a list of reports to which you have access.

• View a hierarchical view of folders and reports.

Understanding the Report Manager Views

Use the Report Manager - Explorer and Report Manager - List pages to view all of the reports that are in the PeopleSoft system (across multiple databases) that the user is authorized to access. When a user first accesses Report Manager, the Report Manager - Explorer page appears, showing a hierarchical view of folders and reports.

Unlike the Report Manager - Administration page, the Report Manager - Explorer and Report Manager - List pages list reports when both of the following events occur:

1. The Distribution Agent has successfully posted the report to the report repository.

   When the report has posted, the Distribution Agent sends a message to have an entry added to the report folder table for the new report.

2. The local message node has received the message that was sent by the Distribution Agent by adding an entry for the report in the report folder table.

New reports that have been scheduled or are in the process of being posted to the report repository are viewed only through the Report Manager - Administration page.

Note. Folders that have been deleted remain active until all reports have been purged from them. However, new reports cannot be added to a deleted folder.

Pages Used to View Reports

Viewing a List of Reports to Which You have Access

Access the Report Manager - List page.

View Reports For

Enter criteria to filter the reports to list. Report Manager ignores criteria for fields which are blank.

Note. A warning message appears if more than 1,000 rows are available for display on the Report Manager List page.

Reports

This grid includes all of the reports in the PeopleSoft system that you are authorized to view across multiple databases. Filtering criteria is used to better manage the list.

Viewing a Hierarchical View of Folders and Reports

Access the Report Manager - Explorer page.

	Click to open a folder and view the contents. Click the folder again to close it.
	Click the Report Description link to display the Report Detail page. The File List group box lists the output file names and any associated log or message file names. Click the output file name, or associated log or message file name, to display the report or message log in another browser window.

The Report Manager - Explorer page displays a hierarchical view of the same reports that are listed on the Report Manager - List page. Subfolders can be created only in PS/nVision for organizing nVision reports.

Note. Empty folders are not included in the hierarchical view.

See Also

Creating Report Requests

Maintaining Reports

This section discusses how to:

• Understand purge reports process.

• Delete reports and add users to the distribution list.

• View archived reports.

Pages Used to Maintain Reports

Understanding the Purge Reports Process

When PeopleSoft Process Scheduler is set to perform a periodic purge on the System Purge tab in the system settings, it triggers the Application Engine program PRCSYSPURGE. This program purges both the Process Request and Report Manager tables. As part of the Report Manager cleanup, it also purges the reports from the Report Repository and archives the data into the Report Archive table.

Note. The purge process will not run unless the user ID that starts the Process Scheduler has TLSALL listed as a process group within the primary process profile. The PRCSYSPURGE program is delivered with the TLSALL process group.

If multiple Process Schedulers are running against the same database, and each has its own Report Repository, PRCSYSPURGE is initially responsible for the purge process. It will remove all entries from the PS_CDM_LIST table and then purge all reports that match its server name or report node from its report repository. The PRCSYSPURGE program then inserts entries to the PS_CDM_LIST_PURGE table where neither the server name nor the report node name matches. If the PRCSYSPURGE program detects that more than one Process Scheduler is active, it schedules the Application Engine PRCSRVCLN program to run on all the other active Process Scheduler servers. The PRCSRVCLN program checks whether the server uses its own Report Repository and if so, the program deletes reports from the report Repository that is used by the server.

Note. If two Process Schedulers have the same report node (report repository), then one scheduler performs the deletions for both schedulers.

For XML Publisher reports, metadata related to expired reports is archived when the process PSXPARCHATTR runs. This process runs automatically as part of the PRCSYSPURGE program. The URLs of the report files are archived along with the process information in the PSXP_FLURL_ARCH table. Search data related to XML Publisher reports is stored along with the process information in the PSXP_RATTR_ARCH table.

Expiration Date for Reports

The PeopleSoft Process Scheduler system settings feature has an option for retention days that is used to calculate the expiration date of reports that are displayed in the Report Manager. The expiration date is determined by adding the retention days from the date on which the report was generated.

See Also

Defining System Purge Options

Setting Process Permissions

Deleting Reports and Adding Users to the Distribution List

Access the Report Manager - Administration page.

To view the report results in another browser window, click the description of the required report. To view the report results or any associated log or message file, click the Details link. Click the name of the required report or message to display the output in another browser window.

Note. The reports that are listed on the Report Manager - Administration page are from only the database to which you are signed in.

This section discusses how to:

• Delete reports.

• Add users to the distribution list.

Deleting Reports

Adding Users to the Distribution List

To add users to the distribution list:

1. Click the Details link for the required report.

   The Report Detail page appears. If you don’t have authorization to add users, the page is display-only.

2. Click the Add button to add user or role IDs to the distribution list.

Note. You can save a report to your local workstation by right-clicking the appropriate Detail link, and selecting Save Target As.

Viewing Archived Reports

Access the Report Manager - Archives page.

Use the Report Manager - Archives page to view reports that have been purged from the report list after they have passed their expiration date. You cannot retrieve a purged report from the list, but the list displays the information that you need in order to retrieve a report from the backup or history copies of reports.

Using the My Reports Pagelet

The My Reports pagelet enables you to display selected reports on your PeopleSoft homepage.

Note. As a licensee of PeopleTools, you are licensed to use the reporting tools, which are limited to tools that are available from the menu. You must license PeopleSoft Enterprise Portal to use the Report Manager pagelet.

Note. Use the Report Manager link to access the Report Manager - Explorer page.

To display the My Reports pagelet:

1. Select Personalize Content, which is located above the PeopleSoft menu.

2. Select My Reports from the PeopleSoft Applications menu.

3. Click Save to return to the home page.

4. Rearrange the home page layout by selecting Personalize Layout and making the required changes.

5. Click Save to return to the home page.

6. Click the Customize button at the top of the My Reports pagelet.

   The Personalize My Reports page appears.

7. Enter the maximum number of reports to display.

8. Select to display reports created within a specified number of days or hours.

9. Click the Save Options button.

10. Click the Close and Return to Home Page link.