Change ttMetrics Total to be Total Rows Checked from SAP Information Steward
TOTAL_ROWS in ttMetrics is the total number of rows in the table which gets populated from [ISFailedData].[dbo].[IS_FD_RUN_HISTORY].TOTAL_ROWS.
In SAP IS there is the option to filter records in a rule so which changes the total number of records being checked (obviously not the same as the total number of records in table) and therefore changes the percentage of pass and failed records. This does not reconcile with ISA statistics as it just uses the total number of records in the table from in IS_FD_RUN_HISTORY. Is this a bug in ISA? It relates to BOA Support ticket #10283.
There is table called MMB_EP_RULE_STATISTIC in SAP IS that hold the required info. If possible, I would like to use this data to populate the TOTAL_ROWS in ttMetrics.
If possible I would like to make changes directly to the process that update the TOTAL_ROWS at client site to resolve the issue.
Kind Regards,
Ash
-
Guest
- Jun 14 2018
- Planned
Related ideas
Martin Kopp from Migros requested this also in April 2021.
Hi Jon,
Thanks. In the meantime, if you have any knowledge of IS Meta data tables, especially around the link between MMT_Ep_Rule_Statistic and MMT_Rule I would be hugely appreciative.
I thought I was on to something with the below, but it seems MMT_Rule_Statistic is not the link table...
My search continues...
select c.business_name,a.*
from MMT_Ep_Rule_Statistic a ,MMT_Rule_Statistic b ,MMT_Rule c
where b.rule_statistic_id = a.statistic_id and b.rule_id = c.rule_id and c.is_current_version = 'Y'
p.s. this isn't to make any changes to ISA current workings, just a custom report we have.
Ash.
Thanks for registering the idea, I agree that using the filter values, where applied, makes sense rather than just the total figure. We will look to add this in a later release post 7.0.