1

I currently have a task to test BI reports. Is there is any automation tool to test BI Reports(Business Intelligence Reports)? Also what are the key factors needed to validate BI reports.

  • This is actually not an answer, more of a revival question. I have found a bit of difficulty (actually no success yet) using our existing Selenium framework to test reports created with the new tableau UI. I don't know if anyone here has anymore advise to give on this. – Gabriel Peter-Thomas Nov 20 '17 at 19:18
  • Currently most of the test tool in the market not comprehensive enough as they come from non-BI background and more importantly user feedback that I get is they are not as user friendly. Most of the tool in the market would have a tool specific stiff learning curve. There is a new tool in the market for BI testing and looks like they solved both of those issues. Below is a link that have few demo listed – have a look if this solve your issue: youtube.com/channel/UC-o7WhupEUYxmOvhsSGhr-w – Shahnewaz Khan Nov 20 '18 at 0:46
4

BI VALIDATOR:

BI Validator is the most comprehensive Regression, Performance and Stress Testing tool for Business Intelligence applications built using OBIEE, Cognos or Business Objects. It is built on our patented Patented ELV Architecture. Its easy to use Test Plans empower Business Analysts, Testers and Developers to quickly create and execute tests in a matter of minutes without the need to do any custom programming. By automating the BI Testing, Business Analysts, Testers and Developers can now focus on delivering more content in a shorter time with a higher degree of confidence.

The tool can help detect defects prior to production and can drastically reduce the costs associated with BI projects using OBIEE, Cognos and Business Objects. BI Validator eliminates the need for custom programming and/or manual eyeballing of dashboards and reports. By automating the BI regression and performance testing, Business Analysts, Testers and Developers can now focus on delivering more content in a shorter time with a higher degree of confidence.

Key Features:

  1. Given the shortage of resources, how to automate the regression and performance testing?
  2. How to simulate concurrent user load for stress testing of BI Applications built using OBIEE, Cognos and Business Objects?
  3. How to compare data from reports across environments?
  4. How to compare data from reports pre and post upgrade?
  5. How to unit test OBIEE subject areas?
  6. How to validate the entire dataset from a report and not just the first few rows?
  7. How to increase my dashboard and report test coverage?
  8. How to automate and reduce the BI testing costs?
  9. How to identify the dashboards and reports that are impacted by a recent change change in the model?

You may download this tool from here: http://datagaps.com/bi-validator-download/viewcategory/4

|improve this answer|||||
1

No for a general "bi test tool".

However there are ways to achieve testing.

It depends firstly in what framweork or application they are developed in. There are a lot of Business Intelligence vendors and each does thing in a different way. Your best best may be a feature of the tool you are using or an available plugin or extension.

If your tool can do output to the web (pretty common these days) they you could use standard web UI automation tools aginst the web page, asserting expected results for a given data set and conditions that you create and can them access via a web page.

The most simple, UI based tools include seleniumIDE and ghostInspector (paid but has free version).

Formal programmatic solutions mostly focus around selenium by using the WebDriver protocol and then languages like c#, ruby and python and test frameworks such as rspec (ruby) to write the actual test cases.

|improve this answer|||||

Not the answer you're looking for? Browse other questions tagged or ask your own question.