(DTERP-2202) Analyzer

Analyzer is a special functionality that will scan your system in order to get archiving potential and data distribution in regards to desired archiving objects. This functionality provides two types of analyses:

  • Strugglers and data distribution analysis

    • analyze how much data could be archived for which data archiving area, this is a very complex analysis and can take quite time to finish

  • Quick data distribution analysis

    • users that do not want to wait for detailed results of strugglers analysis can utilize quick data distribution analysis

One of the analysis types for a specified archiving object is a prerequisite in order to use mass archiving functionality.

Run creation and execution

Transaction: /DVD/EM - > Analyzer

You are able to include multiple analyses into one analysis run.

  • Hit the button New

  • Choose analyses you want to add into a run

  • Specify execution parameters

  • Execute

If you typed your email to execution parameters, you will get the notification email once the analysis is ready.

Results

When the execution of the analysis rub is successfully done, you are able to check the results. Depending on the analysis result contains the following information.

Quick data distribution analysis

Analysis provides data distribution of tables by specific characteristics depending on the selected archiving object. In addition, it provides the size of the particular characteristic value combination.

FI Quick FI_DOCUMNT_QAAE FI_DOCUMNT quick archiving analysis
CO Quick CO_ITEM_QAAE CO_ITEM quick archiving analysis
MM Quick MM_EBAN_QAAE MM_EBAN quick archiving analysis
SD Quick SD_VTTK_QAAE SD_VTTK quick archiving analysis
MM Quick MM_ACCTIT_QAAE MM_ACCTIT quick archiving analysis
MM Quick MM_MATBEL_QAAE MM_MATBEL quick archiving analysis

Example

Archiving object used in example FI_DOCUMNT.

You can check the data distribution of the following tables:

AGKO, BKPF, BSAD, BSAK, BSAS, BSIM, BSIP, BSIS, FAGL_SPLINFO, FAGL_SPLINFO_VAL, FLEXGL, RFBLG
For each of the tables you get the following result structure:

Fiscal year

Company code

Posting period

Total number of records

Fiscal year

Company code

Posting period

Total number of records

2006

0005

1

14

2006

0005

2

10

2006

0005

3

31

 

 

 

Straggler and data distribution analysis

The analysis provides detailed results that contain information about how much data can be archived, how much data is blocked, and by which rule. Some of the rules can also provide examples of such data. The analysis contains also data distribution with additional information about archive-able size and how much data is blocked by which rule for specific characteristic value combination.

CO Straggler CO_COPC_ARCH Archiving object CO_COPC analysis
CO Straggler CO_ITEM_ARCH Archiving object CO_ITEM analysis
FI Straggler FI_DOCUMNT_ARC Archiving object FI_DOCUMNT analysis
FI Straggler MM_ACCTIT_ARCH Archiving object MM_ACCTIT analysis
LE Straggler RV_LIKP_ARCH Archiving object RV_LIKP analysis
MM Straggler MM_EBAN_ARCH Archiving object MM_EBAN analysis
MM Straggler MM_EKKO_ARCH Archiving object MM_EKKO analysis
MM Straggler MM_MATBEL_ARCH Archiving object MM_MATBEL analysis
PP Straggler PP_BLPK_ARCH Archiving object PP_BKFLUSH analysis
SD Straggler SD_VBAK_ARCH Archiving object SD_VBAK analysis
SD Straggler SD_VBRK_ARCH Archiving object SD_VBRK analysis
SD Straggler SD_VFKK_ARCH Archiving object SD_VFKK analysis
SD Straggler SD_VTTK_ARCH Archiving object SD_VTTK analysis

Example

Archiving object used in example FI_DOCUMNT.

The following screenshot displays results of how much data are blocked by which rule.

Enhanced data distribution structure

Fiscal year

Company code

Posting period

Total number of records

Archivable number of rows

Archiving size

Total size

<Number of lines blocked by rules>

Fiscal year

Company code

Posting period

Total number of records

Archivable number of rows

Archiving size

Total size

<Number of lines blocked by rules>

2006

0005

1

14

14

0,02

0,02

0

2006

0005

2

10

9

0,01

0,01

1

2006

0005

3

31

30

0,03

0,03

1