Regression testing tool for Microsoft SQL Server Analysis Services
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.
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.
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.
Queries are categorized based on the individual results and deviations are marked to support the interpretation of information gathered.
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
Are you ready to test our product?
Register for free trialOr book a call to find out how Kubikos Compare can help you and your company.