Information Steward Repository Tables to get Quality Dimensions score

[former_member293952]

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

[former_member690658]

You can check Table:

MMB_Key_Data_Domain_Score_Type

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

[former_member635361]

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

[former_member293952]

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.

[Former Member]

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