Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image Removed

This page lists and describes all reports included in the DCM application. Most of the reports are included in different dashboards. 

These reports and dashboards

Image Added

This page lists and describes all reports included in the DCM application. Most of the reports are included in different dashboards. 

These reports and dashboards are provided as examples. It's highly recommended to create your own dashboards by taking a copy and selecting the reports you would like to use. So, always make a copy of the original report first so that you don't lose any changes includes in the future DCM versions.

Current list is based on DCM version 5.1.1.

Dashboards

DCM includes several dashboards for different audiences and perspectives. More information about the dashboards included in different DCM versions can be found via the links below:

  • DCM 5.1.1: Split the "Data Quality Overview" dashboard into Weekly and Monthly views
  • DCM 5.1: Added more interactive filters
  • DCM 5.0: First DCM version with interactive dashboards


Reports

The following reports are included in the DCM application. Please note that not all of these are included in a dashboard, but can be used via Reports View/Run list or by adding to your own dashboards.

Status
colourYellow
titleNEW
Indicates that the report has been added in the last couple of releases.
Status
colourGreen
titlein use
Means that report is valid and can be used as described. Note that not all reports "In use" are included in default dashboards, but these are worth checking when creating new dashboards and especially before starting to create new reports based on DCM data.
Status
colourBlue
titleDEPRECATED
Means that the report is no longer relevant and will be deleted on a later release. These reports also have "(Deprecated)" text in their name. This indicates to DCM customers that these reports can be deleted eventually (when deleted from DCM app also) and should not be used anymore.
Status
titleDELETED
Means that system admin should delete that report from the customer instance. Deletions can not be included in scoped applications, so deletions have to be done manually.

Active reports

Note: All thumbnails may not be up-to-date and this report list is still under construction.


Report Title

(Name, if <> Title)

ThumbnailTypeSource tableDescriptionStatuson Dashboard
1

Active Task Configurations

DCM Tasks - Active Task Configurations

Single scorex_jugr_dcm_task

Number of currently active task configurations that can create new DCM tasks while audits are being run.

Usage: shows if automated task creation is in use and how widely it's used. Also provides access to active task configuration list.

Status
colourGreen
titlein use
Workspace - Overview
2

Aging Data Remediation Tasks

DCM Tasks - Aging Data Remediation Task

Barx_jugr_dcm_task

Open data remediation tasks based on their creation date.

Usage: Left side of the report shows how many new tasks are getting created while the right side shows if these tasks are getting completed or not. High bars on the right side means that the process does not work properly.

Status
colourGreen
titlein use


Workspace - Overview

3

My Aging Data Remediation Tasks

DCM Tasks - My Domains - Aging Data Remediation Task


Barx_jugr_dcm_task

Same as "Aging Data Remediation Tasks", but filtered based on Data Domains related to current user.

Status
colourGreen
titlein use

Audit - My Data Domains
4

DCM - Audited fields per Field Setup

DCM - Audited fields per Field Setup

List

x_jugr_dcm_...

field_condition

List of field names and their conditions that are included in different Field setups.

Usage: For documentation purposes.

Status
colourGreen
titlein use
Blueprints - Overview
5

DCM - Field Setups per Blueprint version

DCM - Field Setups per Blueprint version

List

x_jugr_dcm_m2m_...

field_setup_container

Blueprint version list grouped by Field Setups used on those blueprints. Field Setups are common definitions and can be used by multiple blueprint versions.

Usage: Identify how different Field Setups are used on different Blueprint versions.

Status
colourGreen
titlein use

Blueprints - Overview
6

Bad data removed by Fixed DCM Tasks

DCM Tasks - Bad data removed by Fixed DCM Tasks

Trendx_jugr_dcm_taskTotal weight on completed DCM Tasks as a weekly trend.
Status
colourGreen
titlein use
NO
7

Bad data removed by my fixed tasks

DCM Tasks - Bad data removed by my fixed tasks

Single scorex_jugr_dcm_task

Total weight on all completed DCM tasks assigned to the current user.

Usage: shows how much the current user has been able to fix issues based on completed DCM tasks.

Status
colourGreen
titlein use
Workspace - My Tasks
8

Completed Data Remediation Tasks

DCM Tasks - Completed Data Remediation Tasks

Trendx_jugr_dcm_task

Number of DCM tasks completed as a weekly trend. Default grouping is by Data Domain.

Usage: showing the remediation activities in different domains.

Status
colourGreen
titlein use
Workspace - Overview
9

Data Tier Compliance (last 30 days)

DCM - Data Tier Compliance (last 30 days)


Multilevel pivot

x_jugr_dcm_...

audit_instance

Average data compliance per data domain and data tier for the last 30 days shown as a multilevel pivot table. Columns are showing the Implementation phase of the blueprint version.

