MicroStrategy ONE

Comparing Two Previously Established Baselines

In a baseline-versus-baseline integrity test, Integrity Manager compares reports or documents from two previously established baselines. These baselines can be established by running single project integrity tests or from previous executions of project-versus-project or baseline-versus-project integrity tests.

Baseline-versus-baseline integrity tests are used in situations like:

  • Comparing baselines from existing tests that were not originally executed against each other. For example, you have an existing baseline from a single-project test of the production project, and the results of a project-versus-project test on the development and test projects. In this situation, you can use a baseline-versus-baseline test to compare the production project to the test project.
  • Comparing projects that have existing baselines, without putting additional stress on the Intelligence Servers.
  • Comparing two single-project performance tests, to get an accurate representation of the difference between their performance.

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 first create the baselines. For instructions, see Testing report execution in a project.

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

To Compare Two Previously Established Baselines

  1. Start > All Programs > MicroStrategy > Integrity Manager.
  2. Select the File menu > Create Test.
  3. Select Baseline Versus Baseline > Next.
  4. The Select Baseline page opens. Enter the information required on each page.
  5. Review the information on the Summary page.
  6. Click Save Test.
  7. 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