Metrics and Scorecards Upgrade

Upgrade Metrics and Scorecards

This module will be upgraded to the latest version of Cloud APM automatically. No additional steps are required.

Modify the Event or Asset Criticality Data for Work History Cube

If the event or asset criticality data in your database does not match with the standard IDs used for the work history cube, then you have to map the event or asset criticality data to the standard event or asset criticality data using the corresponding families.

Map the Non-Standard Event Type Data to Standard Event Type IDs Using Queries for Event Type Dimension Family

This topic describes how to map the event type data available in your database to the standard event type data defined for a work history cube.

Procedure

  1. In the Applications menu, navigate to the TOOLS section, and then select Queries.
    The Query page appears.
  2. Select Create New.
    The Select a Family or Query window appears.
  3. Search for the Event Type Dimension family, and then select Add.
    The Design workspace appears.
  4. Select the SQL tab.
    The SQL workspace appears.
  5. Run the query SELECT [MI_DIM_EVENT_TYPE].[EventType] "EventType", [MI_DIM_EVENT_TYPE].[EventTypeCaption] "EventTypeCaption" FROM [MI_DIM_EVENT_TYPE].
    The standard event type data available in APM appears in the query results.
  6. Run the query SELECT distinct MI_EVENT_TYP_CHR from MI_EVENT.
    The event type data available in your database appears in the query results.
  7. Verify if the event type data returned by the query in Step 6 matches the standard event type IDs returned by the query in Step 5.
  8. If the results do not match, perform the following steps to map the event type data available in your database with the standard event type ID available in APM:
    1. In the SQL workspace, enter the following update query:
      UPDATE [MI_DIM_EVENT_TYPE] SET [MI_DIM_EVENT_TYPE].[EventTypeCaption] = '<New Data>' WHERE [MI_DIM_EVENT_TYPE].[EventTypeCaption] = '<Standard Data Caption>'
      Note: In this query:
      • <New Data> denotes the event type data that you want to map to the standard event type ID available in APM.
      • <Standard Data Caption> denotes the captions corresponding to the standard event type data available in APM.
    2. Replace <New Data> with a value that you want to map with the standard event type data available in APM.
    3. Replace <Standard Data Caption> with the caption available for the corresponding event type ID to which the new event type data will be mapped.
    4. Run the query.
      The Execute Query window appears.
    5. Select Yes.
      The event type data is mapped to the standard event type ID defined for the work history cube.

Map an Event Type to a Standard Event Type ID

The following standard event type data is returned by the query run in Step 5.
EventTypeEventTypeCaption
MiscellaneousMiscellaneous
PM/PdMPM/PdM
RepairRepair
UnknownUnknown
The following event type data is returned by the query run in Step 6:
  • INSPECTION
  • PM/PdM
  • Reading
  • Repair
If you want to map the event type INSPECTION to the standard event type ID Miscellaneous:
  • Run the query UPDATE [MI_DIM_EVENT_TYPE] SET [MI_DIM_EVENT_TYPE].[EventTypeCaption] = 'INSPECTION' WHERE [MI_DIM_EVENT_TYPE].[EventTypeCaption] = 'Miscellaneous'.

    The event type INSPECTION is mapped to the standard event type ID Miscellaneous.

Map the Non-Standard Event Priority Data to Standard Event Priority IDs Using Queries for Event Priority Dimension Family

This topic describes how to map the event priority data available in your database to the standard event priority data defined for a work history cube.

