(DTERP-2205) 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:

  • Stragglers 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 a time to finish

  • Quick data distribution analysis

    • users that do not want to wait for detailed results of stragglers 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 to a run

  • Specify execution parameters

  • Execute

If you typed your email to execution parameters, you would 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 gives the size of the particular characteristic value combination.

Area

Analysis type

Analysis ID

Description

Area

Analysis type

Analysis ID

Description

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 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.

Area

Analysis type

Analysis ID

Description

Area

Analysis type

Analysis ID

Description

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 the 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