Deployment

Deploy Metrics and Scorecards for the First Time

About this task

The following table outlines the steps that you must complete to deploy and configure this module for the first time. These instructions assume that you have completed the steps for deploying the basic system architecture.

These tasks may be completed by multiple people in your organization. We recommend, however, that the tasks be completed in the order in which they are listed.

Note: If you are deploying this module in APM Now, before you begin completing these tasks, review the system requirements for this module to identify the supported features for this module in APM Now. Unless noted, all deployment tasks in the following table are applicable for the deployment of this module in APM Now.

Results


Step	Task	Notes
1	Deploy SQL Server Analysis Services 2012 or Microsoft SQL Server Analysis Services 2014. Ensure that the SQL Server Analysis Services machine meets the system requirements. Deploying SQL Server Analysis Services on the SQL Server Analysis Server machine includes the following steps: Install SQL Server Analysis Services. Deploy the Work History Analysis Services database. This Work History cube is a replacement for the Equipment and Functional Location Work History cubes in the Meridium_Event_Analysis database. Create a Windows User on the Analysis Server or in your organization’s Active Directory. The user name requires minimum privileges and will only be used by the GE Digital APM Server to connect to the cubes. It is recommended that: The password for this user should never expire. The user should be restricted to change password. The user should be restricted to log in to others servers (e.g., meridium_ssas_user). Add the user created in Step 3 to a role on all SQL Analysis Services databases you want to access in GE Digital APM software. The role should have read and drill through permissions. The Work History database already has a View role defined, you should add the user to this role. For more information, consult the MSDN documentation regarding Roles and Permissions for Analysis Services. Configure SQL Server Analysis Server for HTTP or HTTPS access using basic authentication. HTTPS is recommended with basic authentication. For more information, consult the MSDN documentation regarding configuring the HTTP access to Analysis Services on Internet Information Service (IIS).	This step is required. This step assumes that you have read the Metrics and Scorecards hardware and software requirements and that you have obtained the SQL Server Analysis Services software installer.
2	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
3	Localize the event and asset criticality values in the application.	This step is optional.
4	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.
5	Assign Security Users to one or more of the Metrics and Scorecards Security Groups and Roles.	This step is required.
6	Create Analysis Services Cube records for each cube that has been defined in SQL Server Analysis Services. Since GE Digital APM uses HTTP connection to connect to the cube, in addition to server address, you need to provide credentials of the user created in Step 1 Task 3.	This step is required.
7	Grant Security Users and Groups access rights to Analysis Services Cube records .	This step is required.
8	Configure privileges for KPI .	This step is required.
9	Configure privileges for Scorecards .	This step is required.
10	Configure a cube for usage metrics tracking on the SQL Server Analysis Server.	This step is required only if you use Metrics and Scorecards to view the usage metrics in a cube.

Upgrade or Update Metrics and Scorecards to GE Digital APMV4.3.0.6.0

About this task

The following tables outline the steps that you must complete to upgrade this module to V4.3.0.6.0. These instructions assume that you have completed the steps for upgrading the basic GE Digital APM system architecture.

These tasks may be completed by multiple people in your organization. We recommend, however, that the tasks be completed in the order in which they are listed.

Procedure

Upgrade from any version V4.3.0.0.0 through V4.3.0.5.2


Step	Task	Notes
1	Deploy the new Work History cube.	Important: Before deploying the new Work History cube, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required, and the baseline work history cube must be redeployed. The baseline Work History cube was modified such that even if the event or equipment data do not meet the standard classification defined for Work History cube, with minor modifications to SQL views used by the cube, the cube can still work with the non-standard event and equipment data.
2	If you have made modifications in the previous version of the cube, then you must manually make the same modifications to the current Work History cube.	This step is required only if you had made any modifications to the previously provided Work History cube. If you had made any modifications to the Work History cube, then you must manually make those updates again.
3	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
4	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
5	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.

Upgrade from any version V4.2.0.0 through V4.2.0.9.2