Procedure

  1. In the Applications menu, navigate to the TOOLS section, and then select Queries..
    The Query page appears.
  2. Select Create New.
    The Select a Family or Query window appears.
  3. Search for the Event Priority Dimension family, and then select Add.
    The Design workspace appears.
  4. Select the SQL tab.
    The SQL workspace appears.
  5. Run the query SELECT [MI_DIM_EVENT_PRIORITY].[Priority] "Priority", [MI_DIM_EVENT_PRIORITY].[PriorityCaption] "PriorityCaption" FROM [MI_DIM_EVENT_PRIORITY].
    The standard event priority data available in APM appears in the query results.
  6. Run the following queries:
    • SELECT distinct MI_EVWKHIST_BRKDN_IND_F from MI_EVWKHIST
    • SELECT distinct MI_EVWKHIST_RQST_PRTY_C from MI_EVWKHIST
    The event priority data available in your database appears in the query results.
  7. Verify if the event priority data returned by the query in Step 6 matches the standard event priority IDs returned by the query in Step 5.
  8. If the results do not match, perform the following steps to map the event priority data available in your database with the standard event priority ID available in APM:
    1. In the SQL workspace, enter the following update query:
      UPDATE [MI_DIM_EVENT_PRIORITY] SET [MI_DIM_EVENT_PRIORITY].[PriorityCaption] = '<New Data>' WHERE [MI_DIM_EVENT_PRIORITY].[PriorityCaption] = '<Standard Data Caption>'
      Note: In this query:
      • <New Data> denotes the event priority data that you want to map to the standard event priority ID available in APM.
      • <Standard Data Caption> denotes the captions corresponding to the standard event priority data available in APM.
    2. Replace <New Data> with a value that you want to map with the standard event priority data available in APM.
    3. Replace <Standard Data Caption> with the caption available for the corresponding event priority ID to which the new event priority data will be mapped.
    4. Run the query.
      The Execute Query window appears.
    5. Select Yes.
      The event priority data is mapped to the standard event priority ID defined for the work history cube.

Map Event Priority Data to a Standard Event Priority ID

The following standard event priority data is returned by the query run in Step 5.
PriorityPriorityCaption
1Very Low
2Low
3Medium
4High
5Emergency
UnknownUnknown
The following event priority data is returned by the query run in Step 6:
  • 1
  • 2
  • 3
  • 4
If you want to map the event priority data 1 to the standard event priority ID 5:
  • Run the query UPDATE [MI_DIM_EVENT_PRIORITY] SET [MI_DIM_EVENT_PRIORITY].[PriorityCaption] = '1' WHERE [MI_DIM_EVENT_PRIORITY].[PriorityCaption] = 'Emergency’.

    The event priority data 1 is mapped to the standard event priority ID 5.

Map the Non-Standard Event Detection Methods to Standard Event Detection Method IDs Using Queries for Event Detection Method Dimension Family

This topic describes how to map the event detection methods available in your database to the standard event detection methods defined for a work history cube.

Procedure

  1. In the Applications menu, navigate to the TOOLS section, and then select Queries.
    The Query page appears.
  2. Select Create New.
    The Select a Family or Query window appears.
  3. Search for the Event Detection Method Dimension family, and then select Add.
    The Design workspace appears.
  4. Select the SQL tab.
    The SQL workspace appears.
  5. Run the query SELECT [MI_DIM_EVENT_DETECTION].[DetectionMethod] "DetectionMethod", [MI_DIM_EVENT_DETECTION].[DetectionMethodCaption] "DetectionMethodCaption" FROM [MI_DIM_EVENT_DETECTION].
    The standard event detection methods available in APM appears in the query results.
  6. Run the query SELECT distinct MI_EVWKHIST_DETCT_MTHD_CD_C from MI_EVWKHIST.
    The event detection methods available in your database appears in the query results.
  7. Verify if the event detection methods returned by the query in Step 6 match the standard event detection method IDs returned by the query in Step 5.
  8. If the results do not match, perform the following steps to map the event detection methods available in your database with the standard event detection method ID available in APM:
    1. In the SQL workspace, enter the following update query:
      UPDATE [MI_DIM_EVENT_DETECTION] SET [MI_DIM_EVENT_DETECTION].[DetectionMethod] = '<New Data>' WHERE [MI_DIM_EVENT_DETECTION].[DetectionMethod] = '<Standard Data Caption>'
      Note: In this query:
      • <New Data> denotes the event detection method that you want to map to the standard event detection method ID available in APM.
      • <Standard Data Caption> denotes the captions corresponding to the standard event detection method available in APM.
    2. Replace <New Data> with a value that you want to map with the standard event detection method available in APM.
    3. Replace <Standard Data Caption> with the caption available for the corresponding event detection method ID to which the new event detection method will be mapped.
    4. Run the query.
      The Execute Query window appears.
    5. Select Yes.
      The event detection method is mapped to the standard event detection method ID defined for the work history cube.

