Transportation Intelligence

System Dashboard

This System Dashboard displays the ETL status of hdowner tables in the database.

The report for this dashboard is located in the catalog in Shared Folders/FTI Reports/_portal/System Dashboard

The Network Dashboard uses the following prompt:

The following explains the tabs found on the System Dashboard.

Load Log

This report displays the logs of all loaded TI tables in hdowner.

The report for this section is located in the catalog in /Shared Folders/FTI Reports/_portal/System Dashboard/Load Log

Column

Metadata Mapping

Load ID

"- Load Log Dimensions"."Load ID"

Table Name

"- Load Log Dimensions"."Table Name"

Table Start Time

"- Load Log Dimensions"."Table Start Time"

Table End Time

"- Load Log Dimensions"."Table End Time"

Load Status

"- Load Log Dimensions"."Load Status"

Number Of Records

"- Load Log Facts"."Record Count"

Load Duration(s)

"- Load Log Facts"."Load Duration(s)"

Previous Success Load Time

"- Load Log Dimensions"."Previous Success Load Time"

ETL Start Time

"- Load Log Dimensions"."ETL Start Time"

 

Load Rejects

This report displays the logs of all tables which throws error while ETL runs in hdowner.

The report for this section is located in the catalog in /Shared Folders/FTI Reports/_portal/System Dashboard/Load Rejects

Metric

Metadata Mapping

Table Name

"- Load Reject Dimensions"."Table Name"

Error Message

"- Load Reject Dimensions"."Error Message"

Reject Date

"- Load Reject Dimensions"."Reject Date"

Object GID

"- Load Reject Dimensions"."Object GID"

 

Related Topics