Friday, June 8, 2012

Quality Assurance and Testing Services: Strategy of Oracle BI Testing

This Document gives an overview of OBIEE Testing and commonly used in BI Components while doing validation.

1. Testing in Levels: In a typical OBIEE project, it is advisable to test in multiple areas rather than attempting to test everything at once.

a) The first set of tests can verify the accuracy of the column to column transport of the data between the source and target. This verification is typically done using SQL statements on the source and target databases.

b) The next step is to verify the accuracy of the repository (the .RPD file.) These tests will include testing with appropriate dimensional filters on the metrics and the formula used to compute those metrics. Testers can build two sets of comparable queries within the repository interface.

c) The next step in testing will be to verify the dashboard / reports against comparable queries on repository metrics. In these tests, testers verify dashboard charts / reports against corresponding results from queries they execute on metrics of the repository.

d) Finally, the functional interface tests will cover tests to verify the lookups, performance, ease of use, look and feel etc.

The first three types of tests are performed by testers who can create simple SQL statements.

Structure and organization of test cases:

The choices on test cases naming convention and structure can help organize the test artifacts better and aid a great deal in implementing the overall testing strategy.

For example: If the test cases are grouped based on the nature of the tests, like, source to target verification, RPD metrics tests, functional, security, performance and usability, it would be easier to pick and choose the tests based on the testing context and tester capabilities.

1. User acceptance criteria:
Users typically have an existing legacy mechanism to verify if what is displayed in the new solution makes sense. Testers should dig into this and understand how the end users built the project acceptance criteria. Testers should challenge the assumptions made by the business community in deriving the acceptance criteria. This activity helps get an end user perspective built into the testing efforts from early on.

2. Validating Master Detail Report: 
Master Details linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.

3. Time series functions validation: Time series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods.

Time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.

a. Ago: With ago function we can compare period to period
b. To date: Time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.
c. Period rolling: The PERIODROLLING function does not have a time series grain; instead, you specify a start and end period in the function.

4. Oracle bi-publisher validation: Oracle BI Publisher known as XML Publisher offers efficient scalable reporting solution available for complex, distributed environments. It provides a central architecture for generation and delivering information to employees', customer and business partners both security and in the right format.



Thursday, June 7, 2012

Quality Assurance And Testing Services: OBIEE Validations


Hexaware has developed a variety of accelerators that combine Oracle’s technology with Hexaware’s functional and technical expertise to effectively meet your business needs. Oracle E-business suite range consists of financials, supply chain, manufacturing, HRMS & CRM.
Source to target validation: Here source is represented by metadata repository and Target represents OBIEE Reports & Dashboards, BI Publishers.
1. Presentation layer object validation:
This is the layer of the logical business model that is accessible for the client through the structure query Language better known as the logical SQL. The presentation is the appropriate layer to set user permissions and to validate user permissions to reports.
2. Categorizing the metrics:
It is important to classify the metrics from multiple perspectives such as, their frequency of use, potential performance impacts, and complexity of calculations involved. Such a classification helps drive priority of testing
3. Dashboard charts and filters criteria:
User interface testing should encompass tests with multiple options in the available filter criteria. OBIEE gives enough drilldown features to verify the underlying data on the clickable components of the charts. Test cases written should be detailed enough to verify data aggregated at various layers.
4. Filter Validation
. Validate the entire filters which are available on report. Example refers below report and its filter
. Example: For Performance Measure filter- Validate filter contents against report requirement and database
Filter types:
Local filters: Filtering the records in the report level.
Global filters: Filtering the records based on user selection in Dashboard.
Dashboard Validation:
When a user selects certain request that need to display the exact results in the dashboard.
5. Data level security:
Data level security validation means user will be able to see only particular data for the given permission
Example: Both the Eastern and Western region Sales Managers will be seeing the same reports but the Data visible to them in the reports will be Eastern and Western region Sales data respectively.
Object Level security: Need to validate whether the particular user is able to access the particular dashboard or folder etc.
Example: For example, users in a particular department can view only the subject areas that belong to their department.
6. Bursting the reports:
Bursting the reports means distributing the reports based on the regions. 
Example: If there are 4 regional reports, validate to burst the reports (based on East, West, South, North regions).
7. Buzz Matrix validation: 
Need to validate the alerts in the Dashboard.
Example: We are running stock market and CEO is very much interested to know today’s business weather, has it reached a certain level that which he expects compared to the last week. If the level has reached to a certain level in Dashboard Buzz (Alert), it should raise an alert saying that it has reached the level in such a way the buzz matrix validates.

Tuesday, June 5, 2012

Healthcare Services - Saving Lives On A Daily Basis

At the end of the day no matter how large your home is, how many cars you own, or what clothes you wear you will not be satisfied if your health is not at ease. Taking care of your body is what allows you to happily partake in your daily adventures and enjoy the materials you have worked so hard for. To ensure a healthy standard of living, healthcare facilities offer their patients comprehensive holistic healthcare services that promise to find a natural cure for your body.

Unlike your neighborhood clinic, comprehensive holistic healthcare services will diagnose and cure your problem through natural remediation. Stuffing another antibiotic in to your body is not their technique, yet striving for health through completing one of their many hands on services. When you report to the office with a never ending back pain, they will use their chiropractic service to fix the stressed area. They are determined to find the actual source of your problem, not just quick relief. For instance, sometimes back problems can cause so much stress to the body that headaches and migraines arise.

Although antibiotics are not part of their cure, they do provide a healthcare solutionthat offers deep analysis of your lifestyle to begin the process of freeing you of any previous malnutrition your body may be used to. Between evaluation and the use of their laboratory testing service, they are able to target the exact nutrition your body is lacking. Whether your problems are due to your metabolism, diet choice, hormones, or any related factor they are able to isolate the cause and provide you with a cure for the long run.

Once these deficiencies are targeted they will undoubtedly inform you, but it is not always easy to leave the building and begin an entirely different lifestyle. For this reason, they have created a service that allows the professionals to do a full mind and body analysis of the patient to be able to target the inner problem and heal the body from deep within.


Visit @ http://www.amazines.com/article_detail.cfm/4364215?articleid=4364215



Healthcare Service Companies - Saving Lives On A Daily Basis

The healthcare services that you decide upon must be equipped with positive reviews and references. To gather knowledge about the same, you can visit certain websites that offer this information. You can also ask around in your circle of friends regarding the reputation and standing of the concerned agency. If someone has had a personal experience with the agency that is highly positive, you should definitely consider going in for it.

The number of hours that you need a professional to be present in your home must be clearly communicated to the agency in advance so that your needs are adequately met. If you need someone to stay overnight in your house, this should also be communicated to the healthcare services agency so that you can be sure that they have staff to fulfill these requirements.

It is a great proposition to visit the agency and interact with their staff to gather an idea about their policies and the way the staff works. You should go in for a healthcare service that has an amiable, cheerful and friendly staff equipped with the ability to induce an atmosphere of ease with regard to the person to be cared for. If you encounter rude and unhelpful staff, you should consider going somewhere else.

The staff that you invite into your home must be verified thoroughly for credentials and background so that you can safely and securely leave your house without worrying about possible thefts or any other such crime. You should ask to see proof of certification and other qualifications before allowing any such professional into your house.


More: http://www.articleconsortium.info/article.php?id=22231



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 EnterpriseEdition 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 Serverusing 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


Read more: http://www.ideamarketers.com/?articleid=3290307&wherefrom=LOGIN&CFID=184837668&CFTOKEN=64001061