Oracle Business Intelligence Enterprise Edition (OBIEE)

The primary focus of DW/BI testing is to ensure competent and perfect database structures, ETL processes, front-end access and that BI reports generation processes completely support the client requirements. What is OBIEE?
Oracle Business Intelligence Enterprise Edition (OBIEE) is a comprehensive business intelligence platform that delivers a full range of analytic and reporting capabilities. Designed for scalability, reliability, and performance, Oracle Business Intelligence Enterprise Edition delivers contextual, relevant and actionable insight to everyone in an organization, resulting in improved decision-making, better-informed actions, and more efficient business processes. In our project, we are doing OBIEE Report testing: . Understanding Sub Queries
. Understanding Table Manipulation
. XML in SQL Server
Prerequisites: Before go through the below documents we must have basic knowledge of OBIEE and its components Like . . . Oracle Bi Server
Oracle Business Intelligence Dashboards
Oracle Business Intelligence Answers/Analysis
Oracle Business Intelligence Delivers
Oracle Business Intelligence Briefing books
Oracle Business intelligence Publisher
1. Sample report and Navigation steps:
. Oracle Interactive Dashboard page is displayed as designed for project
. Click on Customer Subject area (Note: Generally set of reports may or may not come under specific subject area)
2. Checking the Source record count and Target record count:
. Checking the source record count and Target record count for matching
. While writing the queries we can validate the record count
Once the Report gets executed we need to validate query in database by finding the matching record count. 3. Checking the Naming Conventions:
During the Project setup and later during maintenance these conventions can help for communication about several possible entities: ETL, DWH and Repository. Using naming convention is only effective if they are used by everyone at the same level of details: . Fact Table (W_xxx_F)
. Dimension Table (W_xxx_F)
. Dimension Hierarchy Table(W_XXX_DH)
. Aggregated Fact Table (w_xxx_AG)
4. Authentication:
Is the process used to verify the identity of a user who tries to access the system. This is implemented by BI Server using either the Internal Authentication or Exte al Methods Authorization: Is the process used to verify that a user has been granted sufficient privileges to perform the requested action on the special object. 5. Report Data Validation:
In BI testing world, generally we call it as End to End testing hence we need to perform report data validation against data warehouse(DB) and source system data (i.e. Test data which are created specific to report from Business team or Front office team) Whenever the report is opened, one session log will be generated with Query which is used to identify the physical data source to which Oracle BI Server is connecting. Use this SQL to analyze the tables and fields while validation the data of the report. 6. Steps to follow to navigate to the Session log Query:
Step 1: Click Settings > Administration to open the Oracle BI Presentation Services Administration window
Step 2: In the Session Management window, under Cursor Cache, click the View Log link for the last entry