If audits are run once per week, this should show the current situation. If audits are running more often than once a week, then the report is showing avg compliance for the last 7 days.

Usage: Shows the "current state" for data quality in different domains. 

Status
colourYellow
titleNEW

New in R5.1.1

Audit - Data Quality - Monthly Overview
10

Data Tier Compliance (last 7 days)

DCM - Data Tier Compliance (last 7 days)

Multilevel pivot

x_jugr_dcm_...

audit_instance

Average data compliance per data domain and data tier for the last 7 days shown as a multilevel pivot table. Columns are showing the Implementation phase of the blueprint version.

If audits are run once per week, this should show the current situation. If audits are running more often than once a week, then the report is showing avg compliance for the last 7 days.

Usage: Shows the "current state" for data quality in different domains. 

Status
colourGreen
titleIN USE


Audit - Data Quality - Weekly Overview
11

My Data Domain Compliance (last 7 days)

DCM - My Domains - Data Domain Compliance (last 7 days)


Multilevel pivot

x_jugr_dcm_...

audit_instance

Same as "Data Domain Compliance (last 7 days)", but filtered based on Data Domains related to current user.

Usage: See latest audit results and access the more detailed results by clicking a number an opening an Audit Instance into the Audit Results view.

Status
colourGreen
titlein use

Audit - My Data Domains
12

Audited records - Weekly trend

DCM - Audited records per result type weekly trend

Trend

x_jugr_dcm_...

audit_instance_metric

Total number of audited records (root records) per week grouped by the audit result type. 

Audited record is only compliant when the record is 100% compliant with the blueprint.

Usage: Compared to a blueprint compliance trend that is showing percentages, this one will show the "audit volumes" per week.

Status
colourGreen
titlein use
Audit - Data Quality - Weekly Overview
13

Audited records - Monthly trend

DCM - Audited records per result type monthly trend

Trend

x_jugr_dcm_...

audit_instance_metric

Total number of audited records (root records) per month grouped by the audit result type. 

Audited record is only compliant when the record is 100% compliant with the blueprint.

Usage: Compared to a blueprint compliance trend that is showing percentages, this one will show the "audit volumes" per month.

Status
colourYellow
titleNEW

New in R5.1.1

Audit - Data Quality - Monthly Overview
14

My Domains Audited records - Weekly trend

DCM - My Domains - Audited Records - Weekly trend

Trend

x_jugr_dcm_...

audit_instance_metric

Same as "Audited record - Weekly trend" but filtered based on data domains related to current used.

Status
colourGreen
titlein use

Audit - My Data Domains
15

Data Compliance - Weekly Trend

DCM - Blueprint compliance per audit messages % average weekly trend

Spline

x_jugr_dcm_...

audit_instance

Data compliance trend based on audit messages as a weekly trend. Average means that if the same audit has been run multiple times during the week, then an average result is shown. Default grouping per Data Tier.

Each audited record will generate multiple audit messages, so this trend should show more positive values than the other trend report that is based on audited record compliance. 

Trend timeline should be selected based on audit schedule or when the results are being reviewed (weekly or monthly for example).


Status
colourGreen
titlein use
Renamed in R4.5
Audit - Data Quality - Weekly Overview
16

Data Compliance - Monthly Trend

DCM - Blueprint compliance per audit messages % average monthly trend


Spline

x_jugr_dcm_...

audit_instance

Data compliance trend based on audit messages as a monthly trend. Average means that if the same audit has been run multiple times during the month, then an average result is shown. Default grouping per Data Tier.

Each audited record will generate multiple audit messages, so this trend should show more positive values than the other trend report that is based on audited record compliance. 

Trend timeline should be selected based on audit schedule or when the results are being reviewed (weekly or monthly for example).

Status
colourYellow
titleNEW

New in R5.1.1

Audit - Data Quality - Monthly Overview
17

Data Compliance - Weekly Trend

DCM - Data Compliance - Weekly Trend based on Audit Results


Spline

x_jugr_dcm_...

audit_results

Basically the same report as "Data Compliance - Weekly Trend" created based on Audit Instances table, but this one is based on Audit Results table. This version of the report allows us to use Interactive Filters related to Audit Results like Data Providers, but this is slower to generate.

In instances where number of Audit Results is very high, it's recommended to use the Audit Instance based version of the report.

Status
colourGreen
titlein use


NO
18

My Data Compliance - Weekly Trend

DCM - My Domains - Blueprint compliance per audit messages % average weekly trend


Spline

x_jugr_dcm_...

audit_results

Same as "Data Compliance - Weekly Trend", but filtered based on Data Domains related to current user. This report is based on Audit Results, so it provides easy access to more detailed audit results and messages.

Usage: See data compliance trends in more detail on areas that you are responsible for (or otherwise related to). No need to create separate reports per domain, when you can simply relate users to different domains.

