PEC-REP/Current/RPRT/HRCXIiWDETLAuditDshbrd - Revision history

WikiSysop at 23:04, June 29, 2022

2022-06-29T23:04:41Z

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

2020-07-25T02:33:16Z

Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"

2020-07-15T11:45:37Z

Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Tgilchri: Published

2020-06-12T14:06:30Z

Published

Bgrenon: Published

2020-06-08T14:21:32Z

Published

New page

{{ArticleUnstructured
|PageType=
|DisplayName=ETL Audit Dashboard
|Platform=PureEngage
|TocName=ETL Audit Dashboard
|Context=Track job execution statistics, including duration, status, and other critical ETL values.
}}
{{NoteFormat|This dashboard is designed to be used by administrators, and by default is visible only to members of Administrator user groups}}

Use the ('''CX Insights for iWD''' folder >) '''ETL Audit Dashboard''' to efficiently audit/analyze iWD ETL processes. The dashboard provides an overview of job execution statistics, including duration, status, and other information drawn from the ETL_AUDIT table.
[[File:HRCXIiWDETLAuditSmryIntrdy.png|thumbnail|Summary Intraday tab]]

The dashboard report organizes data on the following tabs:

*'''Summary Intraday''' tab — Use this tab to analyze job execution statistics for intraday jobs, which are jobs that run on a regular interval (every 15 minutes by default, or at user-configurable interval).
*'''Summary Historical''' tab — Use this tab to analyze job execution statistics for historical jobs, which are jobs that run on a daily basis.

[[File:HRCXIiWDETLAuditSmryHstrcl.png|thumbnail|Summary Historical tab]]
Note that the term ''dashboard'' is used interchangeably with the term ''dossier''. Dashboards provide an interactive, intuitive data visualization, summarizing key business indicators (KPIs). You can change how you view the data in most reports and dashboards by using interactive features such as selectors, grouping, widgets, and visualizations, and explore data using multiple paths, through text and data filtering, and layers of organization.

To get a better idea of what this dashboard looks like, view sample output from the report: <br />
{{Repository|SampleETLAuditDashboard.pdf||SampleETLAuditDashboard.pdf}}

The following table explains the prompts you can select when you generate the ETL Audit Dashboard:
{|
!'''Prompt'''
!'''Description'''
|+'''Prompts on the ETL Audit Dashboard'''

|-
|Start Time Min
|Choose the low filter value for the Start Time attribute.
|-
|Start Time Max
|Choose the high filter value for the Start Time attribute.
|-
|Data Source Type
|Optionally, select a data source type on which to focus the report.
|-
|Process Name
|Optionally, select a business process on which to focus the report.
|-
|Status
|Optionally, select a status on which to focus the report.
|-

|}

The following table explains the attributes used in the ETL Audit Dashboard:
{|
!'''Attribute'''
!'''Description'''
!'''Data Mart Column'''
|+'''Attributes in the ETL Audit Dashboard'''
|-
|ETL Audit Key
|Enables data to be organized based on the technical key which identifies DataMart job.
|ETL_AUDIT.ETL_AUDIT_KEY
|-
|Data Source Type
|Enables data to be organized based on the type of data source.
|V_DIM_DATA_SOURCE_TYPE.DATA_SOURCE_TYPE
|-
|Data Source Name
|Enables data to be organized based on the name of the data source.
|ETL_AUDIT.DATA_SOURCE_NAME
|-
|Process Name
|Enables data to be organized based on the process name.
|V_DIM_PROCESS_NAME.PROCESS_NAME
|-
|Status
|Enables data to be organized based on job status.
|V_DIM_STATUS.STATUS
|-
|Job Type
|Enables data to be organized based on the the type of job.
|ETL_AUDIT.JOB_TYPE
|-
|Start Time
|Enables data to be organized based on the time when the job started.
|ETL_AUDIT.ETL_AUDIT_START_TIME
|-
|Finish Time
|Enables data to be organized based on the time when the job finished.
|ETL_AUDIT.ETL_AUDIT_FINISH_TIME
|-
|Batch ID
|Enables data to be organized based on the batch number. Applicable only to jobs that process data in batches.
|ETL_AUDIT.BATCH_ID
|-
|First Extracted Event ID
|Enables data to be organized based on the ID that starts the range of event IDs that are processed.
|ETL_AUDIT.FIRST_EXTRACTED_EVENT_ID
|-
|Last Extracted Event ID
|Enables data to be organized based on the ID that ends the range of event IDs that are processed.
|ETL_AUDIT.LAST_EXTRACTED_EVENT_ID
|-
|Batch Last Event ID
|Enables data to be organized based on the lD of the last event in the batch.
|ETL_AUDIT.BATCH_LAST_EVENT_ID
|-
|Last Interval Date Key
|Enables data to be organized based on the last date interval that is processed by the aggregate ETL scripts.
|ETL_AUDIT.LAST_INTERVAL_DATE_KEY
|-
|Last Interval Time Key
|Enables data to be organized based on the last time interval that is processed by the aggregate ETL scripts.
|ETL_AUDIT.LAST_INTERVAL_TIME_KEY
|-

|}

