Construct Pages Metrics

This topic relates to the following sections:

• Construct Pages

• Construct Page Deployment Security

• Metrics Configuration

About Construct Pages Metrics

Tracking the counts for status of enhancement or construction may be setup and run for each of the Construct Pages.  Metric views are built within the CONSTRUCT database and stored in the Metric View field of the Construct Pages details page.  As changes are saved to the Construct Pages, a query is run that adds rows of data to the Metric View table. 

With the Construct Page table storing the changes made for Construction or Enrichment, and the Metric View built and added to the Construct Page Details panel, the user may view metrics for Construct Pages by using pathway: Monitor > Metric Scorecard or Monitor > PMO Dashboard.

Each of these views is joined into a Union view and the statistical values are then presented in the Metric Scorecard. 

Prerequisites for Displaying Accurate Metrics

• Once the Construct Page is setup with the Metric view attached, the user can assign the Deployments and link users to the Deployments. 

  • Metrics do not calculate for templates that do not contain deployments (one of the required key fields of each Construct Page). 

  • Users are not able to view a Construct Page to which they are not assigned. 

  • The Deployments are determined within the Project Setup for each Project / Release / Development Area and these deployments are the list for selection within the Construct Pages pages. 

• A Construction table may start out with no records as the data is built using the application.  These tables display in the list of metrics for a dataset until rows of data are added within the table. 

• By selecting the Construct Type of 'Construction', the Syniti Migrate system provides fields within the Deployment details to store the expected Total Count. 

• The Min Per Record field within the Construct Page Details page is used to store the estimate of time in minutes per record to complete the construction. 

• The Estimate (Total Count of records) * Min Per Record determines the overall time required to complete this task, and this is provided in the metrics. 

• Details for the Metrics process is explained within pathway: Monitor > Metrics Scorecard.  Metric Milestone percentages are stored within pathway Administer > Advanced > Metrics Configuration.

• The Metrics are not automatically refreshed.  The user accesses Metrics Configuration to execute the refresh of each type of Metric. 

Build the Metric View

Syniti Migrate monitors the metrics for Construct Pages, if each of the Construct Pages are provided a Metric View stored within the client's CONSTRUCT database. An example metric view is listed below. The system queries these views and insert to a table the results to provide the statistics for Metric Scorecard. The Metric views must be the same for each Construct Page as every metric view is inserted into a table for the statistics. As example, in this Metric view each status is part of the metric and part of the selection list ZSTATUS field.

Refer to section Administer > Advanced > List Boxes for details of adding LIST_CONSTRUCT_STATUS as the List box that used for the drop down for selection of ZSTATUS values.

Syniti Standard naming for Construct Page Metric View Ex: MM_MARA_C where the SubjectAreaShortname_TableName_C is the naming pattern for these tables. The resulting view should be named as ConstructTable_METRIC as example -

MM_MARA_C >> MM_MARA_C_METRIC

SELECT '1e8ba45f-ed78-489c-b24f-ad221bf93b6a ' AS TEMPLATE_ID, ZSOURCE, ZSOURCE AS ZDATASOURCE, ZDEPLOY, COUNT(*) AS TOTAL, SUM(MIGRATE.dbo.SYN_CONSTRUCT_STATUS(N'INPROGRESS', ZSTATUS)) AS INPROGRESS, SUM(MIGRATE.dbo.SYN_CONSTRUCT_STATUS(N'FAILED', ZSTATUS)) AS FAILED, SUM(MIGRATE.dbo.SYN_CONSTRUCT_STATUS(N'COMPLETE', ZSTATUS)) AS COMPLETE, SUM(MIGRATE.dbo.SYN_CONSTRUCT_STATUS(N'REJECTED', ZSTATUS)) AS REJECTED, SUM(MIGRATE.dbo.SYN_CONSTRUCT_STATUS(N'NEW', ZSTATUS)) AS NEW

FROM dbo.FI_F0101_ADDRESS_C

GROUP BY ZSOURCE, ZDEPLOY