We have Information Steward 4.0 and we have established connection to SAP ECC. We have a requirement wherein we would like to display all the modifications done to a field in a table. For that we created a view and did dependency profiling. We are getting results as expected i.e. Field1, Modified By, Modified At, Old Value, New value (from SAP standard tables CDHDR and CDPOS). But we would like to display this information in form of scorecard. Attached document displays the profiling results. Would like to understand how do we create rules based on these results and then generate a scorecard.Will the scorecard get refreshed automatically once it is scheduled in CMC. Any immediate help would be appreciated since we have already crossed the deadline.
Even if orignial purpose of Information Steward is to create Validation Rules that represent policies or requirements on data quality, I guess in your case you can also use Information Steward as a data reporting tool.
I can not read your screenshot as it is too small.
If you can define in a validation rule that you bind to the view you have created that expression is TRUE if the old value is equal to the new value and the expression is FALSE if the old value is differnt from the new value; then all “changes” are treated as Failed Records as they violate your rule “Field Values are not allowed to be changed”.
After binding the rule to your view, you can execute a Rule Task on your view (Calculate Score) and you will be able to see results in the IS Workspace area on the Rule Result tab and on the Rules panel.
If you want to create a full DQ Scorecard, you will need to do a DQ Scorecard Setup first defining Key Data Domain, Quality Dimensions, Rules to be used and Bindings to be used.
Note: A DQ Scorecard calculation (based on the Rule Results calculated by the Rule Task Execution (Calculate Score)) is executed or scheduled via Scorecard Calculation Utility in the CMC
Thanks for the reply. But I feel that I have not explained the requirement properly. Actually we have to create a report/scorecard whenever a field is modified i.e. “Write transaction to report when account class is modified”. This field “Account class” is in Tab1 table for example. This field is marked for changes i.e. whenever this field is updated/deleted/inserted in SAP ECC, an entry would be created in standard SAP tables CDHDR and CDPOS. Now we want to capture the user id (modified by) and the modified date & old value & new value whenever this field is modified. Modified By and Modified Date are available in CDHDR table and the actual modified values for “Account class” field are available in CDPOS table as “Old_Value” and “New_Value”. We would like to understand what rule can be written so that a DQ scorecard can be generated. Also is there any way to compare 2 column values in Information Steward by writing any rule. Hope this time I have tried to explain properly. Aplogies for making it too descriptive.
In IS, you can create a rule; define 2 params…map them to Old_Val and New_Val;In expressions compare to cols…$param1=$param2 then true else false. In this case when values differ, rule fails and output is written to Failed_DB (in case u have created one). Once rule is defined, you can create scorecard with the same. In case you want to create BO report for this, you can create report based on data in Failed_DB.
(BOB member since 2008-08-05)
(BOB member since 2008-11-05)
(BOB member since 2008-08-05)