QA City

Join Hands to Build a Smarter India: Sign in | Join now
   QA City >> Expert Column
Dont Miss Experts

Testing Challenges in OBIEE Projects

Venkata Ramana Edagottu
Venkata Ramana Edagottu
Manager, Hitachi Consulting Software Services
Venkataramana, CSTE, PMP, ITIL is currently leading the Applications SubCoP is a part of TQA CoP ... more>>
This article describes the various testing challenges I faced during the testing of OBIEE Projects. Oracle Business Intelligence system provides us flexible capability to generate and utilize Business Reporting - 'actual vs. goals', Forecasting - 'what if scenarios', Dashboards - 'information at a glance' and Multidimensional Analysis - 'insight into data at a more granular level' that enable educated decisions for the enterprise.

This article is intended to provide information of test requirements, defect management and approach taken to make sure the OBIEE dashboards are tested with minimal defects.

Test Data Requirements:

Test Data has to be clearly defined prior to testing Oracle Business Intelligence dashboards data. As a best practice, test data should mimic real user world as in Production systems. Database should be provided with at least 4-6 months of production data to be present to validate results. Test Data should have specified boundaries while inputted in a test case. This term "Boundary Conditions" is to be clearly defined by the analyst who is responsible for constructing the data. Boundary Conditions for test data specify the limits within which the system should work in intended manner. Test data when not limited, can lead to a project delay increased testing efforts, and resource impact.

Data Validation:

Validating the Report data Vs Database Data is a key challenge in any OBIEE projects. Need to take the query log and build our own query or create a SQL query according to business logic to run against the source database. This needs good command on SQL queries and joins.

Simplify your lengthy SQL queries to quickly run on the source/target data otherwise, it may take longer time to execute the query. This will ultimately leads to the execution timelines.

ETL Refresh:

ETL stands for extraction, transformation and loading. Incremental ETL is the process of loading the newly added/modified/deleted data from source database to destination database. Test analyst should be create/modify/delete records and check the data after the every ETL refresh. Typical ETL test process is as follows:

Drilldown Reports:

Most of the OBIEE dashboards have multiple drilldown reports. Each drilldown report navigates through one level to lower level of the same hierarchy. Good number of defects can be found in this navigational experience of the drilldown reports by noticing the headers of the reports and data displayed in relation with the main dashboard report.

User Roles:

Different kinds of user roles will be defined based on the nature of business of different customers. Test analyst should be able to understand the different scenarios applicable to different user roles.

Ex: Host User, Super User, Analyst User, Marketing User... etc. The Analyst User may not be able to see customer details (First Name, Middle Name, Last Name, all Address fields, Email, Gender, Phone, Customer Attributes... etc). The Analyst User may have access to every dashboard except for ad hoc reporting.

Well designed test cases covering the entire user roles will be greatly affect the quality of the OBIEE application.


This is one of the important aspects in dashboards testing. Performance acceptance criteria should be defined in well advance and with the proper input parameters of dashboard reports. Response time for all the drilldown reports should be tracked and monitored. Ultimately this will impact the end user interaction with the application.

Defect Triage:

These meetings will help project teams with the following:
  • Make sure defect have adequate information
  • Make sure the correct 'Severity' and 'Priority' tagged
  • Make sure the assignment of defect to concerned
Experts on QA
Sasank Taraka Kumar
QA Lead
RAM Informatics Ltd
Dr Sanjay  Gupta
Lean Leader
Sudhir  Patnaik
Director Engineering
Intuit India
Seetharama  Shetty
Sr QA Analyst
Arctern Consulting
Kiran  Rayachoti
Sr Program Manager
Sapient Corporation
Bobin Motti  Thomas
Sr Tech. Associate
Tech Mahindra
Saudagar  Shinde
General Manager
TTP Technologies Pvt
Ramesh  Loganathan
VP Products
Progress Software
SiliconIndia About Us   |   Contact Us   |   Help   |   Community rules   |   Advertise with us   |   Sitemap   |  
News:       Technology   |   Enterprise   |   Gadgets   |   Startups   |   Finance   |   Business   |   Career   |   Magazine  |   Newsletter   |   News archive  
Cities:        CEO   |     Startup   |   Mobile   |   CIO   |   Women   |   BI   |   HR   |   SME   |   Cloud   |   Marketing   |   QA   |   Java   |   Web Developer  
Community:      Members   |   Blogs   |   Indian Entrepreneurs   |   Gyan   |   Advice   |   Community   |   Find   |   CXO Insights  
Job Board:      Jobs   |   Freshers   |   Companies   |   HR Speak   |   Forum  
Online Courses:   Web Developer   |   Java Developer   |   CCNA Training   |   SEO   |   SAS   |   SQL Server 2005   |   J2EE
Education:   MBA   |   MCA   |   Engineering   |   Training Institute
Life:          Real Estate   |   Travel   |   Finance   |   Gadgets   |   Movie Reviews   |    Jokes  
Send your feedback and help us continue to improve SiliconIndia
© 2015 InfoConnect Web Technologies India Pvt Ltd. all rights reserved