DQ dimensions - definition

[Former Member]

Where can I find the 'official' SAP definition / interpretation of DQ dimensions for :

Accuracy Completeness Consistency Integrity Timeliness Uniqueness

[NielsWeigel · Accepted solution]

Hi Mustafa,

you can find the (SAP) definition of the DQ dimensions in the SAP Information Steward User Guide.  In the SPS06 version in section 2.11.5.2 Quality dimension default values.

[Former Member · Accepted solution]

Hi Niels,

I could not find the User Guide off the new SAP ONE Launchpad support site...

However, I found the definitions under section 9.2.2 of your text - 'EIM with SAP' By Gatling.Brague,Champlin.Stefani.Weigel !!

Here's the excerpts from the text :

Quality Dimensions:

• Accuracy - Determines the extent to which data objects correctly represent the real-world values for which they were designed. For example, the sales orders for the Northeast region must be assigned a Northeast sales representative.
• Completeness - Determines the extent to which data is not missing. For example, an order is not complete without a price and quantity.
• Conformity  - Determines the extent to which data conforms to a specified format. For example, the order date must be in the format YYYY/MM/DD.
• Consistency  - Determines the extent to which distinct data instances provide non-conflicting information about the same underlying data object. For example, the salary range for level 4 employees must be between $40,000 and $65,000.
• Integrity - Determines the extent to which data is not missing important relationship linkages. For example, the launch date for a new product must be valid and must be the first week of any quarter, since all new products are launched in the first week of each quarter.
• Timeliness - Determines the extent to which data is sufficiently up-to-date for the task at hand. For example, hats, mittens, and scarves are in stock by November.
• Uniqueness - Determines the extent to which the data for a set of columns is not repeated. For example, the new product name must be unique (the same name cannot be in the product master table).

We need these to apply consistency across our DQ rules...so that the scorecards provide context/meaning to the Business

Thanks,

Mustafa

[NielsWeigel · Accepted solution]

Hi Mustafa,

best way to reach the manuals is using this link:

http://help.sap.com/bois

And keep in mind, that you always have the capability to change and maintain these Data Quality Dimensions as well. We have customers who are adapting the pre-defined ones or creating their own set of Dimensions.

Niels