SAP (All Report Groups) Aggregation Information

StagedTable_Aggregation ColumnType ColumnName ColumnLabel Statistic Weight ColumnFormat ColumnNotes
SAPSYS - DayHourSystem Class SYSTEM SystemId none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
    HOUR Hour none none 2.0  
  Id WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric COMMITTTOT CommitTimeSum SUM none TIME12.2  
    CPUTI CpuCaptureTimeWMean WMEAN TRANCNT TIME12.2  
    CPUTITOT CpuCaptureTimeSum SUM none TIME12.2 Ranked
    DBRECRQ DatabaseRecordRequestsWMean WMEAN TRANCNT NLNUM16.2  
    DBRECRQTOT DatabaseRecordRequestsSum SUM none NLNUM16.0 Ranked
    DBREQTM DatabaseRequestTimeWMean WMEAN TRANCNT TIME12.2  
    DBREQTMTOT DatabaseRequestTimeSum SUM none TIME12.2 Ranked
    DELCNTTOT DeleteRequestsSum SUM none NLNUM16.0  
    DELRECTOT DeleteRecordRequestsSum SUM none NLNUM16.0  
    DELTITOT DeleteRequestTimeSum SUM none TIME12.2  
    DURATION DurationSum SUM none TIME8.  
    INSCNTTOT InsertRequestsSum SUM none NLNUM16.0  
    INSRECTOT InsertRecordRequestsSum SUM none NLNUM16.0  
    INSTITOT InsertRequestTimeSum SUM none TIME12.2  
    KBTRANS TransferredKBWMean WMEAN TRANCNT NLNUM16.2  
    KBTRANSTOT TransferredKBSum SUM none NLNUM16.0 Ranked
    LAPTIME ElapsedTimeWMean WMEAN TRANCNT TIME12.2  
    LAPTIMETOT ElapsedTimeSum SUM none TIME12.2 Ranked
    LOCKCNTTOT LockCountSum SUM none NLNUM16.0  
    OVRHEAD OverheadTimeWMean WMEAN TRANCNT TIME12.2  
    OVRHEADTOT OverheadTimeSum SUM none TIME12.2  
    PHDELCNTOT PhysicalRecordsDeletedSum SUM none NLNUM16.0  
    PHUPDCNTOT PhysicalRecordsUpdatedSum SUM none NLNUM16.0  
    PHYINCNTOT PhysicalRecordsInsertedSum SUM none NLNUM16.0  
    PHYRDCNTOT PhysicalRecordsReadSum SUM none NLNUM16.0  
    PROCTM ProcessingTimeWMean WMEAN TRANCNT TIME12.2  
    PROCTMTOT ProcessingTimeSum SUM none TIME12.2  
    QUEUETI WaitTimeWMean WMEAN TRANCNT TIME12.2  
    QUEUETITOT WaitTimeSum SUM none TIME12.2  
    RDIRBUFTOT DirectBufferReadsSum SUM none NLNUM16.0  
    RDIRCNTTOT DirectReadsSum SUM none NLNUM16.0  
    RDIRRECTOT DirectRecordRequestsSum SUM none NLNUM16.0  
    RDIRTITOT DirectReadTimeSum SUM none TIME12.2  
    RDSEQBUTOT SequentialBufferReadsSum SUM none NLNUM16.0  
    RDSEQCNTOT SequentialReadsSum SUM none NLNUM16.0  
    RDSEQRETOT SequentialRecordRequestsSum SUM none NLNUM16.0  
    RDSEQTITOT SequentialReadTimeSum SUM none TIME12.2  
    RESPTM ResponseTimeWMean WMEAN TRANCNT TIME12.2  
    RESPTMTOT ResponseTimeSum SUM none TIME12.2 Ranked
    RFCTI RfcInterfaceTimeWMean WMEAN TRANCNT TIME12.2  
    RFCTITOT RfcInterfaceTimeSum SUM none TIME12.2  
    TOTDBAC DatabasePhysicalAccessesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBACTOT DatabasePhysicalAccessesSum SUM none NLNUM16.0 Ranked
    TOTDBCH DatabasePhysicalChangesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBCHTOT DatabasePhysicalChangesSum SUM none NLNUM16.0 Ranked
    TOTDBRE DatabaseRequestsWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBRETOT DatabaseRequestsSum SUM none NLNUM16.0  
    TRANCNT TransCountSum SUM none NLNUM16.0 Ranked
    UPDCNTTOT UpdateRequestsSum SUM none NLNUM16.0  
    UPDRECTOT UpdateRecordRequestsSum SUM none NLNUM16.0  
    UPDTITOT UpdateRequestTimeSum SUM none TIME12.2  
  Computed DAYDATEHOUR DayDateHour none none DATETIME12.0 dhms(DAYDATE,HOUR,0,0)
    DBRECDELETEPCT DatabaseRecordsDeletePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDELETEPCT=(DELRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDELETEPCT=.;
    DBRECDIRREADPCT DatabaseRecordsDirectReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDIRREADPCT=(RDIRRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDIRREADPCT=.;
    DBRECINSERTPCT DatabaseRecordsInsertPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECINSERTPCT=(INSRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECINSERTPCT=.;
    DBRECSEQREADPCT DatabaseRecordsSequentialReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECSEQREADPCT=(RDSEQRETOTSUM/DBRECRQTOTSUM)*100; else DBRECSEQREADPCT=.;
    DBRECUPDATEPCT DatabaseRecordsUpdatePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECUPDATEPCT=(UPDRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECUPDATEPCT=.;
    DBREQDELETEPCT DatabaseRequestsDeletePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDELETEPCT=(DELCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDELETEPCT=.;
    DBREQDIRREADPCT DatabaseRequestsDirectReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDIRREADPCT=(RDIRCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDIRREADPCT=.;
    DBREQINSERTPCT DatabaseRequestsInsertPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQINSERTPCT=(INSCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQINSERTPCT=.;
    DBREQSEQREADPCT DatabaseRequestsSequentialReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQSEQREADPCT=(RDSEQCNTOTSUM/TOTDBRETOTSUM)*100; else DBREQSEQREADPCT=.;
    DBREQTMCOMMITPCT DatabaseRequestTimeCommitPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMCOMMITPCT=(COMMITTTOTSUM/DBREQTMTOTSUM)*100; else DBREQTMCOMMITPCT=.;
    DBREQTMDELETEPCT DatabaseRequestTimeDeletePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDELETEPCT=(DELTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDELETEPCT=.;
    DBREQTMDIRREADPCT DatabaseRequestTimeDirectReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDIRREADPCT=(RDIRTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDIRREADPCT=.;
    DBREQTMINSERTPCT DatabaseRequestTimeInsertPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMINSERTPCT=(INSTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMINSERTPCT=.;
    DBREQTMSEQREADPCT DatabaseRequestTimeSequentialReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMSEQREADPCT=(RDSEQTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMSEQREADPCT=.;
    DBREQTMUPDATEPCT DatabaseRequestTimeUpdatePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMUPDATEPCT=(UPDTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMUPDATEPCT=.;
    DBREQUPDATEPCT DatabaseRequestsUpdatePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQUPDATEPCT=(UPDCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQUPDATEPCT=.;
    LAPTIMEACTIVEPCT ElapsedTimeActivePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEACTIVEPCT=(RESPTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEACTIVEPCT=.;
    LAPTIMEDBPCT ElapsedTimeDatabasePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEDBPCT=(DBREQTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEDBPCT=.;
    PHYDELETEPCT DatabasePhysicalDeletePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYDELETEPCT=(PHDELCNTOTSUM/TOTDBACTOTSUM)*100; else PHYDELETEPCT=.;
    PHYINSERTPCT DatabasePhysicalInsertPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYINSERTPCT =(PHYINCNTOTSUM/TOTDBACTOTSUM)*100; else PHYINSERTPCT=.;
    PHYREADPCT DatabasePhysicalReadPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYREADPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYREADPCT=.;
    PHYUPDATEPCT DatabasePhysicalUpdatePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYUPDATEPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYUPDATEPCT=.;
SAPSYS - DaySystem Class SYSTEM SystemId none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric COMMITTTOT CommitTimeSum SUM none TIME12.2  
    CPUTI CpuCaptureTimeWMean WMEAN TRANCNT TIME12.2  
    CPUTITOT CpuCaptureTimeSum SUM none TIME12.2 Ranked
    DBRECRQ DatabaseRecordRequestsWMean WMEAN TRANCNT NLNUM16.2  
    DBRECRQTOT DatabaseRecordRequestsSum SUM none NLNUM16.0 Ranked
    DBREQTM DatabaseRequestTimeWMean WMEAN TRANCNT TIME12.2  
    DBREQTMTOT DatabaseRequestTimeSum SUM none TIME12.2 Ranked
    DELCNTTOT DeleteRequestsSum SUM none NLNUM16.0  
    DELRECTOT DeleteRecordRequestsSum SUM none NLNUM16.0  
    DELTITOT DeleteRequestTimeSum SUM none TIME12.2  
    DURATION DurationSum SUM none TIME8.  
    INSCNTTOT InsertRequestsSum SUM none NLNUM16.0  
    INSRECTOT InsertRecordRequestsSum SUM none NLNUM16.0  
    INSTITOT InsertRequestTimeSum SUM none TIME12.2  
    KBTRANS TransferredKBWMean WMEAN TRANCNT NLNUM16.2  
    KBTRANSTOT TransferredKBSum SUM none NLNUM16.0 Ranked
    LAPTIME ElapsedTimeWMean WMEAN TRANCNT TIME12.2  
    LAPTIMETOT ElapsedTimeSum SUM none TIME12.2 Ranked
    LOCKCNTTOT LockCountSum SUM none NLNUM16.0  
    OVRHEAD OverheadTimeWMean WMEAN TRANCNT TIME12.2  
    OVRHEADTOT OverheadTimeSum SUM none TIME12.2  
    PHDELCNTOT PhysicalRecordsDeletedSum SUM none NLNUM16.0  
    PHUPDCNTOT PhysicalRecordsUpdatedSum SUM none NLNUM16.0  
    PHYINCNTOT PhysicalRecordsInsertedSum SUM none NLNUM16.0  
    PHYRDCNTOT PhysicalRecordsReadSum SUM none NLNUM16.0  
    PROCTM ProcessingTimeWMean WMEAN TRANCNT TIME12.2  
    PROCTMTOT ProcessingTimeSum SUM none TIME12.2  
    QUEUETI WaitTimeWMean WMEAN TRANCNT TIME12.2  
    QUEUETITOT WaitTimeSum SUM none TIME12.2  
    RDIRBUFTOT DirectBufferReadsSum SUM none NLNUM16.0  
    RDIRCNTTOT DirectReadsSum SUM none NLNUM16.0  
    RDIRRECTOT DirectRecordRequestsSum SUM none NLNUM16.0  
    RDIRTITOT DirectReadTimeSum SUM none TIME12.2  
    RDSEQBUTOT SequentialBufferReadsSum SUM none NLNUM16.0  
    RDSEQCNTOT SequentialReadsSum SUM none NLNUM16.0  
    RDSEQRETOT SequentialRecordRequestsSum SUM none NLNUM16.0  
    RDSEQTITOT SequentialReadTimeSum SUM none TIME12.2  
    RESPTM ResponseTimeWMean WMEAN TRANCNT TIME12.2  
    RESPTMTOT ResponseTimeSum SUM none TIME12.2 Ranked
    RFCTI RfcInterfaceTimeWMean WMEAN TRANCNT TIME12.2  
    RFCTITOT RfcInterfaceTimeSum SUM none TIME12.2  
    TOTDBAC DatabasePhysicalAccessesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBACTOT DatabasePhysicalAccessesSum SUM none NLNUM16.0 Ranked
    TOTDBCH DatabasePhysicalChangesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBCHTOT DatabasePhysicalChangesSum SUM none NLNUM16.0 Ranked
    TOTDBRE DatabaseRequestsWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBRETOT DatabaseRequestsSum SUM none NLNUM16.0  
    TRANCNT TransCountSum SUM none NLNUM16.0 Ranked
    UPDCNTTOT UpdateRequestsSum SUM none NLNUM16.0  
    UPDRECTOT UpdateRecordRequestsSum SUM none NLNUM16.0  
    UPDTITOT UpdateRequestTimeSum SUM none TIME12.2  
  Computed DBRECDELETEPCT DatabaseRecordsDeletePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDELETEPCT=(DELRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDELETEPCT=.;
    DBRECDIRREADPCT DatabaseRecordsDirectReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDIRREADPCT=(RDIRRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDIRREADPCT=.;
    DBRECINSERTPCT DatabaseRecordsInsertPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECINSERTPCT=(INSRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECINSERTPCT=.;
    DBRECSEQREADPCT DatabaseRecordsSequentialReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECSEQREADPCT=(RDSEQRETOTSUM/DBRECRQTOTSUM)*100; else DBRECSEQREADPCT=.;
    DBRECUPDATEPCT DatabaseRecordsUpdatePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECUPDATEPCT=(UPDRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECUPDATEPCT=.;
    DBREQDELETEPCT DatabaseRequestsDeletePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDELETEPCT=(DELCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDELETEPCT=.;
    DBREQDIRREADPCT DatabaseRequestsDirectReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDIRREADPCT=(RDIRCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDIRREADPCT=.;
    DBREQINSERTPCT DatabaseRequestsInsertPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQINSERTPCT=(INSCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQINSERTPCT=.;
    DBREQSEQREADPCT DatabaseRequestsSequentialReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQSEQREADPCT=(RDSEQCNTOTSUM/TOTDBRETOTSUM)*100; else DBREQSEQREADPCT=.;
    DBREQTMCOMMITPCT DatabaseRequestTimeCommitPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMCOMMITPCT=(COMMITTTOTSUM/DBREQTMTOTSUM)*100; else DBREQTMCOMMITPCT=.;
    DBREQTMDELETEPCT DatabaseRequestTimeDeletePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDELETEPCT=(DELTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDELETEPCT=.;
    DBREQTMDIRREADPCT DatabaseRequestTimeDirectReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDIRREADPCT=(RDIRTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDIRREADPCT=.;
    DBREQTMINSERTPCT DatabaseRequestTimeInsertPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMINSERTPCT=(INSTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMINSERTPCT=.;
    DBREQTMSEQREADPCT DatabaseRequestTimeSequentialReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMSEQREADPCT=(RDSEQTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMSEQREADPCT=.;
    DBREQTMUPDATEPCT DatabaseRequestTimeUpdatePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMUPDATEPCT=(UPDTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMUPDATEPCT=.;
    DBREQUPDATEPCT DatabaseRequestsUpdatePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQUPDATEPCT=(UPDCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQUPDATEPCT=.;
    LAPTIMEACTIVEPCT ElapsedTimeActivePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEACTIVEPCT=(RESPTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEACTIVEPCT=.;
    LAPTIMEDBPCT ElapsedTimeDatabasePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEDBPCT=(DBREQTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEDBPCT=.;
    PHYDELETEPCT DatabasePhysicalDeletePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYDELETEPCT=(PHDELCNTOTSUM/TOTDBACTOTSUM)*100; else PHYDELETEPCT=.;
    PHYINSERTPCT DatabasePhysicalInsertPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYINSERTPCT =(PHYINCNTOTSUM/TOTDBACTOTSUM)*100; else PHYINSERTPCT=.;
    PHYREADPCT DatabasePhysicalReadPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYREADPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYREADPCT=.;
    PHYUPDATEPCT DatabasePhysicalUpdatePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYUPDATEPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYUPDATEPCT=.;
SAPSYS - MonthHourSystem Class SYSTEM SystemId none none none  
    MONTHDATE MonthDate none none NLDATE10. Ranked
    HOUR Hour none none 2.0  
  Metric COMMITTTOT CommitTimeSum SUM none TIME12.2  
    CPUTI CpuCaptureTimeWMean WMEAN TRANCNT TIME12.2  
    CPUTITOT CpuCaptureTimeSum SUM none TIME12.2 Ranked
    DBRECRQ DatabaseRecordRequestsWMean WMEAN TRANCNT NLNUM16.2  
    DBRECRQTOT DatabaseRecordRequestsSum SUM none NLNUM16.0 Ranked
    DBREQTM DatabaseRequestTimeWMean WMEAN TRANCNT TIME12.2  
    DBREQTMTOT DatabaseRequestTimeSum SUM none TIME12.2 Ranked
    DELCNTTOT DeleteRequestsSum SUM none NLNUM16.0  
    DELRECTOT DeleteRecordRequestsSum SUM none NLNUM16.0  
    DELTITOT DeleteRequestTimeSum SUM none TIME12.2  
    DURATION DurationSum SUM none TIME8.  
    INSCNTTOT InsertRequestsSum SUM none NLNUM16.0  
    INSRECTOT InsertRecordRequestsSum SUM none NLNUM16.0  
    INSTITOT InsertRequestTimeSum SUM none TIME12.2  
    KBTRANS TransferredKBWMean WMEAN TRANCNT NLNUM16.2  
    KBTRANSTOT TransferredKBSum SUM none NLNUM16.0 Ranked
    LAPTIME ElapsedTimeWMean WMEAN TRANCNT TIME12.2  
    LAPTIMETOT ElapsedTimeSum SUM none TIME12.2 Ranked
    LOCKCNTTOT LockCountSum SUM none NLNUM16.0  
    OVRHEAD OverheadTimeWMean WMEAN TRANCNT TIME12.2  
    OVRHEADTOT OverheadTimeSum SUM none TIME12.2  
    PHDELCNTOT PhysicalRecordsDeletedSum SUM none NLNUM16.0  
    PHUPDCNTOT PhysicalRecordsUpdatedSum SUM none NLNUM16.0  
    PHYINCNTOT PhysicalRecordsInsertedSum SUM none NLNUM16.0  
    PHYRDCNTOT PhysicalRecordsReadSum SUM none NLNUM16.0  
    PROCTM ProcessingTimeWMean WMEAN TRANCNT TIME12.2  
    PROCTMTOT ProcessingTimeSum SUM none TIME12.2  
    QUEUETI WaitTimeWMean WMEAN TRANCNT TIME12.2  
    QUEUETITOT WaitTimeSum SUM none TIME12.2  
    RDIRBUFTOT DirectBufferReadsSum SUM none NLNUM16.0  
    RDIRCNTTOT DirectReadsSum SUM none NLNUM16.0  
    RDIRRECTOT DirectRecordRequestsSum SUM none NLNUM16.0  
    RDIRTITOT DirectReadTimeSum SUM none TIME12.2  
    RDSEQBUTOT SequentialBufferReadsSum SUM none NLNUM16.0  
    RDSEQCNTOT SequentialReadsSum SUM none NLNUM16.0  
    RDSEQRETOT SequentialRecordRequestsSum SUM none NLNUM16.0  
    RDSEQTITOT SequentialReadTimeSum SUM none TIME12.2  
    RESPTM ResponseTimeWMean WMEAN TRANCNT TIME12.2  
    RESPTMTOT ResponseTimeSum SUM none TIME12.2 Ranked
    RFCTI RfcInterfaceTimeWMean WMEAN TRANCNT TIME12.2  
    RFCTITOT RfcInterfaceTimeSum SUM none TIME12.2  
    TOTDBAC DatabasePhysicalAccessesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBACTOT DatabasePhysicalAccessesSum SUM none NLNUM16.0 Ranked
    TOTDBCH DatabasePhysicalChangesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBCHTOT DatabasePhysicalChangesSum SUM none NLNUM16.0 Ranked
    TOTDBRE DatabaseRequestsWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBRETOT DatabaseRequestsSum SUM none NLNUM16.0  
    TRANCNT TransCountSum SUM none NLNUM16.0 Ranked
    UPDCNTTOT UpdateRequestsSum SUM none NLNUM16.0  
    UPDRECTOT UpdateRecordRequestsSum SUM none NLNUM16.0  
    UPDTITOT UpdateRequestTimeSum SUM none TIME12.2  
  Computed DBRECDELETEPCT DatabaseRecordsDeletePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDELETEPCT=(DELRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDELETEPCT=.;
    DBRECDIRREADPCT DatabaseRecordsDirectReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDIRREADPCT=(RDIRRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDIRREADPCT=.;
    DBRECINSERTPCT DatabaseRecordsInsertPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECINSERTPCT=(INSRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECINSERTPCT=.;
    DBRECSEQREADPCT DatabaseRecordsSequentialReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECSEQREADPCT=(RDSEQRETOTSUM/DBRECRQTOTSUM)*100; else DBRECSEQREADPCT=.;
    DBRECUPDATEPCT DatabaseRecordsUpdatePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECUPDATEPCT=(UPDRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECUPDATEPCT=.;
    DBREQDELETEPCT DatabaseRequestsDeletePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDELETEPCT=(DELCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDELETEPCT=.;
    DBREQDIRREADPCT DatabaseRequestsDirectReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDIRREADPCT=(RDIRCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDIRREADPCT=.;
    DBREQINSERTPCT DatabaseRequestsInsertPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQINSERTPCT=(INSCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQINSERTPCT=.;
    DBREQSEQREADPCT DatabaseRequestsSequentialReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQSEQREADPCT=(RDSEQCNTOTSUM/TOTDBRETOTSUM)*100; else DBREQSEQREADPCT=.;
    DBREQTMCOMMITPCT DatabaseRequestTimeCommitPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMCOMMITPCT=(COMMITTTOTSUM/DBREQTMTOTSUM)*100; else DBREQTMCOMMITPCT=.;
    DBREQTMDELETEPCT DatabaseRequestTimeDeletePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDELETEPCT=(DELTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDELETEPCT=.;
    DBREQTMDIRREADPCT DatabaseRequestTimeDirectReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDIRREADPCT=(RDIRTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDIRREADPCT=.;
    DBREQTMINSERTPCT DatabaseRequestTimeInsertPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMINSERTPCT=(INSTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMINSERTPCT=.;
    DBREQTMSEQREADPCT DatabaseRequestTimeSequentialReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMSEQREADPCT=(RDSEQTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMSEQREADPCT=.;
    DBREQTMUPDATEPCT DatabaseRequestTimeUpdatePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMUPDATEPCT=(UPDTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMUPDATEPCT=.;
    DBREQUPDATEPCT DatabaseRequestsUpdatePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQUPDATEPCT=(UPDCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQUPDATEPCT=.;
    LAPTIMEACTIVEPCT ElapsedTimeActivePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEACTIVEPCT=(RESPTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEACTIVEPCT=.;
    LAPTIMEDBPCT ElapsedTimeDatabasePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEDBPCT=(DBREQTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEDBPCT=.;
    MONTHDATEHOUR MonthDateHour none none DATETIME12.0 dhms(MONTHDATE,HOUR,0,0)
    PHYDELETEPCT DatabasePhysicalDeletePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYDELETEPCT=(PHDELCNTOTSUM/TOTDBACTOTSUM)*100; else PHYDELETEPCT=.;
    PHYINSERTPCT DatabasePhysicalInsertPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYINSERTPCT =(PHYINCNTOTSUM/TOTDBACTOTSUM)*100; else PHYINSERTPCT=.;
    PHYREADPCT DatabasePhysicalReadPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYREADPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYREADPCT=.;
    PHYUPDATEPCT DatabasePhysicalUpdatePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYUPDATEPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYUPDATEPCT=.;
SAPSYS - MonthSystem Class SYSTEM SystemId none none none  
    MONTHDATE MonthDate none none NLDATE10. Ranked
  Metric COMMITTTOT CommitTimeSum SUM none TIME12.2  
    CPUTI CpuCaptureTimeWMean WMEAN TRANCNT TIME12.2  
    CPUTITOT CpuCaptureTimeSum SUM none TIME12.2 Ranked
    DBRECRQ DatabaseRecordRequestsWMean WMEAN TRANCNT NLNUM16.2  
    DBRECRQTOT DatabaseRecordRequestsSum SUM none NLNUM16.0 Ranked
    DBREQTM DatabaseRequestTimeWMean WMEAN TRANCNT TIME12.2  
    DBREQTMTOT DatabaseRequestTimeSum SUM none TIME12.2 Ranked
    DELCNTTOT DeleteRequestsSum SUM none NLNUM16.0  
    DELRECTOT DeleteRecordRequestsSum SUM none NLNUM16.0  
    DELTITOT DeleteRequestTimeSum SUM none TIME12.2  
    DURATION DurationSum SUM none TIME8.  
    INSCNTTOT InsertRequestsSum SUM none NLNUM16.0  
    INSRECTOT InsertRecordRequestsSum SUM none NLNUM16.0  
    INSTITOT InsertRequestTimeSum SUM none TIME12.2  
    KBTRANS TransferredKBWMean WMEAN TRANCNT NLNUM16.2  
    KBTRANSTOT TransferredKBSum SUM none NLNUM16.0 Ranked
    LAPTIME ElapsedTimeWMean WMEAN TRANCNT TIME12.2  
    LAPTIMETOT ElapsedTimeSum SUM none TIME12.2 Ranked
    LOCKCNTTOT LockCountSum SUM none NLNUM16.0  
    OVRHEAD OverheadTimeWMean WMEAN TRANCNT TIME12.2  
    OVRHEADTOT OverheadTimeSum SUM none TIME12.2  
    PHDELCNTOT PhysicalRecordsDeletedSum SUM none NLNUM16.0  
    PHUPDCNTOT PhysicalRecordsUpdatedSum SUM none NLNUM16.0  
    PHYINCNTOT PhysicalRecordsInsertedSum SUM none NLNUM16.0  
    PHYRDCNTOT PhysicalRecordsReadSum SUM none NLNUM16.0  
    PROCTM ProcessingTimeWMean WMEAN TRANCNT TIME12.2  
    PROCTMTOT ProcessingTimeSum SUM none TIME12.2  
    QUEUETI WaitTimeWMean WMEAN TRANCNT TIME12.2  
    QUEUETITOT WaitTimeSum SUM none TIME12.2  
    RDIRBUFTOT DirectBufferReadsSum SUM none NLNUM16.0  
    RDIRCNTTOT DirectReadsSum SUM none NLNUM16.0  
    RDIRRECTOT DirectRecordRequestsSum SUM none NLNUM16.0  
    RDIRTITOT DirectReadTimeSum SUM none TIME12.2  
    RDSEQBUTOT SequentialBufferReadsSum SUM none NLNUM16.0  
    RDSEQCNTOT SequentialReadsSum SUM none NLNUM16.0  
    RDSEQRETOT SequentialRecordRequestsSum SUM none NLNUM16.0  
    RDSEQTITOT SequentialReadTimeSum SUM none TIME12.2  
    RESPTM ResponseTimeWMean WMEAN TRANCNT TIME12.2  
    RESPTMTOT ResponseTimeSum SUM none TIME12.2 Ranked
    RFCTI RfcInterfaceTimeWMean WMEAN TRANCNT TIME12.2  
    RFCTITOT RfcInterfaceTimeSum SUM none TIME12.2  
    TOTDBAC DatabasePhysicalAccessesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBACTOT DatabasePhysicalAccessesSum SUM none NLNUM16.0 Ranked
    TOTDBCH DatabasePhysicalChangesWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBCHTOT DatabasePhysicalChangesSum SUM none NLNUM16.0 Ranked
    TOTDBRE DatabaseRequestsWMean WMEAN TRANCNT NLNUM16.2  
    TOTDBRETOT DatabaseRequestsSum SUM none NLNUM16.0  
    TRANCNT TransCountSum SUM none NLNUM16.0 Ranked
    UPDCNTTOT UpdateRequestsSum SUM none NLNUM16.0  
    UPDRECTOT UpdateRecordRequestsSum SUM none NLNUM16.0  
    UPDTITOT UpdateRequestTimeSum SUM none TIME12.2  
  Computed DBRECDELETEPCT DatabaseRecordsDeletePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDELETEPCT=(DELRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDELETEPCT=.;
    DBRECDIRREADPCT DatabaseRecordsDirectReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECDIRREADPCT=(RDIRRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECDIRREADPCT=.;
    DBRECINSERTPCT DatabaseRecordsInsertPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECINSERTPCT=(INSRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECINSERTPCT=.;
    DBRECSEQREADPCT DatabaseRecordsSequentialReadPct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECSEQREADPCT=(RDSEQRETOTSUM/DBRECRQTOTSUM)*100; else DBRECSEQREADPCT=.;
    DBRECUPDATEPCT DatabaseRecordsUpdatePct none none NLNUM6.2 if DBRECRQTOTSUM gt 0 then DBRECUPDATEPCT=(UPDRECTOTSUM/DBRECRQTOTSUM)*100; else DBRECUPDATEPCT=.;
    DBREQDELETEPCT DatabaseRequestsDeletePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDELETEPCT=(DELCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDELETEPCT=.;
    DBREQDIRREADPCT DatabaseRequestsDirectReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQDIRREADPCT=(RDIRCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQDIRREADPCT=.;
    DBREQINSERTPCT DatabaseRequestsInsertPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQINSERTPCT=(INSCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQINSERTPCT=.;
    DBREQSEQREADPCT DatabaseRequestsSequentialReadPct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQSEQREADPCT=(RDSEQCNTOTSUM/TOTDBRETOTSUM)*100; else DBREQSEQREADPCT=.;
    DBREQTMCOMMITPCT DatabaseRequestTimeCommitPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMCOMMITPCT=(COMMITTTOTSUM/DBREQTMTOTSUM)*100; else DBREQTMCOMMITPCT=.;
    DBREQTMDELETEPCT DatabaseRequestTimeDeletePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDELETEPCT=(DELTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDELETEPCT=.;
    DBREQTMDIRREADPCT DatabaseRequestTimeDirectReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMDIRREADPCT=(RDIRTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMDIRREADPCT=.;
    DBREQTMINSERTPCT DatabaseRequestTimeInsertPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMINSERTPCT=(INSTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMINSERTPCT=.;
    DBREQTMSEQREADPCT DatabaseRequestTimeSequentialReadPct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMSEQREADPCT=(RDSEQTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMSEQREADPCT=.;
    DBREQTMUPDATEPCT DatabaseRequestTimeUpdatePct none none NLNUM6.2 if DBREQTMTOTSUM gt 0 then DBREQTMUPDATEPCT=(UPDTITOTSUM/DBREQTMTOTSUM)*100; else DBREQTMUPDATEPCT=.;
    DBREQUPDATEPCT DatabaseRequestsUpdatePct none none NLNUM6.2 if TOTDBRETOTSUM gt 0 then DBREQUPDATEPCT=(UPDCNTTOTSUM/TOTDBRETOTSUM)*100; else DBREQUPDATEPCT=.;
    LAPTIMEACTIVEPCT ElapsedTimeActivePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEACTIVEPCT=(RESPTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEACTIVEPCT=.;
    LAPTIMEDBPCT ElapsedTimeDatabasePct none none NLNUM6.2 if LAPTIMETOTSUM gt 0 then LAPTIMEDBPCT=(DBREQTMTOTSUM/LAPTIMETOTSUM)*100; else LAPTIMEDBPCT=.;
    PHYDELETEPCT DatabasePhysicalDeletePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYDELETEPCT=(PHDELCNTOTSUM/TOTDBACTOTSUM)*100; else PHYDELETEPCT=.;
    PHYINSERTPCT DatabasePhysicalInsertPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYINSERTPCT =(PHYINCNTOTSUM/TOTDBACTOTSUM)*100; else PHYINSERTPCT=.;
    PHYREADPCT DatabasePhysicalReadPct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYREADPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYREADPCT=.;
    PHYUPDATEPCT DatabasePhysicalUpdatePct none none NLNUM6.2 if TOTDBACTOTSUM gt 0 then PHYUPDATEPCT=(PHYRDCNTOTSUM/TOTDBACTOTSUM)*100; else PHYUPDATEPCT=.;
SAPSYS - WeekHourSystem Class SYSTEM SystemId none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    HOUR Hour none none 2.0  
  Metric COMMITTTOT CommitTimeSum SUM none TIME12.2  
    CPUTI CpuCaptureTimeWMean WMEAN TRANCNT TIME12.2  
    CPUTITOT CpuCaptureTimeSum SUM none TIME12.2 Ranked
    DBRECRQ DatabaseRecordRequestsWMean WMEAN TRANCNT NLNUM16.2  
    DBRECRQTOT DatabaseRecordRequestsSum SUM none NLNUM16.0 Ranked
    DBREQTM DatabaseRequestTimeWMean WMEAN TRANCNT TIME12.2  
    DBREQTMTOT DatabaseRequestTimeSum SUM none TIME12.2 Ranked
    DELCNTTOT DeleteRequestsSum SUM none NLNUM16.0  
    DELRECTOT DeleteRecordRequestsSum SUM none NLNUM16.0  
    DELTITOT DeleteRequestTimeSum SUM none TIME12.2  
    DURATION DurationSum SUM none TIME8.  
    INSCNTTOT InsertRequestsSum SUM none NLNUM16.0  
    INSRECTOT InsertRecordRequestsSum SUM none NLNUM16.0  
    INSTITOT InsertRequestTimeSum SUM none TIME12.2  
    KBTRANS TransferredKBWMean WMEAN TRANCNT NLNUM16.2  
    KBTRANSTOT TransferredKBSum SUM none NLNUM16.0 Ranked
    LAPTIME ElapsedTimeWMean WMEAN TRANCNT TIME12.2  
    LAPTIMETOT ElapsedTimeSum SUM none TIME12.2 Ranked
    LOCKCNTTOT LockCountSum SUM none NLNUM16.0  
    OVRHEAD OverheadTimeWMean WMEAN TRANCNT TIME12.2  
    OVRHEADTOT OverheadTimeSum SUM none TIME12.2  
    PHDELCNTOT PhysicalRecordsDeletedSum SUM none NLNUM16.0  
    PHUPDCNTOT PhysicalRecordsUpdatedSum SUM none NLNUM16.0  
    PHYINCNTOT PhysicalRecordsInsertedSum SUM none NLNUM16.0  
    PHYRDCNTOT PhysicalRecordsReadSum SUM none NLNUM16.0  
    PROCTM ProcessingTimeWMean WMEAN TRANCNT TIME12.2  
    PROCTMTOT ProcessingTimeSum SUM none TIME12.2  
    QUEUETI WaitTimeWMean WMEAN TRANCNT TIME12.2  
    QUEUETITOT WaitTimeSum SUM none TIME12.2  
    RDIRBUFTOT DirectBufferReadsSum SUM none NLNUM16.0  
    RDIRCNTTOT DirectReadsSum SUM none NLNUM16.0  
    RDIRRECTOT DirectRecordRequestsSum SUM none NLNUM16.0  
    RDIRTITOT DirectReadTimeSum SUM none TIME12.2  
    RDSEQBUTOT SequentialBufferReadsSum SUM none NLNUM16.0  
    RDSEQCNTOT SequentialReadsSum SUM none NLNUM16.0  
    RDSEQRETOT SequentialRecordRequestsSum SUM none NLNUM16.0  
    RDSEQTITOT SequentialReadTimeSum SUM none TIME12.2  
    RESPTM ResponseTimeWMean WMEAN TRANCNT TIME12.2  
    RESPTMTOT ResponseTimeSum SUM none TIME12.2 Ranked
    RFCTI RfcInterfaceTimeWMean WMEAN TRANCNT TIME12.2  
    RFCTITOT RfcInterfaceTimeSum SUM none TIME12.2  
    TOTDBAC DatabasePhysicalAccessesWMean WMEAN TRANCNT NLNUM16