Advanced Options: SQL/MDX

The options in the SQL/MDX category of the Advanced Options dialog box control how certain parts of a report's SQL are compared. These options are disabled in a single-project integrity test, since they only affect report comparison.

The document and dashboard SQL mode does not support the advanced options for SQL and MDX.

Select the Save color-coded SQL differences to an HTML file check box to save the generated SQL for each report to an HTML file. In a comparative integrity test, the generated SQL is saved for each project. SQL that is different between the two projects is highlighted in red in the file. For more information about the files that are saved for an integrity test, see Accessing the saved results of a test.
The Dynamic SQL Start and End fields indicate the presence of dynamic SQL in reports. Enter the beginning of the dynamic SQL in the Start field and the end of the dynamic SQL in the End field. Any text between these strings in a report (including the strings themselves) is not considered in the comparison.
The SQL Replacement Table stores replacements that Integrity Manager will make in the generated report SQL for the comparison. Strings in the From column are replaced by the corresponding strings in the To column. The Apply To drop-down list controls whether a given replacement is made in the base report, the target report, or both the base and the target reports.

The changes made by the SQL Replacement Table are not stored in the <ID>_<GUID>.sql files for each report. Rather, Integrity Manager stores those changes in memory when it executes the integrity test.

SQL is replaced in the order that the replacements are listed in the table. Click Up or Down to move selected entries in the table.

Advanced Options: SQL/MDX

Related Topics