Reports Integration Guide › Introduction › Reporting Process

Reporting Process

When a reviewer runs an iConsole report, the reviewer's security model gets applied to the report. This ensures that the report only include events that the reviewer is permitted to see. All CA DLP users have a security model assigned to them.

But when a reviewer runs a BusinessObjects report for CA DLP, a BusinessObjects user runs the report. CA DLP therefore needs to map the correct security model to the BusinessObjects user. This section describes how CA DLP and BusinessObjects Enterprise interact to ensure that BusinessObjects reports always contain the correct information.

How do CA DLP and BusinessObjects Enterprise interact to generate reports?

1. A reviewer (in this example, unipraxis\srimmel) logs on to the iConsole.
2. The reviewer browses to the Review tab and runs a BusinessObjects report for CA DLP.
3. The iConsole logs on to BusinessObjects Enterprise.

   This logon is normally automatic. However, your reviewers may have to enter their BusinessObjects user name and password when they first run a BusinessObjects report. This requirement to enter BusinessObjects credentials depends on the method used to map CA DLP reviewers to BusinessObjects accounts and whether Trusted Authentication is enabled between BusinessObjects Enterprise and the iConsole.

4. BusinessObjects Enterprise connects to the CA DLP data warehouse using the Data Warehouse User database account.
5. BusinessObjects Enterprise submits to CA DLP the database query associated with the report plus the reviewer's BusinessObjects logon name.
6. Before executing the database query, CA DLP runs an initialization routine to identify the reviewer.

   Specifically, CA DLP runs a stored procedure to map the reviewer's BusinessObjects account back to their CA DLP account.

7. The stored procedure returns the security model assigned to the reviewer's CA DLP account.

   Security models ensure that reviewers can only see events they are permitted to see when running CA DLP reports, including BusinessObjects reports for CA DLP. See the Database Guide for details about security models.

8. The Data Warehouse User inherits the database views assigned to the Search User.

   In effect, CA DLP applies the reviewer's security model to the BusinessObjects report.

9. CA DLP executes the report query submitted by the Data Warehouse User.

   The reviewer's security model ensures that the report only include events that the reviewer is permitted to see.

10. The report results are passed back to BusinessObjects Enterprise which performs any necessary processing (for example, generating charts).

    BusinessObjects Enterprise then displays the report in InfoView