Map an Event Detection Method to a Standard Event Detection Method ID

The following standard event detection methods are returned by the query run in Step 5.
DetectionMethodDetectionMethodCaption
0001Continuous Condition Monitoring
0002Corrective Maintenance
0003Formal Inspection
0004Operator Routine Observation
0005Periodic Condition Monitoring
0006Preventive Maintenance
0007Production Interference
0008Radar Operator observation
The following event detection methods are returned by the query run in Step 6:
  • Inspection
  • Observation
  • Preventive Maintenance
  • Production Interference
If you want to map the event detection method Inspection to the standard event detection method ID 0001:
  • Run the query UPDATE [MI_DIM_EVENT_DETECTION] SET [MI_DIM_EVENT_DETECTION].[DetectionMethod] = 'Inspection' WHERE [MI_DIM_EVENT_DETECTION].[DetectionMethod] = '0001'.

    The event detection method Inspection is mapped to the standard event detection method ID 0001.

Map the Non-Standard Event Breakdown Data to Standard Event Breakdown IDs Using Queries for Event Breakdown Dimension Family

This topic describes how to map the event breakdown data available in your database to the standard event breakdown data defined for a work history cube.

Procedure

  1. In the Applications menu, navigate to the TOOLS section, and then select Queries.
    The Query page appears.
  2. Select Create New.
    The Select a Family or Query window appears.
  3. Search for the Event Breakdown Dimension family, and then select Add.
    The Design workspace appears.
  4. Select the SQL tab.
    The SQL workspace appears.
  5. Run the query SELECT [MI_DIM_EVENT_BREAKDOWN].[Breakdown] "Breakdown", [MI_DIM_EVENT_BREAKDOWN].[BreakdownCaption] "BreakdownCaption" FROM [MI_DIM_EVENT_BREAKDOWN].
    The standard event breakdown data available in APM appears in the query results.
  6. Run the query SELECT distinct MI_EVWKHIST_BRKDN_IND_F from MI_EVWKHIST.
    The event breakdown data available in your database appears in the query results.
  7. Verify if the event breakdown data returned by the query in Step 6 matches the standard event breakdown IDs returned by the query in Step 5.
  8. If the results do not match, perform the following steps to map the event breakdown data available in your database with the standard event breakdown ID available in APM:
    1. In the SQL workspace, enter the following update query:
      UPDATE [MI_DIM_EVENT_BREAKDOWN] SET [MI_DIM_EVENT_BREAKDOWN].[BreakdownCaption] = '<New Data>' WHERE [MI_DIM_EVENT_BREAKDOWN].[BreakdownCaption] = '<Standard Data Caption>'
      Note: In this query:
      • <New Data> denotes the event breakdown data that you want to map to the standard event breakdown ID available in APM.
      • <Standard Data Caption> denotes the captions corresponding to the standard event breakdown data available in APM.
    2. Replace <New Data> with a value that you want to map with the standard event breakdown data available in APM.
    3. Replace <Standard Data Caption> with the caption available for the corresponding event breakdown ID to which the new event breakdown data will be mapped.
    4. Run the query.
      The Execute Query window appears.
    5. Select Yes.
      The event breakdown data is mapped to the standard event breakdown ID defined for the work history cube.

Map an Event Breakdown Indicator to a Standard Event Breakdown ID

