1. Objectives
This article explains how to use the DCM ( Data Consistency Management ) Data Provider.
2. Supported Renderers
The DCM data provider supports this following renderers:
- Line Chart
- Area Chart
- Column chart
- Bar Chart
- Stack Bar Chart
- Line Column
- Dual Line
- Dual Bar Chart
- Dual Line Column
- SLR Renderer
- Bubble Chart
- Donut Chart
- Stack Bar Chart
- Dynamic Table
Here is an example of a displayed data using the DCM data provider with the Dynamic Table renderer :
Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO|METRICS=2|visible=true|legend=|COLOR=#1f77b4|OCC_JUMP_IN=|display_value=false
3. Attributes Description
The DCM Data Provider has three tab which are Model name, comparison name and metrics.
Here is a table explaining all possible attributes for the DCM Data Provider :
| Attributes | Description |
| Model Name | List of possible Model Names |
| Comparison Name | List of possible Comparison Names. |
| Metrics | List of possible Metrics. |
PS :
For this data provider we should select one of the metrics in the list below :
Indicator
Number of objects existing only in system 1
Number of objects existing only in system 2
Number of common objects with differences
Number of identical objects
Quality
Number of run
Number of successful run
Summary
Number of compared objects
Number of inconsistencies
4. How to validate
We will compare the results displayed in the OCC Dashboard with the source in the Data Consistency management in the solution manager. We will validate the different metrics related to DCM data Provider.
4.1 Number of objects existing only in system 1
OCC Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO|METRICS=1|visible=true|legend=Number of objects existing only In System 1|COLOR=#29f48b|OCC_JUMP_IN=|display_value=false
In order to validate this metric :
1. Firstly,Use the transaction SM_workcenter.
2. Secondly,Enter the tab Data Consistency Management
3. Finally, enter the tab Cross Database Comparison
4. select the suitable comparison name
5. click on the button show last results
4.2 Number of objects existing only in system 2
OCC Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO|METRICS=2|visible=true|legend=Number of objects existing only In System 2|COLOR=#12c6ea|OCC_JUMP_IN=|display_value=false
In order to validate this metric :
1. Firstly,Use the transaction SM_workcenter.
2. Secondly,Enter the tab Data Consistency Management
3. Finally, enter the tab Cross Database Comparison
4. select the suitable comparison name
5. click on the button show last results
4.3 Number of common objects with differences
OCC Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO|METRICS=3|visible=true|legend=Number of common objects with differences|COLOR=#985fe8|OCC_JUMP_IN=|display_value=false
In order to validate this metric :
1. Firstly,Use the transaction SM_workcenter.
2. Secondly,Enter the tab Data Consistency Management
3. Finally, enter the tab Cross Database Comparison
4. select the suitable comparison name
5. click on the button show last results
4.4 Number of identical objects
OCC Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO|METRICS=0|visible=true|legend=Number of identical objects|COLOR=#ef8300|OCC_JUMP_IN=|display_value=false
In order to validate this metric :
1. Firstly,Use the transaction SM_workcenter.
2. Secondly,Enter the tab Data Consistency Management
3. Finally, enter the tab Cross Database Comparison
4. select the suitable comparison name
5. click on the button show last results
4.5 Number of compared objects
OCC Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO|METRICS=6|visible=true|legend=Number of compared objects|COLOR=#ef8300|OCC_JUMP_IN=|display_value=false
In order to validate this metric :
1. Firstly,Use the transaction SM_workcenter.
2. Secondly,Enter the tab Data Consistency Management
3. Finally, enter the tab Cross Database Comparison
4. select the suitable comparison name
5. click on the button show last results
4.6 Number of inconsistencies
OCC Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO2|METRICS=7|visible=true|legend=Number of inconsistencies|COLOR=#ef8300|OCC_JUMP_IN=|display_value=false
In order to validate this metric :
1. Firstly,Use the transaction SM_workcenter.
2. Secondly,Enter the tab Data Consistency Management
3. Finally, enter the tab Cross Database Comparison
4. select the suitable comparison name
5. click on the button show last results
The Number of inconsistencies value can be checked with this formula :
The Number of inconsistencies = Number of objects existing only in system 1 + Number of objects existing only in system 2 + Number of common objects with differences
So the Number of inconsistencies = 6 + 4 +2 = 12
4.7 Number of runs
OCC Query :
/STDF/DP_DCM:COMP_OBJ=CDC_DEMO_BUSINESS_PARTNER|COMP_INST=DEMO2|METRICS=4|legend=Number%20of%20%20Runs|visible=true|COLOR=#1f77b4|OCC_JUMP_IN=|display_value=false
In order to validate this metric :
1. Firstly,Use the transaction SM_workcenter.
2. Secondly,Enter the tab Data Consistency Management
3. Finally, enter the tab Cross Database Comparison
4. select the suitable comparison name
5. click on the button show last results
so number of runs = 40 + 37 = 77 the same number shown in the iteration ID