Metrics and Scorecards Upgrade

1. In the Views, select MIV_MI_FAC_WORK_HSTY view, and then run the following query to check if the Event Type data matches the standard classification defined.

   SELECT distinct MI_EVENT_TYP_CHR from MI_EVENT

2. Verify if the results match the standard event type IDs defined by the Work History cube.
3. If the results do not match, then modify the case statement CASE MI_EVENT_TYP_CHR in the view to display the standard event type IDs.

CASE MI_EVENT_TYP_CHR

 WHEN 'Miscellaneous' THEN 'Miscellaneous'

 WHEN 'PM/PdM' THEN 'PM/PdM'

 WHEN 'Repair' THEN 'Repair'

 WHEN 'Inspection' THEN 'PM/PdM'

 ELSE 'Unknown'

END AS EventType

1. In the Views, select MIV_MI_FAC_WORK_HSTY view, and then run the following queries to check if the Event priority data matches the standard classification defined.

   SELECT distinct MI_EVWKHIST_ORDR_PRTY_C from MI_EVWKHIST

   SELECT distinct MI_EVWKHIST_RQST_PRTY_C from MI_EVWKHIST

2. Verify if the results match the standard event priority IDs defined by the Work History cube.
3. If the results do not match, then modify the case statement CASE ISNULL(MI_EVWKHIST_ORDR_PRTY_C, MI_EVWKHIST_RQST_PRTY_C) in the view to display the standard event priority IDs.

CASE ISNULL(MI_EVWKHIST_ORDR_PRTY_C, MI_EVWKHIST_RQST_PRTY_C)

WHEN 'Very Low' THEN '1'

WHEN 'Low' THEN '2'

WHEN 'Medium' THEN '3'

WHEN 'High' THEN '4'

WHEN 'Emergency' THEN '5'

WHEN '1' THEN '1'

WHEN '2' THEN '2'

WHEN '3' THEN '3'

WHEN '4' THEN '4'

WHEN '5' THEN '5'

WHEN 'M' THEN '3'

ELSE 'Unknown'

END AS Priority

1. In the Views, select MIV_MI_FAC_WORK_HSTY view, and then run the following queries to check if the Event detection method data matches the standard classification defined.

   SELECT distinct MI_EVWKHIST_DETCT_MTHD_CD_C from MI_EVWKHIST

2. Verify if the results match the standard event detection method IDs defined by the Work History cube.
3. If the results do not match, then modify the case statement CASE MI_EVWKHIST_DETCT_MTHD_CD_C in the view to display standard event detection method IDs.

CASE MI_EVWKHIST_DETCT_MTHD_CD_C

WHEN 'Continous Condition Monitoring' THEN '0001'

WHEN 'Corrective Maintenance' THEN '0002'

WHEN 'Formal Inspection' THEN '0003'

WHEN 'Operator Routine Observation' THEN '0004'

WHEN 'Periodic Condition Monitoring' THEN '0005'

WHEN 'Preventive Maintenance' THEN '0006'

WHEN 'Production Interference' THEN '0007'

WHEN 'Radar operator Observation' THEN '0008'

WHEN '0001' THEN '0001'

WHEN '0002' THEN '0002'

WHEN '0003' THEN '0003'

WHEN '0004' THEN '0004'

WHEN '0005' THEN '0005'

WHEN '0006' THEN '0006'

WHEN '0007' THEN '0007'

WHEN '0008' THEN '0008'

WHEN '0009' THEN '0001'

ELSE 'Unknown'

END AS DetectionMethod

1. In the Views, select MIV_MI_FAC_WORK_HSTY view and then run the following query to check if the Event Breakdown data matches the standard classification defined.

   SELECT distinct MI_EVWKHIST_BRKDN_IND_F from MI_EVWKHIST

2. Verify if the results match the standard event breakdown IDs defined by the Work History cube.
3. If the results do not match, then modify the case statement CASE MI_EVWKHIST_BRKDN_IND_F in the view to display the standard event breakdown IDs.

CASE MI_EVWKHIST_BRKDN_IND_F

 WHEN 'Y' THEN 'Y'

 WHEN 'N' THEN 'N'

 WHEN 'No' THEN 'N'

 ELSE 'Unknown'

END AS Breakdown

1. In the Views, select MIV_MI_FAC_EQUIPMENT view, and then run the following queries to check if the Equipment Criticality data matches the standard classification defined.

   SELECT distinct MI_EQUIP000_CRITI_MTHD_IND_C from MI_EQUIP000

2. Verify if the results match the standard equipment criticality IDs defined by the Work History cube.
3. If the results do not match, then modify the case statement CASE MI_EQUIP000_CRITI_IND_C in the view to display standard equipment criticality IDs.

CASE MI_EQUIP000_CRITI_IND_C

WHEN 'HIGH' THEN 'A'

WHEN 'Medium' THEN 'B'

WHEN 'Low' THEN 'C'

WHEN 'A' THEN 'A'

WHEN 'B' THEN 'B'