Status
colourGreen
titlein use


Audit - My Data Domains
19

My CMDB Data Compliance - CI Attribute Grouping - Weekly Trend

DCM - My Domains - Blueprint compliance weekly trend - CMDB CI Groupings

Spline

x_jugr_dcm_...

audit_result_to_root

Same as "My Data Compliance - Weekly Trend", but based on Database View that joins Audit Results with Configuration Items.

Filtered based on Data Domains related to current user.

Usage: this report provides additional grouping and filtering capability using attributes available on the Configuration Item (cmdb_ci) table. 

This report only includes Audit Results where the Root Class is inherited from the Configuration Item table.

Status
colourYellow
titleNEW

New in R5.1.1

NO
20

DCM - Data Domain Status

DCM - Data Domain Status

Multilevel pivot

x_jugr_dcm_...

data_domain_blueprints

This table is showing status for different data domains. Each domain will have a minimum count 1, but of domain already has blueprints defined those will increase the count.

The purpose of this report is to work as a planning and scoping tool for data domains.

Status
colourGreen
titlein use
Blueprints - Overview
21

Deviations per Blueprint last month

DCM - Deviations per Blueprint last month

Heatmapx_jugr_dcm_audit_resultsThe number of deviations on different levels per blueprint for the last month.
Status
colourGreen
titlein use
NO
22

Deviations per Blueprint this month

DCM - Deviations per Blueprint this month

Heatmapx_jugr_dcm_audit_results

The number of deviations on different levels per blueprint for the current month.

This report drills down to table level and then further down to blueprint based trend graph for the month.

Status
colourGreen
titlein use
NO
23

Deviations per domain last month

DCM - Deviations per domain last month

Heatmapx_jugr_dcm_audit_results

The number of deviations on different levels per data domain for the previous month.

This report drills down to table level and then further down to blueprint based trend graph for the month.

Status
colourGreen
titlein use
NO
24

Deviations per domain this month

DCM - Deviations per domain this month

Heatmapx_jugr_dcm_audit_results

The number of deviations on different levels per data domain for the current month.

This report drills down to table level and then further down to blueprint based trend graph for the month.

Status
colourGreen
titlein use
NO
25

New Non-Compliant Unique Audit Messages - Grouped

DCM - New Non-Compliant Unique Audit Messages - Grouped

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Non-compliant unique audit messages created within the last 30 days grouped by Audit result type.

Other grouping options include deviation level, blueprint element, class, real record, audited record and status.

Status
colourGreen
titlein use
NO
26

Non-Compliant Unique Audit Messages per CI Managed by

DCM - Unique Audit Messages per CI Managed by

Horizontal barx_jugr_uam_to_root

Example report for using the "DCM Unique Audit Message to Root Record" database view that connects Configuration Items as Audited records to Unique Audit Messages.

Through this DB View, reports can include common attributes from the Configuration Item table. This report is using the Managed by reference from CI table to group the non-compliant Unique Audit Messages.

Usage: Use this report as an example to create your own reports that would combine CI Attributes and UAM data.

Status
colourGreen
titlein use

NO
27

Non-Compliant Unique Audit Messages - Grouped

DCM - Non-Compliant Unique Audit Messages - Grouped

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Non-compliant unique audit messages from the last 6 months grouped by the audit result type.

Other grouping options include blueprint element, class, real record, audited record and status for example.

Status
colourGreen
titlein use
NO
28

Non-Compliant Unique Audit Messages in CMDB - Grouped

DCM - Non-Compliant Unique Audit Messages in CMDB - Grouped

Horizontal bar

x_jugr_dcm_...

uam_to_real_records

Non-compliant unique audit messages from the last 3 months grouped by the Managed by field on the Real record related to the unique audit message.

This is an example report that uses a database view that connects audit messages into configuration items. This DB view allows using CI attributes as grouping factors.

Usage: Use this report as an example to create your own reports that would combine CI Attributes and UAM data.

Status
colourGreen
titlein use
NO
29

Non-Compliant Unique Audit Messages per Class

DCM - Non-Compliant Unique Audit Messages per Class

Heatmap

x_jugr_dcm_...

unique_audit_message

The number of non-compliant unique audit messages for the last 3 months per class and audit result type.
Status
colourGreen
titlein use
NO
30

Blueprint versions without audit (last updated)

DCM - Published blueprints without audits

Column

x_jugr_dcm_...

audited_blueprints

Published blueprint versions that has not been used for an audit trend based on their last updated date.

Usage: This report can be used to identify out-dated blueprint versions that could be deleted in order to optimize DCM license usage.

Status
colourGreen
titlein use
Blueprints - Overview
31

Blueprints without audit

DCM - Published blueprints without audits

Single score

x_jugr_dcm_...

