How to address advanced reporting requirements How to address advanced reporting requirements
This topic provides additional tips, guidance, and information to help you meet unusual or demanding reporting requirements.
PRPC provides multiple facilities to support reporting:
However, management requirements or external requirements may require formats, layouts, computations, or interactivity that can be difficult or impossible to achieve with these tools.
A PegaRULES database is hosted by Microsoft SQL Server, Oracle, IBM DB2 or other popular database software. As initially installed, the database contains about 50 tables, each with a straightforward layout. Except for the Storage Stream column (pzPVStream), column names match PRPC property names.
You can meet reporting needs with stored procedures, Microsoft database tools, Oracle tools, or third party vendor products such as Crystal Reports from Business Objects.
This database is sometimes known as a rulebase, although it contains more than rules.
Reports that support first-line and second-line managers in their work typically emphasize currency and speed rather than complex layouts, complex calculations, or complex formats.
Use the Report wizard or list view rules to meet operational needs for near-real time data.
Execution of a list view or summary view rule requires processing by both database software and Java programs. The database software is more efficient at almost every task. Even when one server computer hosts both the PegaRULES database and the PRPC server, it is important to maximize use of database software, and reduce the JVM workload.
PRPC converts information on the Content tab directly to SQL; processing specified on the Organize tab or other tabs occurs within the JVM. Although SQL processing is limited to exposed properties, utilize SQL selection and sorting over JVM sorting in your reports when possible.
Oracle and competing database products reflect a large vendor investment in power, speed, and sophistication for searching, retrieval, and sorting. In addition, these products let a database administrator tailor a database with caches, indexes, operations, translations, and so on. An experienced database administrator can use these tools to improve performance and simplify report generation, especially for reports involving thousands of rows.
Exposed columns correspond to properties at the top-level of a saved object. Properties within a repeating group or embedded page are not exposed. In many such situations, a Declare Index rule can support a new index structure that directly supports a reporting need.
For example, assume your application includes a customer master file that includes up to three mailing addresses for each customer, stored in an embedded page. A report request to retrieve all customers in Zip Code 90210 cannot be processed as SQL. However, with one Declare Index rule, PRPC can maintain this information in a dedicated concrete Index- class and a corresponding dedicated database table, making retrieval simple and fast.
A database view can simplify reporting, especially with properties from two or more classes that are in separate class groups.
Using a reports database reduces the processing demand of reporting on the production PegaRULES database, and allows your database administrator freedom to implement optimizations for reporting access that do not affect application processing.
BIX allows rapid data extraction from the PegaRULES database, for later import into a data warehouse or other reporting facilities.
Reports from PRPC are based on a single pass over the row details. Averages, trends, maximum values, and minimum values can be computed in a single pass. Many other computations require multiple passes or multiple sorts. As PRPC reports can be exported to Excel for printing and advanced formatting, consider using Excel for such final computations.
If your business requires reporting on larger numbers of rows, consider using the Business Intelligence Exchange facility to export data from the PegaRULES database into a data warehouse.
Reports category