MicroStrategy ONE

Comparing Reports/Documents from Two Projects

In a project-versus-project integrity test, Integrity Manager executes reports and documents from two different projects and compares them to see any differences. This is different from a baseline-versus-project integrity test, where reports/documents from a project are compared with previously tested reports/documents.

Project-versus-project integrity tests are used in situations like:

  • Moving a project from one environment to another, for example, out of development and into production
  • Modifying the data warehouse ODBC information (executing against a different warehouse)
  • Migrating the Intelligence Server to a different operating system
  • Upgrading to a new version of MicroStrategy

In a project-versus-project integrity test, you designate one project to be the base project. Integrity Manager executes the specified reports/documents from this project and then executes them in the target project.

For reports, you can compare the report data, generated SQL code, graphs, Excel output, and PDF output. For documents, you can compare the Excel output or PDF output of the documents or test the execution of the documents without exporting the output. Integrity Manager informs you which reports/documents are different between the two projects and highlights in red the differences between them.

Only reports that have been saved in Graph or Grid/Graph format can be compared as graphs.

You must have the Use Integrity Manager privilege for both projects and the Execute permission for any reports or documents that you want to test. For information on privileges and permissions, see the Setting Up User Security chapter of the System Administration Guide.

Integrity Manager can only test projects in Server (three-tier) mode. Projects in Direct Connection (two-tier) mode cannot be tested with this tool.

To test the Excel export of a report or document, you must have Microsoft Excel installed on the machine running Integrity Manager.

To Compare Reports/Documents from Two Projects

  1. Start > All Programs > MicroStrategy > Integrity Manager.
  2. Select the File menu > Create Test.
  3. Select Project Versus Project > Next.
  4. Enter the information required.
  5. Click Save Test.
  6. Click Run to execute test. The results of each execution appear in the Results Summary area of the Integrity Manager interface. For detailed information about the results of the test, see Viewing the results of a test.

Related Topics

Viewing the Results of a Test

Analyzing a Tested Report or Document

Tests that can be Performed in Integrity Manager

Using the Integrity Manager Wizard