Skip to Content

Information Steward Repository Tables to get Quality Dimensions score

Hi Team,

We are looking to get a average score for each Quality Dimensions for all projects in Data Insight scorecard. Quality Dimensions: Accuracy, Completeness, Conformity, Consistency, Integrity and Timeline.

Could you please advise is there any way to pull this data from SAP Information Steward Repository database tables?

If possible refer any documentation to get the relevant tables.

Thanks
Venky

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2016 at 07:08 AM

    You can get score at Data Domain level by joining these two tables - MMT_Key_Data_Domain and MMT_Key_Data_Domain_Score

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 30, 2016 at 06:29 PM

    Thanks for your response Arindam! These tables only giving score based on KDD but not each dimensions score. It looks like this info not exists at these IS repo tables level. SAP suggesting to raise enhancement request as this option not exists.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 26, 2020 at 11:45 AM

    Perhaps another option would be to create a new project and then add all the rules to it and setup scorecards as required.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 13, 2020 at 07:17 PM

    You can check Table:

    MMB_Key_Data_Domain_Score_Type

    It stores information about Key Data Domain, Quality Dimension, or Rule level

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.