Version 2021

MicroStrategy Integrity Manager

MicroStrategy Integrity Manager is an automated tool designed to streamline the testing of MicroStrategy projects. This tool can determine how specific changes in a project environment, such as the regular maintenance changes to metadata objects or hardware/software upgrades, affect the reports or documents in that project.

Integrity Manager can compare reports and highlight any differences, confirm that reports and documents remain operational after changes to the system, and note whether or not any or all reports/documents execute and display their results.

Integrity Manager can also test the performance of an Intelligence Server by recording how long it takes to execute a given report or document. You can execute the reports or documents multiple times in the same test and record the time for each execution cycle to get a better idea of the average Intelligence Server performance time.

  • To execute an integrity test on a project, you must have the Use Integrity Manager privilege for that project. For information on user privileges, 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.

Integrity Manager Overview

When you start Integrity Manager, you are presented with an empty interface.

  1. Select Create Test.
  2. Specify what kind of test to run, what reports to test and the execution and output settings.
  3. Execute the test immediately or save the test for later use and re-use. For detailed instructions on Intelligence Server performance testing, see Testing Intelligence Server performance.
  4. Information about the test's execution can be found in the main Integrity Manager window. You can see a summary of the test results in the Results Summary area and detailed information about each individual report in the Report Data area.
  5. You can also execute a test from the command line, without opening the graphical interface. For instructions, see Executing a saved test from the command line.