audited_blueprints

The total number of published blueprint versions that have never been used for audit.

Usage: This report can help in optimizing the DCM license usage.

Status
colourGreen
titlein use
Blueprints - Overview
32

My Blueprints with audit

DCM - My Published blueprints without audits

Single score

x_jugr_dcm_...

audited_blueprints

Same as "Blueprints without audits", but filtered based on Blueprint versions related to current user.

Status
colourGreen
titlein use

Blueprints - My Blueprints
33

DCM Tasks per Status - Monthly trend

DCM Tasks - DCM Tasks per Status - Monthly trend

Trendx_jugr_dcm_task

Number of DCM Tasks created each month grouped by current status.

Alternative time frame for the weekly report.

Status
colourGreen
titlein use
NO
34

DCM Tasks per Status - Weekly trend

DCM Tasks - DCM Tasks per Status - Weekly trend

Trendx_jugr_dcm_taskNumber of DCM Tasks created each week grouped by current status.
Status
colourGreen
titlein use
Workspace - Overview
35

Scheduled Blueprint compliance % average weekly trend

DCM - Scheduled Blueprint compliance % average weekly trend

Spline

x_jugr_dcm_...

audit_instance

Data compliance trend based on audit messages as a weekly trend. Average means that if the same audit has been run multiple times during the week, then an average result is shown. Default grouping per Data Tier.

This is an example report that only includes audit results from scheduled audits. 

Status
colourGreen
titlein use
NO
36

Top10 Unique Audit Messages - Blueprint element

DCM - Top10 Unique Audit Messages - Blueprint element

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Top10 blueprint elements with most weight on related deviations. This basically means that these parts of the blueprints have most issues and maybe should be checked and fixed first.

Also meaning that fixing these issues should have the most impact on overall data quality.

This report includes unique audit messages that have been updated within the last 30 days.

Status
colourGreen
titlein use
NO
37

Top10 Records with Most Deviations

DCM - Top10 Records with Most Deviations

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Top10 real records with most weight on related deviations. This basically means that these records have most issues and maybe should be checked and fixed first.

Also meaning that fixing these records should have the most impact on overall data quality.

This report includes Open Unique audit messages that have been updated within the last 30 days.

Status
colourGreen
titlein use
Audit - Data Quality - Weekly Overview
38

Top10 Records with Most Deviations

DCM - Top10 Records with Most Deviations


Horizontal bar

x_jugr_dcm_...

unique_audit_message

Same as "Top10 Records with Most Deviations", but filtered based on Data Domains related to current user.

Status
colourGreen
titlein use

Audit - My Data Domains
39

Top10 Missing links

DCM - Top10 Unique Audit Messages - Missing links

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Top10 blueprint elements for references and relationships with most weight on related deviations. This basically means that these links have most issues and maybe should be checked and fixed first.

Also meaning that fixing these issues should have the most impact on overall data quality.

This report includes Open Unique audit messages that have been updated within the last 30 days.

Status
colourGreen
titlein use

Audit - Data Quality - Weekly Overview
40

My Top10 Missing Links

DCM - My Domains - Top10 Unique Audit Messages - Missing links

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Same as "Top10 Records with Most Deviations", but filtered based on Data Domains related to current user.

Status
colourGreen
titlein use

Audit - My Data Domains
41

Top10 Unique Audit Messages - Real record

DCM - Top10 Unique Audit Messages - Real record

Horizontal bar

x_jugr_dcm_...

unique_audit_message

This report is basically replaced by the "Top10 Records with Most Deviations

Status
colourGreen
titlein use
NO
42

Top10 Unique Audit Messages - Audited record

DCM - Top10 Unique Audit Messages - Audited record

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Top10 record with most weight on related deviations. This basically means that these individual records have most issues and maybe should be checked and fixed first.

Also meaning that fixing these records should have the most impact on overall data quality.

Links to audited records are based on the last audited record, since same audit message may have been discovered via different root records on different audit instances.

This report includes unique audit messages that have been updated within the last 30 days.

Status
colourGreen
titlein use
NO
43

Unique Audit Messages - Aging

DCM - Unique Audit Messages - Aging

Bar

x_jugr_dcm_...

unique_audit_message

Non-compliant unique audit messages aging report is showing how UAMs are getting old. Old UAM basically means it has not been updated by any recent audit and therefore it may be obsolete.

This may be because the issues have been fixed and audit simply doesn't find the same issues anymore or the records and blueprints are not being audited anymore.

The report includes all Open messages and all non-compliant that have been updated within the last 30 days. Meaning that Fixed or Approved messages will be dropped out from the report after 30 days.

Status
colourGreen
titlein use
NO
44

Deviations per Field Conditions

