This section provides information about how to to create and maintain reports from the CN_Log repository.
The SQL-based reports can be very complex, which limits who can create and maintain such reports to those with advanced knowledge/experience with SQL. The CN_Reports repository in conjunction with the ProcessLaunchChangeNotificationReport Scheduled Export Post-Processor, provides the means for users with no SQL knowledge to create and maintain reports from the CN_Log repository. The CN_Reports identifies what is to be reported and to whom. The Scheduled Export determines when and how.
The key features of the CN_Reports processing are:
- Reports are linked to a specific CN_Registry record, meaning only the CN_Log entries that were saved from the CN_Registry record will be included in the report.
- Reports are defined in terms of a list of selected attributes for which the old and new value are to be displayed, the new logged value (e.g., descriptive attributes), and the values from the current record are displayed.
- Recipients for the reports are defined in terms of EnterWorks groups.
- Reports can be transmitted in any fashion supported by the Scheduled Exports processing.
- Repositories with ownership (where individual users are assigned to records so that they "own" them and are the only ones who can change specific attributes). Separate files are generated for each owner recipient. If the Report Scheduled Export is configured to send the export via Email, each owner will receive only their version of the report.
- Reports can be configured to be full or delta.