Skip to end of metadata
Go to start of metadata

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

  • No labels