Deploy Metrics and Scorecards for the First Time

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 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.

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.

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:

  1. Install SQL Server Analysis Services.
  2. 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.

  3. 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 other servers (e.g., meridium_ssas_user).
  4. Add the user created in Step c 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.

  5. 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 recordsfor 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.

Related Information

Copyright © 2018 General Electric Company. All rights reserved.