DCM - Unique Audit Messages per Field Condition

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Deviations related to Field conditions grouped by the Field setup and condition. A blueprint should have a Field setup related to one or more containers before audit can check the field level conditions.

This report is showing which individuals fields on different tables are causing most issues.

Status
colourGreen
titlein use
Audit - Data Quality - Weekly Overview
45

My Field Level Deviations

DCM - My Domains - Field Level Deviations

Single score

x_jugr_dcm_...

unique_audit_message

Total number of Field level deviations under "my domains".

Status
colourGreen
titlein use

NO
46

My Deviations per Field Conditions

DCM - My Domains - Unique Audit Messages per Field Condition


Horizontal bar

x_jugr_dcm_...

unique_audit_message

Same as "Deviations per Field Condition", but filtered based on Data Domains related to current user.

Status
colourGreen
titlein use

Audit - My Data Domains
47

Field Condition Deviations per Table

DCM - Field Condition Deviations per Table

Multilevel pivot

x_jugr_dcm_...

unique_audit_message

Deviations related to Field conditions shown as a pivot table. Grouping on rows is based on table and field while columns show the UAM Status.

This report is showing how many issues individuals fields on different tables have.

Status
colourGreen
titlein use

NO
48

Tasks without UAM

DCM Admin - Tasks without Unique Audit Messages

Single scorex_jugr_dcm_task

Administrative report to identify tasks that do not have any unique audit messages connected to them. These tasks are no longer valid and should be closed or deleted.

This report should show 0 when everything is OK.

Status
colourGreen
titlein use
Workspace - Overview
49

UAMs without Audit Messages

DCM Admin - UAMs without Audit Messages

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Unique audit messages that are no longer related to any audit messages. This administrative report will identify UAMs that may not be relevant anymore and could be deleted, since all related audit messages are already deleted.

Usage: DCM admins can use this report to delete obsolete UAM records. In later DCM versions, these "orphan" UAMs are automatically deleted, when the last audit message gets deleted.

Status
colourGreen
titlein use
NO
50

Blueprint version count trend

DCM Audit - Blueprint version count trend

Areax_jugr_dcm_metricDCM licensing is based on blueprint version count. This report will track the weekly count of blueprint versions and will be checked as part of DCM license audit.
Status
colourGreen
titlein use
Blueprints - Overview
51

DCM Audits per Blueprint version

DCM Audits per Blueprint version

Trend

x_jugr_dcm_...

audit_instance

Trend report showing how many audit instances have been triggered per blueprint as a monthly trend. For example, if a blueprint version is being audited weekly, it should increase the monthly count for blueprint version by four.

Idea is to show which blueprints are being used on a regular basis.

Status
colourGreen
titlein use
Blueprints - Overview
52

DCM Audits per My Blueprint version

DCM Audits per My Blueprint version

Trend

x_jugr_dcm_...

audit_instance

Same as "DCM Audits per Blueprint version", but filtered based on Blueprints related to current user. 

Status
colourGreen
titlein use

Blueprints - My Blueprints
53

Recently updated blueprints

DCM - Blueprints updated in last 30 days

Single score

x_jugr_dcm_...

bp_blueprint_version

Number of blueprints updated within the last 30 days.
Status
colourGreen
titlein use
NO
54

Blueprint Versions - Grouped

DCM - Blueprint Versions - Grouped

Horizontal bar

x_jugr_dcm_...

bp_blueprint_version

Blueprint versions grouped by data domain and status.
Status
colourGreen
titlein use
Blueprints - Overview
55

My Blueprint Versions - Grouped

DCM - My Blueprint Versions - Grouped

Horizontal bar

x_jugr_dcm_...

bp_blueprint_version

Blueprint versions grouped by data domain and status and filtered based on current user's role related to the blueprint.

Status
colourGreen
titlein use

Blueprints - My Blueprints
56

Number of Blueprints

DCM - Current number of Blueprints

Single score

x_jugr_dcm_...

bp_blueprint_version

Total number of blueprint versions currently in the instance. This number includes blueprints with all statuses, but it does not include blueprint templates.

This is also the number of blueprints that is related to current license plan. Total number of blueprint versions should not exceed to number of allowed blueprint versions based on the DCM subscription.

Status
colourGreen
titlein use
Blueprints - Overview
57

My Blueprint versions

DCM - My Current number of Blueprint Versions

Single score

x_jugr_dcm_...

bp_blueprint_version

Same as "Number of Blueprints", but filtered based on Blueprints related to current user. 

Status
colourGreen
titlein use

Blueprints - My Blueprints
58

DCM - My Blueprint versions

DCM - My Blueprint versions

List

x_jugr_dcm_...

bp_blueprint_version

List of blueprint versions into which the current user is related to.

Status
colourGreen
titlein use

Blueprints - My Blueprints
59

DCM Task Weight by Assignment

