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 values returned.

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 2012
  • SQL Server 2016
  • SQL Server 2017
  • SQL Server 2019

Services

KC cube
Training
KC cube
Consultancy
KC cube
Implementation
For more information, please contact our sales team.

Are you ready to test our product?

Register for free trial

Or book a call to find out how Kubikos Compare can help you and your company.

Publisher

SCON GmbH develops and operates IT applications, infrastructures and services for the digitalization of companies.

The service range consists of mobile, virtual work space, but also of secure, highly available dynamic computer center infrastructures – in cloud environment and on premise.

Visit SCON website
Company logo