Deleting MIC Data 

Use

Whenever you upload MIC data into SAP BW, a full upload is always performed. Delta uploads, on the other hand, are not supported. For the reporting data in MIC and in SAP BW to be consistent, you must first delete all master data and transaction data in SAP BW before you can upload current OLTP data into SAP BW again. This is required in particular due to the time-based master data.

Delete the data in the following order:

...

       1.      Hierarchies

       2.      Transaction data

       3.      Master data

Deleting Hierarchies

The following InfoObjects contain hierarchies, which need to be deleted first:

·        Organizational Unit (0MIC_OU), Hierarchy OU_HIER

·        Account Group (0MIC_FSAG), Hierarchy FSAG_HIER

·        Management Control Group (0MIC_MCG), Hierarchy MCG_HIER

·        Process Group (0MIC_PG), Hierarchy PG_HIER

If you have created your own hierarchies for BW Reporting, delete these hierarchies as well and then create them again once you have uploaded the MIC data.

To delete a hierarchy, proceed as follows:

...

       1.      In the Administrator Workbench, choose Modeling ® InfoObject.

       2.      Choose Financials Management and Controlling ® Corporate Governance ® Management of Internal Controls (0CGV_MIC).

       3.      In the InfoObject catalog MIC: Characteristics (0CGV_MIC_CHA01), select the hierarchy located beneath the relevant characteristic and choose Delete from the context menu.

The BW process chains do not contain any activity for deleting hierarchies from InfoObjects. For this reason, we deliver the program MIC: Deletion of InfoObject Hierarchies (RS_BCT_CGV_MIC_MDATA_DEL_HIERS) in package RS_BCT_CGV_MIC. You can either include this program in your process chain, or execute it directly (transaction SE38), or schedule it (transaction SM36).

Deleting Transaction Data

Delete transaction data in the MIC ODS objects in the following order:

...

       1.      Assignment: Process - Control Objective - Risk - Control (0MIC_DS01)

       2.      Assignment: Process - Account Group - FS Assertions - Control (0MIC_DS02)

       3.      Status of Sign-Off for Organizational Unit (0MIC_DS03)

       4.      Remediation Plans (0MIC_DS05)

       5.      Issues (0MIC_DS04)

To delete the data in the ODS object, proceed as follows:

...

       1.      In the Administrator Workbench, choose Modeling ® InfoProvider.

       2.      Choose Financials Management and Controlling ® Corporate Governance ® Management of Internal Controls (0CGV_MIC).

       3.      In the context menu of an ODS object, choose Delete Data.

Do not choose Delete. The Delete function deletes the entire ODS object.

Deleting Master Data

Delete the master data of InfoObjects in the following order:

InfoObjects for Reporting

...

       1.      Remediation Plan (0MIC_RMPLAN)

       2.      Issue (0MIC_ISSUE)

       3.      Process Step (0MIC_PS)

       4.      Management Control (0MIC_MC)

       5.      Process (0MIC_PROC)

       6.      Risk (0MIC_RISK)

       7.      Control Objective (0MIC_CO)

       8.      Financial Statement Assertion (0MIC_FSASS)

 

InfoObjects for Central Objects

       9.      Central Process Step (0MIC_CENPS)

   10.      Central Management Control (0MIC_CENMC)

   11.      Central Process (0MIC_CENP)

   12.      Account Group (0MIC_FSAG)

   13.      Management Control Group (0MIC_MCG)

   14.      Central Process Group (0MIC_PG)

   15.      Organizational Unit (0MIC_OU)

   16.      Person (0MIC_PERSON)

 

InfoObjects for MIC Attributes

You only need to delete and reload the master data of InfoObjects for attributes if the data has been changed in the MIC source system.

   17.      Relevance Attributes of a Relevance Set (0MICRELESIT)

   18.      Relevance Set (0MICRELESET)

   19.      Relevance (0MICRELEV)

   20.      Sign-Off Relevance (0MICSOFFREL)

   21.      Sign-Off Status (0MICSIGNOFF)

   22.      Start Date and End Date of a Timeframe (0MIC_TF_PER)

   23.      Timeframe Year (0MICTFYEAR)

   24.      Timeframe (0MIC_TF)

   25.      Case Category (0MICCASECAT)

   26.      Case Type (0MICCASETY)

   27.      Origin of MIC Object (0MICOBJTYPE)

   28.      Control Type (0MIC_C_TY)

   29.      Control Automation (0MICPSAUTOM)

   30.      Control Frequency (0MICPSFREQ)

   31.      Testing Technique (0MICTSTECH)

   32.      Nature of Control (0MICPSNATUR)

   33.      Control Purpose (0MICCONPUR)

   34.      Transaction Type (0MICTRTYPE)

   35.      Control Significance (0MICPSSIGN)

   36.      Control Maturity (0MIC_MATURI)

   37.      Issue Priority (0MIC_IS_PR)

   38.      Control Objective Category (0MIC_COCAT)

   39.      Valuation (0MIC_VALUAT)

   40.      Status (0MIC_STATUS)

   41.      Rating (0MIC_RATING)

To delete the master data, proceed as follows:

...

       1.      In the Administrator Workbench, choose Modeling ® InfoObject.

       2.      In the InfoObject catalog MIC: Characteristics (0CGV_MIC_CHA01), select the relevant characteristic and choose Delete Master Data from the context menu.

       3.      Delete the master data with master data ID (SID).

The BW process chains do not contain any activity for deleting master data from InfoObjects. For this reason, we deliver the following programs in package RS_BCT_CGV_MIC. You can include these programs in your process chain, or execute them directly (transaction SE38), or schedule them (transaction SM36):

·         MIC: Deletion of InfoObject Hierarchies (RS_BCT_CGV_MIC_MDATA_DEL_HIERS)

·         MIC: Deletion of Master Data from InfoObjects for Reporting (RS_BCT_CGV_MIC_MDATA_DEL_ENTIT)

·         MIC: Deletion of Master Data from InfoObjects for Central Objects (RS_BCT_CGV_MIC_MDATA_DEL_CENTR)

·         MIC: Deletion of Master Data from InfoObjects for Attributes (RS_BCT_CGV_MIC_MDATA_DEL_ATTR)