Information Steward - Dynamic view

[#1]

Hi,

Just a small question and hopefully the answer will be a big improvement of how we use SAP IS right now.

I have a data source table that contains data of several months and years. I want to calculate rule scores for this source per month and year but without creating lots of views with different filters and adding all rule bindings again.

How can this be done?

[Mageshwaran_Subramanian]

I usually handle this kind of scenario with the help of SAP Data Services. Build a DS job with global variables and based on the inputs, such as month and year, filter the data from source table and store the results in temporary table. Then use this table in IS rule binding.

In this case, you would run the DS job first and then IS scorecard task to calculate the score.

You mentioned that you want to calculate the score by month/year. Are you trying to see the data quality trend over a period of time?. If yes, you do not have to split the data by month/year.