Description
Customers who are upgrading from 20.0 GA/20.1GA to 20.2 GA/20.2.2, SAP Data API TXR run usage, and Digital Access API TXR run usage reports are not getting generated by default.
Global Admin or Reports Admin can create these reports manually under the Reports page of Evolve Site - Admin App.
Applies To
Evolve20.2, Studio Manager 20.2
Solution/Immediate Workaround
Please find the SQL Queries for the same.
Report Name - SAP Data API TXR run usage
SQL Query:
Select Top (100) Percent DateName(Month, RPT_TransactionRoiView.ActivityDateTime) + ' ' + Cast(Year(RPT_TransactionRoiView.ActivityDateTime) As nvarchar) AS 'Execution Month', RPT_TransactionRoiView.Tag AS 'Category',Sum(RPT_TransactionRoiView.RecordsUploaded) + Sum(RPT_TransactionRoiView.RunErrors) AS 'Records Uploaded' From [dbo].[RPT_TransactionRoiView] Where OperationType = 'Run' and ProcessSource = 'SI_API'
GROUP BY EOMonth(ActivityDateTime), [Tag], DateName(Month,ActivityDateTime) + ' ' + cast(YEAR(ActivityDateTime) as nvarchar) ORDER BY EOMonth(ActivityDateTime) desc
GROUP BY EOMonth(ActivityDateTime), [Tag], DateName(Month,ActivityDateTime) + ' ' + cast(YEAR(ActivityDateTime) as nvarchar) ORDER BY EOMonth(ActivityDateTime) desc
Report Name - Digital Access API TXR run usage
SQL Query:
Select Top (100) Percent DateName(Month, RPT_TransactionRoiView.ActivityDateTime) + ' ' + Cast(Year(RPT_TransactionRoiView.ActivityDateTime) As nvarchar) AS 'Execution Month', RPT_TransactionRoiView.Tag AS 'Category',Sum(RPT_TransactionRoiView.RecordsUploaded) + Sum(RPT_TransactionRoiView.RunErrors) AS 'Records Uploaded' From [dbo].[RPT_TransactionRoiView] Where OperationType = 'Run' and ProcessSource = 'PE_API'
GROUP BY EOMonth(ActivityDateTime), [Tag], DateName(Month,ActivityDateTime) + ' ' + cast(YEAR(ActivityDateTime) as nvarchar) ORDER BY EOMonth(ActivityDateTime) desc
GROUP BY EOMonth(ActivityDateTime), [Tag], DateName(Month,ActivityDateTime) + ' ' + cast(YEAR(ActivityDateTime) as nvarchar) ORDER BY EOMonth(ActivityDateTime) desc
Comments
0 comments
Please sign in to leave a comment.