(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 |
---|---|---|---|
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 |
---|---|---|---|
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 |
---|---|---|---|
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> |
---|---|---|---|---|---|---|---|
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 |
… |
|
|
|
|
|
|
|