...

Analysis services is run on the same server as the Financial Analysis Services. Any changes done to our analysis services related operations needs to be tested for impacts to the server as a whole.

Migration Process

Database and Analysis Services Updates

• Database and Analysis Services updates are completed in the development servers by Metricus consultant.

• Metricus consultant verifies updates are working as expected.

• Metricus consultant creates migration scripts.

• Metricus consultant uses migration scripts to move the updates to the test environment.

• Metricus consultant verifies updates in test environment.

• Yale Service Management Team verifies updates in test environment.

• Yale Service Management team creates change task for migration to production and assigns to Database Administration team.  This task needs to be assigned two weeks before migration.

• Yale Service Management Team attaches migration scripts to migration task.

• Database Administration team uses the migration scripts to move the updates to production.

• Yale Service Management Team verifies updates in the production system.

Report creation and updates

• User creates reports in development instance.

• User migrates report to test instance.

• User verifies report data and performance.

• Yale Service Management Team creates change task and assigns it to the Reporting and Analytics Service.  This should be two weeks before migration.

• Yale Service Management Team will attach the PBIX to the change task.

• Reporting and Analytics Service will migrate the report to production.

• User and Yale Service Management Team will verify report.