Step	Task	Notes
1	Deploy the new Work History cube.	Important: Before deploying the new Work History cube, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required, and the baseline work history cube must be redeployed. The baseline Work History cube was modified such that even if the event or equipment data do not meet the standard classification defined for Work History cube, with minor modifications to SQL views used by the cube, the cube can still work with the non-standard event and equipment data.
2	If you have made modifications in the previous version of the cube, then you must manually make the same modifications to the current Work History cube.	This step is required only if you had made any modifications to the previously provided Work History cube. If you had made any modifications to the Work History cube, then you must manually make those updates again.
3	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
4	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
5	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.

Upgrade from any version V4.1.0.0 through V4.1.7.4.0


Step	Task	Notes
1	Deploy the new Work History cube.	Important: Before deploying the new Work History cube, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required, and the baseline work history cube must be redeployed. The baseline Work History cube was modified such that even if the event or equipment data do not meet the standard classification defined for Work History cube, with minor modifications to SQL views used by the cube, the cube can still work with the non-standard event and equipment data.
2	If you have made modifications in the previous version of the cube, then you must manually make the same modifications to the current Work History cube.	This step is required only if you had made any modifications to the previously provided Work History cube. If you had made any modifications to the Work History cube, then you must manually make those updates again.
3	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
4	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
5	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.

Upgrade from any version V4.0.0.0 through V4.0.1.0


Step	Task	Notes
1	Deploy the new Work History cube.	Important: Before deploying the new Work History cube, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required, and the baseline work history cube must be redeployed. The baseline Work History cube was modified such that even if the event or equipment data do not meet the standard classification defined for Work History cube, with minor modifications to SQL views used by the cube, the cube can still work with the non-standard event and equipment data.
2	If you have made modifications in the previous version of the cube, then you must manually make the same modifications to the current Work History cube.	This step is required only if you had made any modifications to the previously provided Work History cube. If you had made any modifications to the Work History cube, then you must manually make those updates again.
3	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
4	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
5	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.

Upgrade from any version V3.6.1.0.0 through V3.6.1.7.1


Step	Task	Notes
1	Migrate your SQL Server Analysis Services database and cubes to the following supported SQL Server Analysis Services versions: 2012 2014	This step is required only if you were previously using SQL Server Analysis Services 2008 R2.
2	Configure SQL Server Analysis Server for HTTP or HTTPS access using basic authentication.	This step is required.
3	Deploy Work History Analysis Services database. This Work History cube is a replacement for the Equipment and Functional Location Work History cubes in the Meridium_Event_Analysis database.	Important: Before executing this step, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required.
4	Create a Windows User on the Analysis Server or in your organization’s Active Directory. The user name requires minimum privileges and will only be used by the GE Digital APM Server to connect to the cubes. It is recommended that: The password for this user should never expire. The user should be restricted to change password. The user should be restricted to log in to others servers (e.g., meridium_ssas_user).	This step is required.
5	Add the user created in Step 4 to a role on all SQL Analysis Services databases that you want to access in GE Digital APM. The role should have read and drill-through permissions. If the Work History database already has a View role defined, then you should add the user to this role. For more information, consult the MSDN documentation regarding Roles and Permissions for Analysis Services.	This step is required.
6	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
7	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
8	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.
9	Update the existing Analysis Services Cube records so that GE Digital APM connects to the cube using the HTTP/ HTTPS access.	This step is required.

Upgrade from any version V3.6.0.0.0 through V3.6.0.12.8