The following table explains the metrics used in the ETL Audit Dashboard:
{|
!'''Metric'''
!'''Description'''
!'''Source or Calculation'''
|+'''Metrics in the Customer ETL Audit Dashboard'''
|-
|Duration
|The total amount number of seconds that job execution lasted. This value is calculated based on the creation timestamp for the job during the given time interval (ETL_AUDIT_START_TIME), and the finish time for the job (ETL_AUDIT_FINISH_TIME).
|ETL_AUDIT.DURATION
|-
|Extracted Events Amount
|The number of loaded events during a job or batch run.
|ETL_AUDIT.EXTRACTED_EVENTS_AMOUNT
|-
|}

@@ Line 1: / Line 1: @@
 {{ArticleUnstructured
-|PageType=
+|Standalone=No
 |DisplayName=ETL Audit Dashboard
 |Platform=GenesysEngage-cloud
@@ Line 124: / Line 124: @@
 |-
 |}
-To view more detailed information about the metrics and attributes in this report, and other metrics and attributes that can be used to customize reports, see the [https://docs.genesys.com/Documentation/GCXI/9.0.0/PG/Welcome ''Genesys CX Insights Projects Reference Guide''].
+To view more detailed information about the metrics and attributes in this report, and other metrics and attributes that can be used to customize reports, see the ''{{Link-AnywhereElse|product=PEC-REP|version=Current|manual=GCXIMCPRG|topic=IWD|display text=Genesys CX Insights Multicloud Projects Reference Guide}}''.

@@ Line 2: / Line 2: @@
 |PageType=
 |DisplayName=ETL Audit Dashboard
-|Platform=GenesysEngage-onpremises
+|Platform=GenesysEngage-cloud
 |TocName=ETL Audit Dashboard
 |Context=Track job execution statistics, including duration, status, and other critical ETL values.

@@ Line 59: / Line 59: @@
 !'''Attribute'''
 !'''Description'''
 |+'''Attributes in the ETL Audit Dashboard'''
 |-
 |ETL Audit Key
 |Enables data to be organized based on the technical key which identifies DataMart job.
 |-
 |Data Source Type
 |Enables data to be organized based on the type of data source.
 |-
 |Data Source Name
 |Enables data to be organized based on the name of the data source.
 |-
 |Process Name
 |Enables data to be organized based on the process name.
 |-
 |Status
 |Enables data to be organized based on job status.
 |-
 |Job Type
 |Enables data to be organized based on the the type of job.
 |-
 |Start Time
 |Enables data to be organized based on the time when the job started.
 |-
 |Finish Time
 |Enables data to be organized based on the time when the job finished.
 |-
 |Batch ID
 |Enables data to be organized based on the batch number. Applicable only to jobs that process data in batches.
 |-
 |First Extracted Event ID
 |Enables data to be organized based on the ID that starts the range of event IDs that are processed.
 |-
 |Last Extracted Event ID
 |Enables data to be organized based on the ID that ends the range of event IDs that are processed.
 |-
 |Batch Last Event ID
 |Enables data to be organized based on the lD of the last event in the batch.
 |-
 |Last Interval Date Key
 |Enables data to be organized based on the last date interval that is processed by the aggregate ETL scripts.
 |-
 |Last Interval Time Key
 |Enables data to be organized based on the last time interval that is processed by the aggregate ETL scripts.
 |-
 <!--
@@ Line 130: / Line 115: @@
 !'''Metric'''
 !'''Description'''
 |+'''Metrics in the Customer ETL Audit Dashboard'''
 |-
 |Duration
 |The total amount number of seconds that job execution lasted. This value is calculated based on the creation timestamp for the job during the given time interval (ETL_AUDIT_START_TIME), and the  finish time for the job (ETL_AUDIT_FINISH_TIME).
 |-
 |Extracted Events Amount
 |The number of loaded events during a job or batch run.
 |-
 |}

PEC-REP/Current/RPRT/HRCXIiWDETLAuditDshbrd - Revision history

WikiSysop at 23:04, June 29, 2022

WikiSysop: Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Tgilchri: Published

Bgrenon: Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"