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 BI Content ® Financials ® Management of Internal Controls ® MIC Analyses (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.
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.
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.
Settings
Under Settings, you can set 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 MIC on the IMG activity Reporting ® BAdI: Weighting of a Report Line During Aggregation.
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.
A requested report always displays the data current at the time the request was made, even if the reporting buffer is activated.
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 Reporting ® Make Settings for Improved Performance, 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.
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 Reporting® Print Reports Using Own Smart Forms.
You can create special print reports with their own layout.
Activities
To display a report, proceed as follows:
...
1. Select a report type under Navigation ® Reporting 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.