MicroStrategy ONE

Creating an Integrity Test

The following high-level procedure provides an overview of the steps involved in creating an integrity test. For an explanation of the information required at any given page in the wizard, see the Help (from the wizard, click Help, or press F1).

To Create an Integrity Test

  1. Start Integrity Manager. Start > All Programs > MicroStrategy Products > Integrity Manager.
  2. From the File menu, select Create Test.
  3. Select the type of test you want to create:
    • To compare reports and documents from two projects, select Project versus project.
    • To compare reports and documents against a previously established baseline, select Baseline versus project.
    • To compare reports and documents from two previously established baselines, select Baseline versus baseline.
    • To confirm that reports and documents in a project execute without errors, select Single project.
  4. Specify the baselines and projects to be tested. For each project, provide a MicroStrategy login and password with the Use Integrity Manager privilege for that project.
  5. Select the reports and/or documents to be tested. You can select individual reports or documents, or entire folders. You can also select search objects; in this case, Integrity Manager tests all reports and documents from the results of the search object.

    If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. Integrity Manager can test the SQL of Intelligent Cubes even if they have not been published, but cannot test Intelligent Cube reports based on an unpublished Intelligent Cube.

  6. Specify test execution options, such as how to answer any unanswered prompts, what details to log, and whether to use report caches.
  7. Select what types of analysis to perform. For reports, you can analyze any or all of the grid data, underlying SQL, graph data, Excel export, or PDF output. For documents you can analyze the Excel export or PDF output.

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

    You can also select to record the execution time of each report and/or document, to analyze the performance of Intelligence Server.

  8. Review the information presented on the Summary page.
  9. Click Save Test. Navigate to the desired directory, enter a file name, and click OK.

    For instructions on executing a saved test, see Saving and Loading a Test.

  10. To execute the test immediately, regardless of whether you saved the settings, click Run. The Integrity Manager Wizard closes and Integrity Manager begins to execute the selected reports and documents. As the reports execute, the results of each report or document appear in the Results Summary area of the Integrity Manager interface.