The following standard event breakdown data is returned by the query run in Step 5.
BreakdownBreakdownCaption
NN
UnknownUnknown
YY
The following event breakdown data is returned by the query run in Step 6:
  • No
  • Yes
  • Unknown
If you want to map the event breakdown indicator Yes to the standard event breakdown ID Y:
  • Run the query UPDATE [MI_DIM_EVENT_BREAKDOWN] SET [MI_DIM_EVENT_BREAKDOWN].[BreakdownCaption] = 'Yes' WHERE [MI_DIM_EVENT_BREAKDOWN].[BreakdownCaption] = 'Y'.

    The event breakdown indicator Yes is mapped to the standard event breakdown ID Y.

Map the Non-Standard Asset Criticality Data to Standard Asset Criticality IDs Using Queries for Asset Criticality Dimension Family

This topic describes how to map the asset criticality data available in your database to the standard asset criticality IDs defined for a work history cube.

Procedure

  1. In the Applications menu, navigate to the TOOLS section, and then select Queries.
    The Query page appears.
  2. Select Create New.
    The Select a Family or Query window appears.
  3. Search for the Asset Criticality Dimension family, and then select Add.
    The Design workspace appears.
  4. Select the SQL tab.
    The SQL workspace appears.
  5. Run the query SELECT [MI_DIM_ASSET_CRITICALITY].[Criticality] "Criticality", [MI_DIM_ASSET_CRITICALITY].[CriticalityCaption] "CriticalityCaption" FROM [MI_DIM_ASSET_CRITICALITY].
    The standard asset criticality data available in APM appears in the query results.
  6. Run the following queries:
    • For equipment criticality data, run the query SELECT distinct MI_EQUIP000_CRITI_MTHD_IND_C from MI_EQUIP000.

      The equipment criticality data available in your database appears in the query results.

    • For functional location criticality data, run the query SELECT distinct MI_FNCLOC00_CRTCAL_IND_C from MI_FNCLOC00.

      The functional location criticality data available in your database appears in the query results.

  7. Verify if the asset criticality data returned by the query in Step 6 matches the standard asset criticality IDs returned by the query in Step 5.
  8. If the results do not match, perform the following steps to map the asset criticality data available in your database with the standard asset criticality ID available in APM:
    1. In the SQL workspace, enter the following update query:
      UPDATE [MI_DIM_ASSET_CRITICALITY] SET [MI_DIM_ASSET_CRITICALITY].[CriticalityCaption] = '<New Data>' WHERE [MI_DIM_ASSET_CRITICALITY].[CriticalityCaption] = '<Standard Data Caption>'
      Note: In this query:
      • <New Data> denotes the asset criticality data that you want to map to the standard asset criticality ID available in APM.
      • <Standard Data Caption> denotes the captions corresponding to the standard asset criticality data available in APM.
    2. Replace <New Data> with a value that you want to map with the standard asset criticality data available in APM.
    3. Replace <Standard Data Caption> with the caption available for the corresponding asset criticality ID to which the new asset criticality data will be mapped.
    4. Run the query.
      The Execute Query window appears.
    5. Select Yes.
      The asset criticality data is mapped to the standard asset criticality ID defined for the work history cube.

Map Asset Criticality Data to a Standard Asset Criticality ID

The following standard asset criticality data are returned by the query run in Step 5.
CriticalityCriticalityCaption
AHigh
BMedium
CLow
UnknownUnknown
The following asset criticality data are returned by the query run in Step 6:
  • X
  • Y
  • Z
  • H
If you want to map the asset criticality data X to the standard asset criticality ID A:
  • Run the query UPDATE [MI_DIM_ASSET_CRITICALITY] SET [MI_DIM_ASSET_CRITICALITY].[CriticalityCaption] = 'X' WHERE [MI_DIM_ASSET_CRITICALITY].[CriticalityCaption] = 'High'.

    The asset criticality data X is mapped to the standard asset criticality ID A.