MicroStrategy has announced its plans to launch MicroStrategy Integrity Manager, a new product that tests the accuracy of BI applications by validating data and report integrity.
MicroStrategy Integrity Manager automatically compares and verifies the consistency of reports as changes are made to the BI ecosystem, and then highlights issues and discrepancies to monitor the overall reliability of the BI content used by business decision makers. This product will be introduced today at the MicroStrategy Symposium in London.
Companies typically monitor the integrity of their BI data through manual data validation. However, despite the increasing importance of BI applications, BI support teams often lack the necessary resources to ensure that data or software integrity problems have not been unexpectedly introduced during data loads or software upgrades.
Additionally, in self-service BI systems where end users create their own reports, many companies fail to perform validation testing on the large number of user generated reports. MicroStrategy Integrity Manager automatically reviews the integrity of data across an organisation’s BI system, verifying that BI reports and analyses are based on reliable data.
MicroStrategy Integrity Manager reduces the need for resource-intensive manual testing by comparing versions of reports after data updates and throughout the BI development cycle, thereby automating report regression testing. Data inconsistencies can be captured much sooner in the development cycle, saving time in report testing, end user support, and issue resolution.
With MicroStrategy Integrity Manager, companies can increase the scope, effectiveness, and accuracy of their data validation efforts, and free developers to focus on content creation rather than manual testing.
Even minor changes in the BI ecosystem may impact data accuracy and lead to inconsistencies across versions of BI reports. Common types of BI ecosystem changes that require report and data validation include:
* Software upgrades – MicroStrategy Integrity Manager ensures that database and BI software upgrades designed to address defect fixes and enhancements do not impact report integrity, and that inconsistencies are identified so they can be corrected prior to being viewed by business users.
* BI project migrations – As part of the normal BI development life cycle, developers continuously migrate entire BI projects or project objects across the development, test, and production environments. Administrators need to confirm that migrated objects perform as expected and do not negatively impact existing BI reports.
* Data warehouse ETL processes – Data loads and ETL scripts can modify or even corrupt existing information within the data warehouse. Database administrators require certainty that the ETL processes are successfully completed, without altering previously loaded data and introducing inconsistencies to BI reports and content.
* Database optimisations – System tuners can alter existing database objects and report parameters, or add new objects such as indexes and aggregate tables to improve report performance and system throughput. Developers need to ensure that subtle SQL changes and database alterations made for performance do not alter query results.
* User profile modifications – As BI applications are modified to provide richer capabilities or as end users move roles within companies, administrators must modify user and user groups’ application privileges and data security profiles. Validation testing ensures that user profile changes do not improperly alter users’ BI reports.
“Data integrity is paramount to the success of any business intelligence application,” says Sanju Bansal, MicroStrategy’s COO. “The more mission critical the business intelligence system, the greater the need for validation testing. MicroStrategy Integrity Manager is an important new product that can give our customers a high degree of confidence that the data in their BI environment is complete and accurate.”