Detect, Compare, and Highlight Variances in Data and Reports Caused by Any Changes in the BI Environment

MicroStrategy Integrity Manager executes and analyzes report output to highlight unmatched results in data, SQL, and graph output. MicroStrategy Integrity Manager can test all reports or a subset of reports in a BI application. Reports are included through individual selection, folder selection, referenced through shortcuts, or dynamically selected at a runtime that is determined by search results.

Automate Testing for Any or All Reports

MicroStrategy Integrity Manager provides administrators with automated report comparison and change analysis. This alleviates the previously limiting and labor intensive manual comparison of key reports to verify software upgrade, object migration, or BI system change success. MicroStrategy Integrity Manager runs thousands of reports to verify change success and highlights only the small percentage of reports that need additional analysis and clarification.

Identify Any Differences in Report Data, SQL, or Graphing Output Using Sophisticated "Impact-analysis"

The analysis and comparison results are intuitively displayed for administrators and developers on a report-by-report basis. In addition to reducing the workload by only highlighting reports that need additional analysis, any and all differences within each report are explicitly highlighted at the cell level.

Compare Test Results Between a BI Application with Previously Stored “Baseline” Results, or with Another BI Application

Administrators can configure MicroStrategy Integrity Manager tests to compare a MicroStrategy project (as the selected base project) directly against another MicroStrategy project (as the selected target project). In this case, reports included in the test are run in both environments before being compared. Administrators may also compare a MicroStrategy project against a snapshot of previously stored baseline results. During each MicroStrategy Integrity Manager test, results are stored for future analysis and are also available for use as a baseline result set.

Distribute Integrity Manager Results to Any Number of Users, Developers, or Administrators

Create Report Comparison Tests Through Selection Of Multiple Object Types

MicroStrategy Integrity Manager, through an intuitive Test Creation Wizard, can generate powerful tests using any of the BI application objects below. These tests can include individually selected reports, all the reports inside a folder, or all the reports inside a project. Additionally, MicroStrategy Integrity Manager empowers users to include their critical reports for testing by placing Shortcuts into Folders that are tested regularly. This reduces the burden on IT administrators to determine which reports need to be tested while ensuring any essential reports are 100% accurate.

BI Application Objects:

Create Dynamic Report Comparison Tests Using Searches

MicroStrategy Integrity Manager dynamically resolves which reports to include in each test on the fly. When a Search Object is selected, the list of reports returned by that search are determined at runtime and included in the test. Searches included in the test provide flexible, unlimited dynamic report selection across the entire project. For example, with the inclusion of searches, MicroStrategy Integrity Manager tests can dynamically include:

• all reports modified in the last specified number of days
• all reports across the entire project that are dependent on a recently changed enterprise object such as a modified metric definition
• all reports owned by executive users within the organization

Generate Powerful, Dynamic Report Comparison Tests

The administrator has complete freedom to design tests that account for different change scenarios. Tests are intuitively created using the Test Creation Wizard. Administrators can quickly and easily follow steps to create powerful MicroStrategy Integrity Manager tests connecting to baseline files and projects, selecting objects to be included in the test, and specify runtime execution settings.