Row by Row Comparison (SSAS OLAP) Wizard

The Row by Row Comparison (SSAS OLAP) Wizard allows you to connect to your Microsoft Analysis Services running on SQL Server (SSAS) or Azure to create reconciliation tests for the row by row comparison module. Tosca BI supports both the Tabular and Multidimensional Model.

Test scenarios

Typical test scenarios for the Row by Row Comparison (SSAS OLAP) Wizard are:

  • Data coming from a non-SSAS source system into SSAS and then verifying the correct arrival of data.

  • Data from SSAS is shown in business reports applications and reconciliation between report data and SSAS data is required.

  • Data within SSAS where SSAS is both data source and data target.

For the above scenarios the Wizard allows you to fill out the SSAS part and select dimensions and measures. If you want to connect to other sources than SSAS, fill in the resulting test step manually.

To use the Row by Row Comparison (SSAS OLAP) Wizard, import the Tosca BI Modules And Samples.tsu subset.

Run Reconciliation: Row by Row Comparison (SSAS OLAP) tests

To perform Row by Row Comparison (SSAS OLAP) tests, follow the steps below:

  1. Open the Reconciliation: Row by Row Comparison (SSAS OLAP Wizard. To do so, select a BI folder and click Row by Row Comparison in the dynamic menu BI Testing. Select Row by Row Comparison (SSAS OLAP) from the dropdown menu.

    Alternatively, right-click a BI folder and select Tosca BI->Reconciliation: Row by Row Comparison (SSAS OLAP) from the context menu or press CTRL+W, CTRL+O.

Access the Reconciliation: Row by Row Comparison (SSAS OLAP Wizard via the BI Testing menu

  1. The Wizard guides you through the TestCase creation:

  2. Once you have performed Options, the Wizard window closes. Tosca automatically adds a Reconciliation: Row by Row Comparison TestStep.

  1. In the TestStep, navigate to General Options->Error Reporting.

    • To determine whether the system should check both source and target for duplicates, set the according ValueRange for Report Unmatched Target Rows.

      Set ValueRange to True if you want to check both source and target. Set it to False if you only want to check the data source for duplicates.

    • To determine the number of errors the system accepts before it aborts the comparison, set a numeric value for Max Errors.

  2. Adjust your source SQL statement to account for any formatting discrepancies between the two data sources. If you have a Tosca BI license, you can use the SQL Editor to create and test SQL statements before you run your TestCase.

  3. Define how Tosca BI should handle mismatches as described in chapter "Generate error reports".

  4. To execute your TestStep, select Run from the context menu. For more information, see chapter "Execute the test".