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.
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.
Steps
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.
Copyright © 2018 General Electric Company. All rights reserved.