DCM Tasks - DCM Task Weight by Assignment

Horizontal barx_jugr_dcm_task

Currently open DCM Tasks grouped by assignment and status.

Default grouping is based on Assigned to, but the selection also includes the Assignment group.

Status
colourGreen
titlein use

NO
60

My DCM Task Weight by Assignment

DCM Tasks - My Domains - DCM Task Weight by Assignment


Horizontal barx_jugr_dcm_task

Same as "DCM Task Weight by Assignment", but filtered based on Data Domains related to current user.

Usage: See who has the most remediation tasks open under your domain. Use this information to go through the deviations with responsible persons or simply follow up the tasks.

Status
colourGreen
titlein use

Audit - My Data Domains
61

DCM Tasks - Grouped

DCM Tasks - Grouped

Horizontal barx_jugr_dcm_task

Currently open DCM Tasks grouped by Data domain and state (by default).

Other grouping factors include Data tier, Category, Implementation phase, Blueprint, and State for example.

Status
colourGreen
titlein use
Workspace - Overview
62

DCM Tasks - Monthly trend

DCM Tasks - Monthly trend

Splinex_jugr_dcm_task

Number of new DCM tasks created as a monthly trend grouped by Data domain.

Other grouping factors include Data tier, Category, Implementation phase, Blueprint, and State for example.

Status
colourGreen
titlein use
NO
63

DCM Tasks older than 30 days

DCM Tasks - DCM Tasks older than 30 days

Single scorex_jugr_dcm_task

Number of open tasks that have been created over 30 days ago.

Number will turn red, if more than 10 tasks are still open.

Status
colourGreen
titlein use
NO
64

DCM Tasks older than 7 days

DCM Tasks - DCM Tasks older than 7 days

Single scorex_jugr_dcm_task

Number of open tasks that have been created over 7 days ago.

Number will turn red, if more than 100 tasks are still open.

Status
colourGreen
titlein use
Workspace - Overview
65

DCM Tasks Weight Weekly trend

DCM Tasks - Weight Weekly trend

Splinex_jugr_dcm_task

The total weight on currently open tasks as a monthly trend based on created date and grouped by Data domain.

Other grouping factors include Data tier, Category, Implementation phase, Blueprint, and State for example.

Status
colourGreen
titlein use
NO
66

My Aging DCM Tasks

DCM Tasks - My Aging DCM Tasks

Trendx_jugr_dcm_task

DCM Tasks assigned to current user grouped by their creation date.

Status
colourGreen
titlein use
Workspace - My Tasks
67

My DCM Task List

My DCM Task List

Listx_jugr_dcm_taskCurrently open DCM Tasks assigned to the current user as a list grouped by class.
Status
colourGreen
titlein use
Workspace - My Tasks
68

My DCM Tasks - Grouped

DCM Tasks - My DCM Tasks - Grouped

Horizontal barx_jugr_dcm_task

Currently open DCM Tasks assigned to the current user grouped by Blueprint and status.

Other groupings include data tier and domain, implementation phase and assignment group.

Status
colourGreen
titlein use
Workspace - My Tasks
69

My Open DCM Tasks

DCM Tasks - My Open DCM Tasks

Single scorex_jugr_dcm_taskNumber of currently open DCM Tasks assigned to the current user.
Status
colourGreen
titlein use
Workspace - My Tasks
70

My Task Configurations

DCM Tasks - My Task Configurations

Single scorex_jugr_dcm_taskNumber of DCM Task configurations managed by the current user.
Status
colourGreen
titlein use
Workspace - My Tasks
71

Open DCM Tasks

DCM Tasks - Open DCM Tasks

Single scorex_jugr_dcm_taskTotal number of currently open DCM tasks.
Status
colourGreen
titlein use
Workspace - Overview
72

Overall Data Quality

DCM - Overall Data Quality - Good vs. Bad Data

Donut

x_jugr_dcm_...

unique_audit_message

Unique audit messages divided into good and bad data.

Good = all compliant and note level deviations. Bad = all other deviations.

Status
colourGreen
titlein use
NO
73

Data Quality - Last 30 Days

DCM - Overall Data Quality - Last 30 Days

Donut

x_jugr_dcm_...

unique_audit_message

Unique audit messages grouped by UAM status for the last 30 days.

Usage: Gives a quick overview on the overall data quality.

Status
colourGreen
titlein use

Updated in 5.1.1

Audit - Data Quality - Monthly Overview
74

Data Quality - Last 7 Days

DCM - Overall Data Quality - Last 7 Days


Donut

x_jugr_dcm_...

unique_audit_message

Unique audit messages grouped by UAM Status for the last 7 days.

Usage: Gives a quick overview on the overall data quality.

Status
colourYellow
titleNEW

Updated in 5.1.1

Audit - Data Quality - Weekly Overview
75

