KB16775: How to create a single project integrity test in MicroStrategy Integrity Manager 9.x - 10.x

In a single-project integrity test, Strategy Integrity Manager 9.4.x - 10.x tests the execution of any or all of the reports in a project. This is useful when changes have been made somewhere in the system, and users want to ensure that none of the changes cause execution errors in the reports.
 
Some examples of such changes include:
 

• Modifying the data warehouse ODBC information (executing against a different warehouse).
• Modifying the data warehouse user configuration, for example, logging in as a different RDBMS user with different privileges or views.
• Performing warehouse maintenance, for example, deleting presumably unused tables, and so on.
• Migrating the project's Strategy Intelligence Server to a different operating system.
• Upgrading to a new version of Strategy.
• Altering the project schema.
• Making changes to Strategy user Access Control Lists (ACLs) or privileges.
• Modifying the project-wide VLDB settings.

In a single-project integrity test, Strategy Integrity Manager executes the specified reports. It then displays a list of the reports along with whether the execution of each report was successful or failed. If the execution failed, users can view the details of the report in the Report Data area of Strategy Integrity Manager to see why it failed.
 
A single-project integrity test can also generate a baseline for a baseline versus project integrity test.
 
Prerequisites for testing reports in a project
 

• To execute an integrity test on a project, users must have the 'Use Integrity Manager' privilege for that project. Users must also have the Execute permission for any reports they wish to test. For information on privileges and permissions, see the Strategy System Administration Guide.
• Strategy Integrity Manager can only test three-tier projects, that is, projects that are attached to a Strategy Intelligence Server. Projects in Direct Connection (two-tier) mode cannot be tested with this tool.

To compare reports from a single project:
 

• Open Strategy Integrity Manager (from the Start menu > Programs > Strategy > Integrity Manager).
• From the File menu, select Create Test. The Integrity Manager Wizard opens and the Welcome page is displayed, as shown below:
  

• Select the Single Project test and click Next, as shown below:
  

• In the Server Name field, specify the name of the Strategy Intelligence Server machine on which the project resides. This project contains the reports to be tested. The Integrity Manager Wizard automatically populates the Server Port field. If Strategy Intelligence Server is running on a different port, enter that port number in the Server Port field, as shown below:
  

• From the Authentication drop-down list, select the type of authentication to use with the login and also provide a Strategy Login and Password to connect to the project.
• From the Project drop-down list select the project and click Next.
• Select the reports to be compared and click Next, as shown below:
  

• To provide a default answer for one of the three types of value prompt, in case that the selected reports have value prompts, select its check box and then enter the desired default answer in its field. Other types of prompts are answered automatically. For more information about value prompts, see the Strategy Basic Reporting Guide.
• The user will be presented with some execution settings that he can adjust depending on their environment, as shown below:
  

• Max Timeout: Enter the maximum number of minutes for a report to finish executing.
  Note: If the timeout setting for Strategy Intelligence Server is less than Strategy Integrity Manager timeout setting, reports may time out before the time allotted in this field.
   
  
• Concurrent Jobs: Enter the maximum number of reports to execute at the same time.
   
  Warning: Setting this number higher than the default value, especially on a Strategy Intelligence Server that is being used in production, may cause an extreme load on Strategy Intelligence Server. This may cause your reports to time out or, in severe cases, may cause the Strategy Intelligence Server to shut down unexpectedly.
   
  
• Output Directory: Specify the location in which the results of the test are stored. To store the results of the test in a location specified by the date and time of execution, select the Store output in a time-stamped subfolder of this directory option.
• Logging Options: To enable logging, select the Enable logging check box. Specify the name and location of the log file in the field below the check box and click Next.
• Select the type of report data for Strategy Integrity Manager to analyze. More than one may be selected.
   
  
• To analyze the generated SQL for each report, select Compare SQL.
• To analyze the grid data for each report, select Compare Data.
• To analyze the generated graph for each report, select Compare Graph.
• To analyze the PDF and Excel output, select the appropriate checkboxes. 
•  
  Note: Only reports that have been saved in Graph or Grid/Graph view can be compared as graphs.
   
  
• Click Next. The Summary page opens where users can review the information presented. To make changes, click Back until the page that contains the information that needs to be changed is displayed.
• When users are satisfied that the test settings shown on the Summary page are correct, click Run. The Integrity Manager wizard closes and Strategy Integrity Manager begins to execute the selected reports. As the reports execute, the results of each report appear in the Results Summary area of the Strategy Integrity Manager interface, as shown below:
  

To save the test for later use, go to File > Save Test. Navigate to the desired directory, enter the file name, and click OK. A baseline file will also be saved in order to compare the reports contained on it against an online project.