In Strategy Integrity Manager 10.x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. This will work as a regular SQL comparison. In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:
The results will appear on the SQL/MDX tab once the comparison takes place:
Note. Reports based on Intelligent Cubes can be compared as well. If the user wants to compare those, the Intelligent Cube used for the report has to be published before the test takes place. Integrity Manager can test the SQL of Intelligent Cubes even if they have not been published, but cannot test Intelligent Cube reports based on an unpublished Intelligent Cube.