Step	Task	Notes
1	Migrate your SQL Server Analysis Services database and cubes to the following supported SQL Server Analysis Services versions: 2012 2014	This step is required only if you were previously using SQL Server Analysis Services 2008 R2.
2	Configure SQL Server Analysis Server for HTTP or HTTPS access using basic authentication.	This step is required.
3	Deploy Work History Analysis Services database. This Work History cube is a replacement for the Equipment and Functional Location Work History cubes in the Meridium_Event_Analysis database.	Important: Before executing this step, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required.
4	Create a Windows User on the Analysis Server or in your organization’s Active Directory. The user name requires minimum privileges and will only be used by the GE Digital APM Server to connect to the cubes. It is recommended that: The password for this user should never expire. The user should be restricted to change password. The user should be restricted to log in to others servers (e.g., meridium_ssas_user.	This step is required.
5	Add the user created in Step 4 to a role on all SQL Analysis Services databases that you want to access in GE Digital APM. The role should have read and drill-through permissions. If the Work History database already has a View role defined, then you should add the user to this role. For more information, consult the MSDN documentation regarding Roles and Permissions for Analysis Services.	This step is required.
6	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
7	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
8	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.
9	Update the existing Analysis Services Cube records so that GE Digital APM connects to the cube using the HTTP/ HTTPS access.	This step is required.

Upgrade from any version V3.5.1 through V3.5.1.12.3


Step	Task	Notes
1	Migrate your SQL Server Analysis Services database and cubes to the following supported SQL Server Analysis Services versions: 2012 2014	This step is required only if you were previously using SQL Server Analysis Services 2008 R2.
2	Configure SQL Server Analysis Server for HTTP or HTTPS access using basic authentication.	This step is required.
3	Deploy Work History Analysis Services database. This Work History cube is a replacement for the Equipment and Functional Location Work History cubes in the Meridium_Event_Analysis database.	Important: Before executing this step, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required.
4	Create a Windows User on the Analysis Server or in your organization’s Active Directory. The user name requires minimum privileges and will only be used by the GE Digital APM Server to connect to the cubes. It is recommended that: The password for this user should never expire. The user should be restricted to change password. The user should be restricted to log in to others servers (e.g., meridium_ssas_user).	This step is required.
5	Add the user created in Step 4 to a role on all SQL Analysis Services databases that you want to access in GE Digital APM. The role should have read and drill-through permissions. If the Work History database already has a View role defined, then you should add the user to this role. For more information, consult the MSDN documentation regarding Roles and Permissions for Analysis Services.	This step is required.
6	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
7	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
8	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.
9	Update the existing Analysis Services Cube records so that GE Digital APM connects to the cube using the HTTP/ HTTPS access.	This step is required.

Upgrade from any version V3.5.0 SP1 LP through V3.5.0.1.10.1


Step	Task	Notes
1	Migrate your SQL Server Analysis Services database and cubes to the following supported SQL Server Analysis Services versions: 2012 2014	This step is required only if you were previously using SQL Server Analysis Services 2008 R2.
2	Configure SQL Server Analysis Server for HTTP or HTTPS access using basic authentication.	This step is required.
3	Deploy Work History Analysis Services database. This Work History cube is a replacement for the Equipment and Functional Location Work History cubes in the Meridium_Event_Analysis database.	Important: Before executing this step, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required.
4	Create a Windows User on the Analysis Server or in your organization’s Active Directory. The user name requires minimum privileges and will only be used by the GE Digital APM Server to connect to the cubes. It is recommended that: The password for this user should never expire. The user should be restricted to change password. The user should be restricted to log in to others servers (e.g.,meridium_ssas_user).	This step is required.
5	Add the user created in Step 4 to a role on all SQL Analysis Services databases that you want to access in GE Digital APM. The role should have read and drill-through permissions. If the Work History database already has a View role defined, then you should add the user to this role. For more information, consult the MSDN documentation regarding Roles and Permissions for Analysis Services.	This step is required.
6	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
7	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
8	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.
9	Update the existing Analysis Services Cube records so that GE Digital APM connects to the cube using the HTTP/ HTTPS access.	This step is required.

Upgrade from any version V3.5.0 through V3.5.0.0.7.1


Step	Task	Notes
1	Migrate your SQL Server Analysis Services database and cubes to the following supported SQL Server Analysis Services versions: 2012 2014	This step is required only if you were previously using SQL Server Analysis Services 2008 R2.
2	Configure SQL Server Analysis Server for HTTP or HTTPS access using basic authentication.	This step is required.
3	Deploy Work History Analysis Services database. This Work History cube is a replacement for the Equipment and Functional Location Work History cubes in the Meridium_Event_Analysis database.	Important: Before executing this step, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required.
4	Create a Windows User on the Analysis Server or in your organization’s Active Directory. The user name requires minimum privileges and will only be used by the GE Digital APM Server to connect to the cubes. It is recommended that: The password for this user should never expire. The user should be restricted to change password. The user should be restricted to log in to others servers (e.g.,meridium_ssas_user).	This step is required.
5	Add the user created in Step 4 to a role on all SQL Analysis Services databases that you want to access in GE Digital APM. The role should have read and drill-through permissions. If the Work History database already has a View role defined, then you should add the user to this role. For more information, consult the MSDN documentation regarding Roles and Permissions for Analysis Services.	This step is required.
6	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
7	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
8	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.
9	Update the existing Analysis Services Cube records so that GE Digital APM connects to the cube using the HTTP/ HTTPS access.	This step is required.

Upgrade from any version V3.4.5 through V3.4.5.0.1.4


Step	Task	Notes
1	Migrate your SQL Server Analysis Services database and cubes to the following supported SQL Server Analysis Services versions: 2012 2014	This step is required only if you were previously using SQL Server Analysis Services 2008 R2.
2	Configure SQL Server Analysis Server for HTTP or HTTPS access using basic authentication.	This step is required.
3	Deploy Work History Analysis Services database. This Work History cube is a replacement for the Equipment and Functional Location Work History cubes in the Meridium_Event_Analysis database.	Important: Before executing this step, ensure that the Security User who will run the Analysis Services Deployment Wizard has been granted View permissions to the cubes associated with the Metric Views, and that the cubes are active. This step is required.
4	Create a Windows User on the Analysis Server or in your organization’s Active Directory. The user name requires minimum privileges and will only be used by the GE Digital APM Server to connect to the cubes. It is recommended that: The password for this user should never expire. The user should be restricted to change password. The user should be restricted to log in to others servers (e.g.,meridium_ssas_user).	This step is required.
5	Add the user created in Step 4 to a role on all SQL Analysis Services databases that you want to access in GE Digital APM. The role should have read and drill-through permissions. If the Work History database already has a View role defined, then you should add the user to this role. For more information, consult the MSDN documentation regarding Roles and Permissions for Analysis Services.	This step is required.
6	Verify that your event and asset criticality data meet the standard classification requirements, and modify the views for the Work History cube as needed.	This step is required.
7	Localize the event and equipment values in GE Digital APM .	This step is required only if you want to localize the event and equipment values in the Work History cube.
8	Schedule cubes for processing on the SQL Server Analysis Server.	This step is required.
9	Update the existing Analysis Services Cube records so that GE Digital APM connects to the cube using the HTTP/ HTTPS access.	This step is required.

About Configuring a Cube for Usage Metrics Tracking

You can track the activity of the users in your system. Usage metrics are stored in the MI_SEC_LOG_EVENTS system table. When a user logs in to GE Digital APM, actions of the user are stored in batches for that session in the MI_SEC_LOG_EVENTS table.

The MI_SEC_LOG_EVENTS table records the following events:

Successful logins
Failed logins
Password changes
User account creation, activation, deactivation, modification
Session expiry

The following table describes the columns that exist in the MI_SEC_LOG_EVENTS table:

Column ID	Description
SECL_KEY	Stores the values that identify the events in the MI_SEC_LOG_EVENTS table.
SECL_EVENT_NM	Stores the names of the events.
SECL_USER_ID	Stores the user IDs of the users who attempt to log in to GE Digital APM.
SECL_ADMIN_ID	Stores the user IDs of the Administrators who create, update, and delete users.
LAST_UPDT_DT	Stores the value that identifies the date and time when a record was last updated.

Note: Usage metrics are recorded only for activities performed via GE Digital APM. Usage metrics are not recorded for activities performed in the GE Digital APM Administrative applications.

To view the usage metrics that have been tracked for your system, you must create a cube based upon the MI_SEC_LOG_EVENTS table. After you create the cube, you must join the MI_SEC_LOG_EVENTS and the MIV_MI_IS_A_USER tables. You must also join the MIV_MI_IS_A_USER and MIV_MI_HUMAN_RESOURCE tables.

Note: Before you use the cube in the Metrics and Scorecards module, you must enable usage metrics tracking via the Monitoring page in Configuration Manager .

About Scheduling Cubes for Processing

An Analysis Services cube is a combination of measures and dimensions that together determine how a set of data can be viewed and analyzed. A cube is a static object and initially represents the data that existed in Analysis Services for the selected measures and dimensions when the cube was created. To keep a cube current, it must be processed regularly, whereby the cube is updated with the most current data in Analysis Services.

To make sure that a cube always provides users with the most current data, you should schedule it for processing regularly, usually on a daily basis. One way to process cubes and shared dimensions successfully is to do so manually on the Analysis Server. Using this method, you can process shared dimensions first, and then process the related cubes. Processing cubes manually, however, is not a viable option if you have many cubes that you want to process on a daily basis.

Instead, a preferable option would be to schedule cubes for processing using Data Transformation Services (DTS). This functionality is available in the SQL Server Business Intelligence Development Studio, which is included in SQL Server Standard Edition. For details on creating a DTS package that can be used to process objects according to a custom schedule, see your SQL Server documentation.

Install SQL Server Analysis Services on the Server

SQL Server Analysis Services is the foundation for the GE Digital APM Metrics and Scorecards module because it serves as a storage and management mechanism for cubes, which can then be accessed and viewed via GE Digital APM. To support Metrics and Scorecards features, SQL Server Analysis Services must be installed on the machine that will serve as the Analysis Server. The Analysis Server must be set up as a machine that is separate from the GE Digital APM Application Server.

Where Does This Software Need to Be Installed?

SQL Server Analysis Services must be installed on the machine that will function as the Analysis Server. You do not need to install any SQL Server components on the Application Server to support the Metrics and Scorecards functionality.

Performing the Installation

SQL Server Analysis Services can be installed using the SQL Server Standard Edition installation package, which you may have received from GE Digital APM or from a third-party vendor, depending upon the licensing options you selected when you purchased the GE Digital APM product. Instructions for performing the installation can be found in the documentation included in the SQL Server Standard Edition installation package.

Creating the Analysis Services Database, Data Source, and Cubes

In addition to creating the Analysis Services database, data source, and cubes, the cubes must be processed before they will be available for use in the GE Digital APM system. For details on completing these tasks, consult your SQL Server documentation.

Migrate SQL Server Cubes

About this task

If you are upgrading from a previous version of GE Digital APM and you have existing Metrics and Scorecards objects (e.g., Metric Views and KPIs) that are based upon SQL Server 2005 or SQL Server 2008 R2 Analysis Services cubes, you may be able to migrate your cubes while maintaining the proper functioning of your existing GE Digital APM objects.

If you have SQL Server Server 2008 cubes, you must migrate them to SQL Server 2012.
If you have SQL Server 2012 cubes, you can migrate them to SQL Server 2014.

The following workflow provides a general overview of the process for migrating cubes from an older version of SQL Server Analysis Services to a newer version of SQL Server Analysis Services. For more details, you should see your SQL Server documentation.

Important: Depending upon the complexity of your cubes, you may or may not be able to migrate them successfully. We recommend that you attempt to migrate them using the following procedure. If you review the cubes after the migration and determine that the migration was not successful, the cubes will need to be rebuilt. In that case, any KPIs and Metric Views that were based upon those cubes must also be rebuilt.

Procedure

On the SQL Server Analysis Services Server where the older version of SQL Server Analysis Services is installed, open the SQL Server Management Studio window.
Connect to the SQL Sever Analysis Services database that you want to upgrade.
In the Object Explorer pane, right-click Databases, and select Backup.
The Backup Database - <Database Name> window appears, where <Database Name> is the name of the database that you want to upgrade.
To the right of the Backup file box, select the Browse button, and specify the location where the database will be backed up.
Specify any additional settings, and then select OK.
The selected database is saved to an .ABF file in the specified location.
Open the SQL Server Management Studio window for the new version of SQL Server Analysis Services.
In the Object Explorer pane, right-click Databases, and select New Database.
The New Database window appears.
In the Database name box, enter a name for the database that you are migrating to the new version of SQL Server Analysis Services.
Specify any additional settings, and then select OK.
The specified database is created, and a corresponding node appears in the Object Explorer pane.
Right-click the node representing the new database, and then select Restore.
The Restore Database window appears.
In the Backup file, enter the file path or select the Browse button and navigate to the database file that you backed up in step 5.
Specify an additional settings, and then select OK.
Your SQL Server Analysis Services database is migrated to the new SQL Server Analysis Services version.
In the GE Digital APM, in the Metrics and Scorecards module, modify the remaining properties of each Analysis Services Cube record, including selecting the appropriate new SQL Server Analysis Server. You can do by using the Manage Cubes page in the Metrics and Scorecards module.
View existing objects (e.g. Metric Views and KPIs) that are based upon the migrated cubes to ensure that the correct data is being displayed. If the correct data is not displayed, rebuild the cubes and the objects that are based upon them. For details on rebuilding cubes, see your SQL Server documentation.

Deploy the Work History Cube

Procedure

Create a copy of the Cubes folder from the Release CD to a folder in SQL Server Analysis Services Server.
In the copied Cubes folder, select the Work History folder.
The folder contains following files:
- Work History.asdatabase
- Work History.configsettings
- Work History.deploymentoptions
- Work History.deploymenttargets
Run the Analysis Services Deployment Wizard program.
The Welcome page appears.
Select Next.
When the wizard prompts you to choose the database file, navigate to the Work History folder, and then select the file Work History.asdatabase.
Run through all steps of the wizard to deploy the Work History database to SQL Server Analysis Services Server.
For more information, consult the MSDN documentation regarding Analysis Services Deployment Wizard.

About Modifying the Work History Cube

The baseline Work History cube provided with the Metrics and Scorecards module uses the following standard classifications for event and asset criticality data. If the event or asset criticality data in your database cannot be classified as one of following the standard IDs, the data, by default, will be classified as Unknown.

Event Type
- Standard Event Types
  - ID: Miscellaneous; Caption: Miscellaneous
  - ID: PM/PdM; Caption: PM/PdM
  - ID: Repair; Caption: Repair
  - ID: Unknown; Caption: Unknown
Event Breakdown Indicator
- Standard Event Breakdown Indicators
  - ID: N, Caption: N
  - ID: Y, Caption: Y
  - ID: Unknown, Caption: Unknown
Event Priority
- Standard Event Priorities
  - ID: 1, Caption: Very Low
  - ID: 2, Caption: Low
  - ID: 3, Caption: Medium
  - ID: 4, Caption: High
  - ID: 5, Caption: Emergency
  - ID: Unknown, Caption: Unknown
Event Detection Method
- Standard Event Detection Methods
  - ID: 0001, Caption: Continuous Condition Monitoring
  - ID: 0002, Caption: Corrective Maintenance
  - ID: 0003, Caption: Formal Inspection
  - ID: 0004, Caption: Operator Routine Observation
  - ID: 0005, Caption: Periodic Condition Monitoring
  - ID: 0006, Caption: Preventive Maintenance
  - ID: 0007, Caption: Production Interference
  - ID: 0008, Caption: Radar Operator Observation
  - ID: Unknown, Caption: Unknown
Asset Criticality Data
- Standard Asset Criticality Data
  - ID: A, Caption: High
  - ID: B, Caption: Medium
  - ID: C, Caption: Low
  - ID: Unknown, Caption: Unknown

Modify the Views for Work History Cube

If the event or asset criticality data in your database does not match the standard IDs used by the Work History cube, then you need to modify the views used for the Work History cube.

Before you begin

Log in to SQL Server Management Studio and connect to the database.
Verify the standard classification defined for event or asset criticality data.

Modify the Non Standard Event Type Data

Procedure

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
Verify if the results match the standard event type IDs defined by the Work History cube.
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.

Example

Suppose the distinct Event Types returned by the query run in Step 1 are Miscellaneous, Repair ,PM/PdM, and Inspection and if Inspection event in your data should be PM/PdM event, then modify the CASE statement in the View as follows:

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

Modify the Non Standard Event Breakdown Data

Procedure

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
Verify if the results match the standard event breakdown IDs defined by the Work History cube.
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.

Example

Suppose the distinct Event Breakdown returned by the query is Y, N, and No and if No in your data is should be N event breakdown, then you should modify the CASE statement in View as:

CASE MI_EVWKHIST_BRKDN_IND_F

 WHEN 'Y' THEN 'Y'

 WHEN 'N' THEN 'N'

 WHEN 'No' THEN 'N'

 ELSE 'Unknown'

END AS Breakdown

Modify the Non Standard Event Priority Data

Procedure

In the Views, select MIV_MI_FAC_WORK_HSTY view, and then run the following queries to check if the Event Breakdown 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
Verify if the results match the standard event priority IDs defined by the Work History cube.
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.

Example

Suppose the distinct Event Priorities returned by the query are 1, 2,3, 4,5, and M and if M in your data should be event priority 3, then you should modify the CASE statement in View as:

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

Modify the Non Standard Event Detection Method Data

Procedure

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

SELECT distinct MI_EVWKHIST_DETCT_MTHD_CD_C from MI_EVWKHIST
Verify if the results match the standard event detection method IDs defined by the Work History cube.
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.

Example

Suppose distinct Event Detection Methods returned by the query are 0001, 0002,0003, 0004,0005,0006,0007,0008, and 0009 and if 0009 in your data should be 0001 event detection method, then you should modify the CASE statement in View as:

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

Modify the Non Standard Equipment Criticality Data

Procedure

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
Verify if the results match the standard event detection method IDs defined by the Work History cube.
If the results do not match, then modify the case statement CASE MI_EQUIP000_CRITI_IND_C in the view to display standard event detection method IDs.

Example

Suppose distinct Equipment Criticality returned by the query in Step 1 is A, B, C, and H and if H in your data is actually A equipment criticality ID, then you should modify the CASE statement in the View as:

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

Modify the Non Standard Functional Location Equipment Criticality Data

Procedure

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
Verify if the results match the standard event detection method IDs defined by the Work History cube.
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.

Example

Suppose the distinct functional location criticality returned by the query in Step 1 is A, B,C, and M and if M in your data should be B functional location criticality ID, then you should modify the CASE statement in the View as:

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

Localize the Event or Asset Criticality Values

By default, the Meridium Work History cube displays the event and asset criticality data in English. However, you can modify the event or asset criticality values to other languages supported by GE Digital APM. The examples in this topic explain how to modify event and asset criticality values, and how you can verify, in GE Digital APM, that those modifications have been implemented.

Before you begin

Example: Localize the Event Type Values

Procedure

In the Tables, select the table MI_DIM_EVENT_TYPE.
The table values appear, displaying the event type ID and the event caption.
In the EventTypeCaption column, select the cell for the event type that you want to localize, and then manually modify the caption.
Save the modification, and then process the cube.
Log in to GE Digital APM.
Access the Metrics and Scorecards page and create a new Metric View.
The design page for the Metric View appears.
In the Metric Views design page, in the Rows/X-Axis subsection, select .
The Add to Rows window appears.
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.

Example: Localize the Event Breakdown Values

Procedure

In the Tables, select the table MI_DIM_EVENT_BREAKDOWN.
The table values appear, displaying the breakdown ID and the breakdown caption.
In the BreakdownCaption column, select the cell for the breakdown that you want to localize, and then manually modify the caption.
Save the modification, and then process the cube.
Log in to GE Digital APM.
Access the Metrics and Scorecards page and create a new Metric View.
The design page for the Metric View appears.
In the Metric Views design page, in the Rows/X-Axis subsection, select .
The Add to Rows window appears.
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.

Example: Localize the Event Priority Values

Procedure

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

Example: Localize Event Detection Method Values

Procedure

In the Tables, select the table MI_DIM_EVENT_DETECTION_METHOD.
The table values appear, displaying the event type ID and the event caption.
In the DetectionMethodCaption column, select the cell for the detection method that you want to localize, and then manually modify the caption.
Save the modification, and then process the cube.
Log in to GE Digital APM.
Access the Metrics and Scorecards page and create a new Metric View.
The design page for the Metric View appears.
In the Metric Views design page, in the Rows/X-Axis subsection, select .
The Add to Rows window appears.
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.

Example: Localize Equipment Criticality Values

Procedure

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

Example: Localize Functional Location Criticality Values

Procedure

In the Tables, select the table MI_DIM_ASSET_CRITICALITY.
The table values appear, displaying the criticality ID and the criticality caption.
In the CriticalityCaption column, select the cell for the caption that you want to localize, and then manually modify the caption.
Save the modification, and then process the cube.
Log in to GE Digital APM.
Access the Metrics and Scorecards page and create a new Metric View.
The design page for the Metric View appears.
In the Metric Views design page, in the Rows/X-Axis subsection, select .
The Add to Rows window appears.
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.

Metrics and Scorecards Security Groups and Roles

The following table lists the baseline Security Groups available for users within this module, as well as the baseline Roles to which those Security Groups are assigned.

Important: Assigning a Security User to a Role grants that user the privileges associated with all of the Security Groups that are assigned to that Role. To avoid granting a Security User unintended privileges, before assigning a Security User to a Role, be sure to review all of the privileges associated with the Security Groups assigned to that Role. Also, be aware that additional Roles, as well as Security Groups assigned to existing Roles, can be added via Security Manager.


Security Group	Roles
MI Metrics Administrator	MI Foundation Admin MI APMNow Admin
MI Metrics User	MI Foundation Power MI Foundation User
MI Metrics Viewer	MI APM Viewer
Everyone	MI Foundation Admin MI Foundation Power MI Foundation User

The baseline family-level privileges that exist for these Security Groups are summarized in the following table.


Family	MI Metrics Administrator	MI Metrics User	MI Metrics Viewer
Entity Families
Analysis Services Cube	View, Update, Insert, Delete	View	View
KPI	View, Update, Insert, Delete	View, Update, Insert, Delete	View
KPI Measurement	View, Update, Insert, Delete	View, Update, Insert, Delete	View
Scorecard	View, Update, Insert, Delete	View, Update, Insert, Delete	View
Relationship Families
Has KPI Measurement	View, Update, Insert, Delete	View, Update, Insert, Delete	View
Has Privileges	View, Update, Insert, Delete	View, Update, Insert, Delete	View
Has Sub Indicators	View, Update, Insert, Delete	View, Update, Insert, Delete	View
Is Used By Scorecard	View, Update, Insert, Delete	View, Update, Insert, Delete	View

In addition to performing functions associated with the family-level privileges described in this table, members of the MI Metrics Administrator Security Group:

Can manage cube privileges by granting view access to the users.
Has full access to all KPIs, Scorecards, and Cubes without needing to be granted additional privileges via the GE Digital APM.