Show TOC

E2E Reporting: Database Availability Locate this document in the navigation structure

Query Query: 0E2EREP_DBPING_DETAIL

 

This query is used in interactive reporting in the Technical Monitoring work center. It displays the availability for the selected database. The query is displayed in the following interactive reports:

  • Start of the navigation path ABAP Systems Next navigation step Availability Next navigation step DB Availability End of the navigation path

  • Start of the navigation path Java Systems Next navigation step Availability Next navigation step DB Availability End of the navigation path

  • Start of the navigation path Database Next navigation step Availability Next navigation step Availability End of the navigation path

The query is used in the Web Template 0E2EREP_DBPING_DETAIL (Interactive Reports: Database Availability (Detail)).

Note Note

For correct usage, this query must be used in the context of the Web template listed above. Using the query without this wrapper is not meaningful.

End of the note.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Type of Key Figure

0SMD_METY

= DB_KPI_availability_pfcl [DB_KPI_availability_pfcl]
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Calendar Day

0CALDAY

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Available

'Available (%)' / MIN( 1, CEIL( 'Available (%)' )

No Availability Measurements

'No Availability Measurements (%)' / MIN( 1, CEIL( 'No Availability Measurements (%)' )

Not Available

'Not Available (%)' / MIN( 1, CEIL( 'Not Available (%)' )

Available (%)

'Rounded Availability' * 'Proportion of Reported Values' / 100

No Availability Measurements (%)

100 - 'Proportion of Reported Values'

Not Available (%)

100 - 'Available (%)' - 'No Availability Measurements (%)'

Rounded Availability

TRUNC( ( 'Availability [0SMDAVG]' * 100 ) ) / 100

Proportion of Reported Values

MIN( 100 , ( 'Time Period [s] [0SMD_PERI]' / 'Slot Duration [0SMD_SDUR]' * 100 ) )