Show TOC

MIC Analyses Locate this document in the navigation structure

 

The data for the application Management of Internal Controls (MIC) is largely stored in SAP NetWeaver (Organizational Management and Case Management structures) and in MIC-internal data structures. On the one hand, you can analyze this data in the MIC-specific reporting tool, and, on the other hand, you can use the extended reporting functions offered by SAP BW. In SAP BW, you can display MIC-related data in MIC in the same way as the predefined reports and analyze the data in detail using the Slice and Dice reporting options in SAP BW.

Technical Data

Available as of Release

CGVMIC 1.0 SP08, FINBASIS 3.0 SP04 (empfohlen: SP09/SP05)

BI Content Add-On Release

3.5.3

Features

BW extraction does not copy all of the MIC data 1:1 to SAP BW, but it copies at least the largest section of the data. You can use the delivered extractors and BI Content to extract the following data, for example, to SAP BW:

  • Organizational hierarchy

  • Process catalogs of organizational units with the assigned control objectives, risks, and controls (P-CO-R-C structure)

  • Control attributes

  • Account groups

  • Ratings

  • Status

There may be small differences between BW data and the data in the MIC source system if the source system contains inconsistent entries. Such entries are not extracted to ensure that the data in SAP BW remains consistent.

Note Note

Due to the considerable time-dependency of the data, a large section of the MIC data is extracted to SAP BW as master data. In this way, control attributes, ratings, and even assignments of controls to the P-CO-R structure or to FS assertions, for example, are also modeled as time-dependent characteristic InfoObjects in SAP BW, even if the data is in actual fact transaction data. The data model used for MIC data hardly contains any transaction data stored in key figures.

Any references below to "transaction data" actually relate to the above-mentioned attributes, ratings, and so forth. This makes it possible to separate them from the actual BW master data (texts, hierarchies, and attributes for characteristics).

End of the note.

To extract the MIC data to SAP BW, you perform the following steps in the described sequence. Using this document as a basis, you can also build a process chain to perform the individual steps.

  1. Collect and activate the delivered BI Content (see Activating MIC Content Objects).

  2. Extract the data to SAP BW (see Extracting MIC Data).

  3. If you would like to update the extracted data, you must delete the old data first because the MIC data can only be extracted in a full upload (see Deleting MIC Data).

  4. Extract all the data again.