1. What is MicroStrategy Integrity Manager?
MicroStrategy Integrity Manager is an automated report comparison tool. Report SQL, data, and graphs are compared to help customers verify data integrity when intended or unintended changes are introduced in the BI ecosystem. The report comparison output can be analyzed in the MicroStrategy Integrity Manager graphical interface, or in an HTML output file that can be shared by other users.

2. What does MicroStrategy Integrity Manager do?
Administrators create tests in MicroStrategy Integrity Manager that define which reports should be compared during a test run. The results can be compared between two BI applications or between one BI application and a previously stored set of "baseline" results. Differences in report data, SQL, and graphs level are displayed in a graphical interface and are saved in HTML files.

3. What are the main uses of MicroStrategy Integrity Manager?
MicroStrategy Integrity Manager provides ongoing auto-detection of anomalies before your users see them. This auto-detection ensures that all critical reports are correct every day, and thus provides information assurance to your BI users. MicroStrategy Integrity Manager also provides targeted regression testing for all planned changes and dramatically reduces the time and manpower required to deploy any change in the BI environment.

4. How long does it take to set up and run a MicroStrategy Integrity Manager test?
Administrators can create a simple yet extremely powerful MicroStrategy Integrity Manager test in a few minutes using the Test Creation Wizard. For example, creating a test that compares two entire projects is as simple as connecting directly to the Base and Target projects, selecting the entire project’s reports with one click, and then running the test.

5. Can I run MicroStrategy Integrity Manager against previous version of MicroStrategy?
Yes. MicroStrategy Integrity Manager is able to connect to any project running on a previous version of MicroStrategy. MicroStrategy Integrity Manager has been tested against all MicroStrategy versions that are presently supported.

6. How can I get MicroStrategy Integrity Manager?
MicroStrategy Integrity Manager is a new product and can be purchased through your account manager or by contacting sales at info@microstrategy.com.

7. How do I install MicroStrategy Integrity Manager?
MicroStrategy Integrity Manager in included from MicroStrategy 8 Release 11 onwards. This release includes the 8.1.1 version products.

8. How does MicroStrategy Integrity Manager integrate with the rest of the MicroStrategy platform?
MicroStrategy Integrity Manager connects to and executes reports through MicroStrategy Intelligence Server. The results are passed back to Integrity Manager for comparison and analysis, and stored in the baseline files.

9. On which operating systems can MicroStrategy Integrity Manager be installed?
MicroStrategy Integrity Manager is supported on both Windows® and UNIX operating systems. Please consult the product Readme files for the specific operating systems and versions that are supported.

10. Is MicroStrategy Integrity Manager available in other languages?
Yes. The MicroStrategy Integrity Manager interface is available in multiple languages. Please review the product Readme files for the latest language support information.

11. Where are the baseline files stored?
The baseline files can be stored in any location. The default location is within a newly created folder, aliased with a date-time stamp, in the "Integrity Manager" folder under Program Files – MicroStrategy.

12. What format are the baseline files stored in?
The baseline results are a combination of .xml summary files and individual files for each report for the SQL (in .sql format), the data (in .ser and .csv format), and the graph (in .png format).

13. Can I use MicroStrategy Integrity Manager as a stress testing product?
MicroStrategy Integrity Manager is a report comparison tool. The product is designed to compare for differences from one environment to another, highlight these differences, and perform additional analysis on these test results. MicroStrategy Integrity Manager should not be used for either stress testing or concurrency testing.

14. Can I test for changes between one version of a Data Warehouse and another?
Yes. MicroStrategy Integrity Manager can be used to compare differences from a project pointing towards different versions of Data Warehouse. MicroStrategy Integrity Manager can verify success after any changes to your BI ecosystem, including (but not limited to):

• Data Warehouse load routines and ETL processes
• Metadata object promotions from development to test to production systems
• MicroStrategy software version upgrades
• 64-bit operating system upgrades
• Database version or platform changes

15. Does MicroStrategy Integrity Manager support reports created against MDX based data sources?
Yes. MicroStrategy Integrity manager can execute and compare reports created against SAP® BW, Hyperion® Essbase™, and Microsoft Analysis Services™ cubes.

16. How can I set up a test to run in off-peak hours?
A MicroStrategy Integrity Manager test includes parameters for connectivity information, report selection, execution, and logging settings, all of which can be saved in an MTC file. MicroStrategy Integrity Manager can be launched through the operating system command prompt using the MTC file as the input parameter for the test. Administrators can use a batch file to trigger Integrity Manager tests during off-peak hours.