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 External 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
by: Sumit Srivastava
Can You Rely On Ppc Marketing For Your Business? Property Tax Accountant Brisbane: Give Your Business An Edge In This Competitive Age To Handle Your Business With Ease Take The Help Of The Best Brisbane Accounting Firms Seo Services: An Ethical Way To Increase Your Online Business Brisbane Property Accountant Will Not Only Manage Your Accounts But Also Your Business Related Probl Look To Print For Your Business To Business Franchise Data Cleansing Is A Method Of Observing And Rectifying For Business The Five Things You Will Not Learn In Business School Selling Businesses: Be Optimistic And Realistic How To Choose The Right Business Gifts For The Occasion Open Source Development: Demand Of Every Online Business Important For Your Ecommerce Business - Magento Web Host Hire Web Development Company To Bring Up Your Business