Reporting

Use

The reporting tools in the Management of Internal Controls component provide managers with an overview of the status of the controls, which assists them in deciding whether sign-off can occur. Reporting can also be used for documenting the status of controls at the time when sign-off occurs.

Besides using the reporting tools in MIC, you can also use the extractors and BI Content for analyses in the SAP Business Information Warehouse (SAP BW). For more information, see the SAP Library for SAP NetWeaver under Start of the navigation path BI Content Next navigation step Financials Next navigation step Management of Internal Controls Next navigation step MIC Analyses End of the navigation path (from Release BI Content 3.5.3 Add-On) .

Prerequisites

To be able to print a report, the Adobe Reader must be installed on the PC.

Features

Reporting uses the following report types:

  • Hierarchical reports that allow you to drilldown

  • Tabular reports that allow you to filter data

  • Management reports that display data in aggregated form

In addition, there are the following special types of report:

  • Change Analysis , which shows how certain data (such as the assessment ratings) has changed over a timeframe of your choosing

  • Authorization Analysis , which allows you to analyze the assignments within the role and authorization concept.

For each report type, there is a task in the roles and authorizations concept. When a task is assigned to a user, that user then has authorization for displaying the respective report (see Tasks: Reporting and Sign-Off ). If you have authorization for a report type, you receive a corresponding entry in the navigation area on the Start Page . You can only display the data for those organizational units for which you have authorization.

To improve performance for reporting, you can activate the reporting buffer .

Report Layout

You can change the layout of a report in the results area of the report by choosing Personalize . You can show/hide columns as well as change the order in which they appear. However, note that the personalization settings only affects how the report is displayed online, and not the print view. For information about how to change the print view, see the section "Print" below.

Rating Filter

You can restrict the contents of a report by choosing Rating Filter . In so doing, you can specify that only specific rating types and rating values are displayed. If you select several rating types and rating values, the system displays all data records in which at least one of the selected rating values occurs in one of the selected rating types.

Example Example

In the tabular report P-CO-R-C Assignment , you can choose the Control Design Rating option under Rating Type and the Without Rating option under Rating Value . This then means that only the control design assessments for which no rating has (yet) been issued are displayed.

End of the example.

Note Note

Note the following special feature for tabular reports and management reports that display detailed information on issues and remediation plans :

When you restrict the rating type, you have to deactivate the Without Rating option for the rating value. This is because these reports have a different architecture, and using the Without Rating option would deliver incoherent data.

End of the note.
Settings

Under Settings, you canset up the following :

Aggregation Logic

With the hierarchical reports, you can specify under Settings which logic is applied to aggregate the ratings – whether the average rating or the worst rating of all lower-level ratings should be displayed at the next level up. The active implementation of the Business Add-In (BAdI) Weight for Report Line During Aggregation (FOPC_REPORT_WEIGHT) determines how the weighting of the individual ratings is calculated. In the implementations delivered for this BAdI, the implementation Calculate Weight from Control Significance is active by default. However, you can also activate one of the other implementations delivered or program your own implementation and activate that one. For more information on the BAdI and the delivered implementations, see the documentation in Customizing for MICon the IMG activity Start of the navigation path Reporting Next navigation step BAdI: Weighting of a Report Line During Aggregation End of the navigation path .

Request Report

If a report has a large data volume, it can take several minutes to display the report. In the case of such reports, it is useful to request the report results instead of waiting for it online. In this way, the report results are sent to you via a work item (that is, the task Display Determined Report Data ) when they have been calculated. Under Settings , you specify whether a report should be display directly or sent to you as a work item.

Note Note

A requested report always displays the data current at the time the request was made, even if the reporting buffer is activated.

End of the note.

You can access the requested report data via the task in the task list or under Requested Reports in the Reporting application. When you close the task, only the work item is deleted. The report data remains accessible under Requested Reports until you delete the requested report.

In Customizing for MIC under Start of the navigation path Reporting Next navigation step Make Settings for Improved Performance End of the navigation path , power users can generate an overview of the requested reports and delete specific reports, as well as close work items or forward them to other users.

By-Passing the Reporting Buffer

In the case of reports that you do not request but display online, you have the option of by-passing any reporting buffer that may exist and thereby override the central activation of the reporting buffer. By selecting this option, the data displayed is the current data, not data read from the reporting buffer.

Print

When you choose Print , the report data is displayed in a PDF file. You can print this file using the corresponding Web browser function or the Adobe Reader function. The layout of the print report was created with SAP Smart Forms . For each report delivered, SAP provides a standard form (technical name: FOPCR_STANDARD_<report key>). If you want to create your own forms or insert your own logo in the delivered forms, you have to copy the delivered forms in transaction SMARTFORMS and make adjustments to it. Furthermore, you need to assign your own forms to the relevant reports in Customizing for MIC under Start of the navigation path Reporting Next navigation step Print Reports Using Own Smart Forms End of the navigation path .

You can create special print reports with their own layout.

Activities

To display a report, proceed as follows:

  1. Select a report type under Start of the navigation path Navigation Next navigation step Reporting End of the navigation path on the start page.

  2. Select a report under Select Report.

  3. Make the report settings under Settings .

    The settings are then valid for all three report types: hierarchical, tabular, and management reports.

  4. Under Search, restrict the data to be displayed and choose Start .

    If you have specified under Settings that the report results are sent via a work item, the report is run in the background and the results can then be accessed via a task as well as under Requested Reports .

    If you have specified that the report is displayed directly, system behavior is as follows: If the system cannot display all the reporting data within 30 seconds, then the status of the read process is displayed after 30 seconds. To update report display, choose Start .

  5. Once all the data has been displayed, you can then use the rating filter to restrict it for detail analyses.