Regression testing tool for Microsoft SQL Server Analysis Services

Generate, execute and validate your data.
Compare app mockup

Overview

Kubikos Compare (KC) is a regression testing tool for Microsoft SQL Server Analysis Services cubes which facilitates the implementation of changes during development and productive use by offering a variety of options to set up queries and comparing results.

The tool compares a Microsoft SQL Server Analysis Services cube, on which changes were made, with a referenced or validated cube or previously saved query results and detects deviations in the structure or the measures of this cube.

Generating Query Sets

The generated QuerySet ensures a sufficient coverage of all selected parts of the cube to identify deviations Generated QuerySet be modified by adding custom MDX queries.

A QuerySet is a list of queries used to compare measures of one cube with measures of another cube. With KC you can create queries manually or you can use the Query Generator, which will create a randomized QuerySet for a selected cube.

query wizard query generate
scroll to top
query compare query schedule

Query Compare

The Query Compare addresses the resulting values for aggregated measures in reports and therefore the aggregation process.

After creating a QuerySet you can start with the Query Compare by selecting cubes or previously saved results to compare with each other.

Query Results

Queries are categorized based on the individual results and deviations are marked to support the interpretation of information gathered.

query result
*Query result showing a deviation in the values returned.
query result 1

Features

Query Generation

  • Specify the parts of the cubes to be compared by excluding:

         - measures,
         - dimensions,
         - hierarchies or
         - levels from hierarchies from the comparison
  • Specify if queries are being generated based on member names or member keys
  • Specify the measure dimension in case the measures are displayed in a custom dimension
  • Allow a percentage deviation for successful compares. This allows to cover changes in sources
  • Option to add your own queries to generated Query Sets

Query Compare

  • Specify if the execution should be stopped in case the number of queries with deviations exceeds a certain value
  • Stop the query execution manually
  • Resume stopped queries at any time
  • Rerun failed queries
  • Compare Analysis Services Cubes or saved query results from the same QuerySet in any combination
  • Scheduled execution of query compares
  • Specify if empty and zero values should be treated equally

Query Result

  • Overview on successful, failed and not executed queries
  • Failed queries are assigned to four categories to facilitate analysis:

         - failed result – deviation is greater than allowed
         - failed member – members are missing
         - failed dimension – dimensions are missing
         - failed connection – infrastructure problems
  • Print the results to a PDF file to distribute the results if recipients do not have access to the application and other documentation purposes

Supported Microsoft SQL Server versions

  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2016
  • SQL Server 2017
  • SQL Server 2019
  • SQL Server 2012

Services

KC cube
Training
KC cube
Consultancy
KC cube
Implementation
Contact our sales team for more information regarding these topics.

Are you ready to test our product?

Register for free trial

Or book a call with our sales team and find out how Kubikos Compare can help your company.