Upgrade or Update Metrics and Scorecards to V4.3.0.5.0
The following tables outline the steps that you must complete to upgrade this module to V4.3.0.5.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.
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.
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.
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.
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.
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 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 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 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 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 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.
