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.
Or book a call with our sales team and find out how Kubikos Compare can help your company.