WHEN 'C' THEN 'C'

WHEN 'H' THEN 'A'

ELSE 'Unknown'

END AS EquipmentCriticality

1. In the Views, select MIV_MI_FAC_FNC_LOC view, and then run the following queries to check if the Functional Location Criticality data matches the standard classification defined.

   SELECT distinct MI_FNCLOC00_CRTCAL_IND_C from MI_FNCLOC00

2. Verify if the results match the standard functional location criticality IDs defined by the Work History cube.
3. If the results do not match, then modify the case statement CASE A.MI_FNCLOC00_CRTCAL_IND_C in the view to display standard functional location criticality IDs.

CASE A.MI_FNCLOC00_CRTCAL_IND_C

WHEN 'HIGH' THEN 'A'

WHEN 'Medium' THEN 'B'

WHEN 'Low' THEN 'C'

WHEN 'A' THEN 'A'

WHEN 'B' THEN 'B'

WHEN 'C' THEN 'C'

WHEN 'M' THEN 'B'

ELSE 'Unknown'

END AS FunctionalLocationCriticality

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

1. In the Tables, select the table MI_DIM_EVENT_TYPE.
   The table values appear, displaying the event type ID and the event caption.
2. In the EventTypeCaption column, select the cell for the event type that you want to localize, and then manually modify the caption.
3. Save the modification, and then process the cube.
4. Log in to APM.
5. Access the Metrics and Scorecards page and create a new Metric View.
   The design page for the Metric View appears.
6. In the Metric Views design page, in the Rows/X-Axis subsection, select .
   The Add to Rows window appears.
7. In the Event Type, select Event Type-Breakdown, and then select Event Type.
   The caption for the event breakdown values appears in the language to which you have modified.

   

1. In the Tables, select the table MI_DIM_EVENT_BREAKDOWN.
   The table values appear, displaying the breakdown ID and the breakdown caption.
2. In the BreakdownCaption column, select the cell for the breakdown that you want to localize, and then manually modify the caption.
3. Save the modification, and then process the cube.
4. Log in to APM.
5. Access the Metrics and Scorecards page and create a new Metric View.
   The design page for the Metric View appears.
6. In the Metric Views design page, in the Rows/X-Axis subsection, select .
   The Add to Rows window appears.
7. In the Event Type, select Event Type-Breakdown, and then select Breakdown.
   The caption for the event type values appears in the language to which you have modified.

   

1. In the Tables, select the table MI_DIM_EVENT_PRIORITY.
   The table values appear, displaying the Priority ID and the Priority caption.
2. In the PriorityCaption column, select the cell for the priority caption that you want to localize, and then manually modify the caption.
3. Save the modification, and then process the cube.
4. Log in to APM.
5. Access the Metrics and Scorecards page and create a new Metric View.
   The design page for the Metric View appears.
6. In the Metric Views design page, in the Rows/X-Axis subsection, select .
   The Add to Rows window appears.
7. In the Event Priority, select Priority, and then select Priority.
   The caption for the priorities appears in the language to which you have modified.

   

1. In the Tables, select the table MI_DIM_EVENT_DETECTION_METHOD.
   The table values appear, displaying the event type ID and the event caption.
2. In the DetectionMethodCaption column, select the cell for the detection method that you want to localize, and then manually modify the caption.
3. Save the modification, and then process the cube.
4. Log in to APM.
5. Access the Metrics and Scorecards page and create a new Metric View.
   The design page for the Metric View appears.
6. In the Metric Views design page, in the Rows/X-Axis subsection, select .
   The Add to Rows window appears.
7. In the Event Detection, select Detection, and then select Detection Method.
   The caption of the Detection Method values appear in the language to which it was modified.

   

1. In the Tables, select the table MI_DIM_ASSET_CRITICALITY.
   The table values appear, displaying the Criticality ID and the Criticality caption.
2. In the CriticalityCaption column, select the cell for the caption that you want to localize, and then manually modify the caption.
3. Save the modification, and then process the cube.
4. Log in to APM.
5. Access the Metrics and Scorecards page and create a new Metric View.
   The design page for the Metric View appears.
6. In the Metric Views design page, in the Rows/X-Axis subsection, select .
   The Add to Rows window appears.
7. In the Equipment, select Criticality, and then select Criticality.
   The caption of the criticality values appear in the language to which it was modified.

   

1. In the Tables, select the table MI_DIM_ASSET_CRITICALITY.
   The table values appear, displaying the criticality ID and the criticality caption.
2. In the CriticalityCaption column, select the cell for the caption that you want to localize, and then manually modify the caption.
3. Save the modification, and then process the cube.
4. Log in to APM.
5. Access the Metrics and Scorecards page and create a new Metric View.
   The design page for the Metric View appears.
6. In the Metric Views design page, in the Rows/X-Axis subsection, select .
   The Add to Rows window appears.
7. In the Functional Location, select Criticality, and then select Criticality.
   The caption of the functional location criticality values appear in the language to which it was modified.