Total Weight on My Open DCM Tasks

DCM Tasks - Total Weight on My Open DCM Tasks

Single scorex_jugr_dcm_taskTotal weight on open DCM Tasks assigned to the current user.
Status
colourGreen
titlein use
Workspace - My Tasks
76

Total Weight on Open DCM Tasks

DCM Tasks - Total Weight on Open DCM Tasks

Single scorex_jugr_dcm_taskTotal weight on all open DCM Tasks.
Status
colourGreen
titlein use
Workspace - Overview
77

Unassigned DCM Tasks

DCM Tasks - Unassigned DCM Tasks

Single scorex_jugr_dcm_taskNumber of open DCM Tasks that are not assigned to an individual.
Status
colourGreen
titlein use
NO
78

DCM - My Domains

DCM - My Domains

List

x_jugr_dcm_...

data_domain

List of DCM Data Domains where current user is either an Owner, Manager, Group member or a listed Stakeholder.

Status
colourGreen
titlein use

Audit - My Data Domains
79

Number of Blueprints per Status

DCM - Current number of Blueprints per Status

Horizontal bar

x_jugr_dcm_...

bp_blueprint_version

Current blueprint versions grouped by Status.

Usage: Blueprint optimization. Identify for example deprecated or retired blueprints.

Status
colourGreen
titlein use

NO
80

Unique Audit Message vs. DCM Task Status Matrix

DCM Tasks - Unique Audit Message vs. Task Status Matrix

Image Added

Multi-Level Pivot

x_jugr_dcm_...

unique_audit_message

Pivot table showing number of Unique Audit Message with particular UAM and Task status.

Usage: Identify illogical status combinations. For example "Fixed" + "Open" could mean that all issues have been fixed already, but task is still open. Or "Expired" + "Open" could mean the same thing or that audited issues are no longer relevant and tasks should be closed.

Status
colourYellow
titleNEW

Introduced in 5.2

NO

Deprecated reports

The following table includes all "deprecated" reports that used to be part of the DCM application, but are no longer in use.


Report Title

(Name, if <> Title)

ThumbnailTypeSource tableDescriptionStatuson Dashboard
1

(Deprecated) Audit result types distribution this month

DCM (Deprecated) - Audit result types distribution this month

Pie
Audit messages from the current month grouped by Audit result type.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
2

(Deprecated) Audited records - last month

DCM (Deprecated)- Audit results per deviation level - last month

Donut
Audit results (audited records) per deviation level for the previous month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
3

(Deprecated) Audited records - this month

DCM (Deprecated) - Audit results per deviation level - this month

Donut
Audit results (audited records) per deviation level for the current month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
4

(Deprecated) Audit Messages for an Audit instance

DCM (Deprecated) - Audit Messages for an Audit instance

Donut

Audit messages for a single audit instance grouped by deviation type.

This report is meant as a template and using the report requires that report is being edited when an audit instance is selected.

Idea is to show results for a single audit based on audit messages instead of audited record compliance that is shown on the Audit results page (as Overview).

Status
colourBlue
titleDEPRECATED

Deprecated in R4.5

NO
5

(Deprecated) UAMs for an Audit instance

DCM (Deprecated) - Unique Audit Messages for an Audit instance

Donut

An alternative to the "Audit Messages for an Audit Instance" report. This one is only showing the unique audit messages instead of all of them.

This report is meant as a template and using the report requires that report is being edited when an audit instance is selected.

Status
colourBlue
titleDEPRECATED

Deprecated in R4.5

NO
6DCM DELETED - Blueprint compliance bubble chart last month
Bubble
Please delete this report from your instance.
Status
titleDELETED
NO
7DCM DELETED - Blueprint compliance bubble chart this month
Bubble
Please delete this report from your instance.
Status
titleDELETED
NO
8

(Deprecated) Data Compliance % last month

DCM (Deprecated) - Blueprint compliance average last month

Dial
Overall data quality index for the current month. This number is showing the average compliant messages percentage from all audits run within the last month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
9

(Deprecated) Data Compliance % last month

DCM (Deprecated) - Blueprint compliance average last month

Single score

Overall data quality index for the current month. This number is showing the average compliant messages percentage from all audits run within the last month.

Alternative version to dial type of report.

Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
10

(Deprecated) Data Compliance % this month

DCM (Deprecated) - Blueprint compliance average this month

Single score

Overall data quality index for the current month. This number is showing the average compliant messages percentage from all audits run within the last month.

Alternative version to dial type of report.

Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
11

(Deprecated) Data Compliance % this month

DCM (Deprecated) - Blueprint compliance average this month

Dial
Overall data quality index for the current month. This number is showing the average compliant messages percentage from all audits run within the current month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
12

(Deprecated) Compliance per audited records % average monthly trend

