MicroStrategy Integrity Manager is an automated report and document comparison tool that is designed to increase the accuracy of business intelligence applications by validating data and report integrity, which are susceptible to even minor changes elsewhere in the BI system.

Companies often lack sufficient resources to detect anomalies or unexpected changes and monitor them manually. MicroStrategy Integrity Manager automates the comparison and verification not only of report and document consistency but also of intelligent cubes. It highlights issues and discrepancies to ensure the overall reliability of the BI content, reducing the need for resource-intensive manual testing.

The common types of changes that require report and data validation include:

• Software upgrades: MicroStrategy Integrity Manager ensures that database and BI software upgrades designed to address defect fixes and enhancements do not impact report integrity, and that inconsistencies are identified so they can be corrected prior to being viewed by business users.
• BI project migrations: As part of the normal BI development life cycle, developers continuously migrate entire BI projects or project objects across the development, test and production environments. Administrators need to confirm that migrated objects perform as expected and do not negatively impact existing BI reports.
• Data warehouse ETL processes: Data loads and ETL scripts can modify or even corrupt existing information within the data warehouse. Database administrators require certainty that the ETL processes are successfully completed, without altering previously loaded data and introducing inconsistencies to BI reports and content.
• Database optimizations: System tuners can alter existing database objects and report parameters, or add new objects such as indexes and aggregate tables to improve report performance and system throughput. Developers need to ensure that subtle SQL changes and database alterations made for performance do not alter query results.