DCM (Deprecated) - Blueprint compliance per audited records % average monthly trend

Spline

Data compliance trend based on audited records as a monthly trend. Average means that if the same audit has been run multiple times during the month, then an average result is shown. Default grouping per Data Tier.

The graph will show positive numbers only for those audited records that are fully compliant with the blueprint. That is why this is a more demanding report than the one using Audit messages compliance.

Status
colourBlue
titleDEPRECATED
Deprecated in R5.1.1
NO
13

(Deprecated) Compliance per audited records % average weekly trend

DCM (Deprecated) - Blueprint compliance per audited records % average weekly trend

Spline

Data compliance trend based on audited records as a weekly trend. Average means that if the same audit has been run multiple times during the week, then an average result is shown. Default grouping per Data Tier.

The graph will show positive numbers only for those audited records that are fully compliant with the blueprint. That is why this is a more demanding report than the one using Audit messages compliance.

Status
colourBlue
titleDEPRECATED
Deprecated in R5.1.1
NO
14

(Deprecated) Completed audits last month

DCM (Deprecated) - Completed audits last month

Single score
Number of completed audits from the previous month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
15

(Deprecated) Completed audits this month

DCM (Deprecated) - Completed audits this month

Single score
Number of completed audits for the current month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
16

(Deprecated) New Bad Data last month

DCM (Deprecated) - New Bad Data Discovered by Audit last month

Single score

x_jugr_dcm_...

unique_audit_message

Total weight on unique audit messages created during the previous month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
17

(Deprecated) New Bad Data this month

DCM (Deprecated) - New Bad Data Discovered by Audit this month

Single score

x_jugr_dcm_...

unique_audit_message

Total weight on unique audit messages created during the current month.
Status
colourBlue
titleDEPRECATED
Deprecated in R4.5
NO
18

(Deprecated) Non-Compliant Audit Messages by Result Type

DCM (Deprecated) - Non-Compliant Audit Message Distribution

Pie

x_jugr_dcm_...

audit_message

Non-compliant audit messages from the last three months grouped by audit result type. 

Please note that old audit messages are deleted when the same audit is run again and a matching audit message is found and connected to same unique audit message.

This report is no longer used on default dashboards due to the introduction of unique audit messages and related reports.

Status
colourBlue
titledeprecated
Deprecated in R4.5
NO
19

(Deprecated) Non-compliant audit messages per class last month

DCM (Deprecated) - Non-compliant audit messages per class last month

Heatmap

x_jugr_dcm_...

audit_message

The number of non-compliant audit messages per class and audit result type created within the previous month.

This report is no longer used on default dashboards due to the introduction of unique audit messages and related reports.

Status
colourBlue
titledeprecated
Deprecated in R4.5
NO
20

(Deprecated) Non-compliant audit messages per class this month

DCM (Deprecated) - Non-compliant audit messages per class this month

Heatmap

x_jugr_dcm_...

audit_message

The number of non-compliant audit messages per class and audit result type created during the current month.

This report is no longer used on default dashboards due to the introduction of unique audit messages and related reports.

Status
colourBlue
titledeprecated
Deprecated in R4.5
NO
21

(Deprecated) Non-Compliant UAM Distribution

DCM (Deprecated) - Non-Compliant Unique Audit Message Distribution

Pie

x_jugr_dcm_...

unique_audit_message

Non-compliant unique audit messages from the last 3 months grouped by the audit result type.
Status
colourBlue
titledeprecated
Deprecated in R4.5
NO
22

(Deprecated) Today's Audit deviations per Manager

DCM (Deprecated) - Today's Audit deviations per Manager

Horizontal bar

x_jugr_dcm_...

unique_audit_message

Non-compliant audit messages from today grouped by the Managed by field on the Real record related to the audit message.

This is an example report that uses a database view that connects audit messages into configuration items. This DB view allows using CI attributes as grouping factors.

Status
colourBlue
titledeprecated
Deprecated in R4.5
NO
23

(Deprecated) Unique Audit Messages - Grouped

DCM - Unique Audit Messages - Grouped

Horizontal bar

All unique audit messages from the last 6 months grouped by Audit result type (by default).

Other groupings include for example deviation type, blueprint element, class, status and real record.

Status
colourBlue
titledeprecated
Deprecated in R4.5
NO
24

(Deprecated) Last Month

DCM (Deprecated) - Last Month Audit Data Quality - Good vs. Bad Data

Donut

x_jugr_dcm_...

unique_audit_message

Unique audit messages created during the previous month divided into good and bad data.

Good = all compliant and note level deviations. Bad = all other deviations.

Status
colourBlue
titledeprecated
Deprecated in R5.1.1
NO
25Top 5 DCM Task
List

Status
titleDELETE

26Top 5 UAMs185px
List

Status
titleDELETE