A Software Testing Primer An Introduction to Software Testing by Nick Jenkins
Pressure TestingDescripción completa
Full description
Well TestingDeskripsi lengkap
method of stone testing
Search
Home
Saved
0
882 views
Upload
Sign In
Join
RELATED TITLES
0
Report Testing Uploaded by vellotus
Bestsellers
Books
Audiobooks
Save
Embed
Share
Print
1
Download
Magazines
News
Documents
Sheet Music
Deolitte ETL Testing
of 5
ETL Testing in Less Time
Etl Testing
Search document
1. BI Testing
Data which is loaded into Data warehouse is used for reporting purposes. There are m Busine Business ss intell intellige igence nce report reporting ing tools tools in the market market which which helps helps in gettin getting g data data from from warehouse which helps business people to manage the facts of business data.
In order for the business people to make the decisions using the reports, the data pr in the reports should be accurate. All the reports should be tested thoroughly before they are by the business users. Following methodology is used for validating the BI: 1. Sche Schema ma obje object ctss valid validat atio ion n 2. Repor Reportt dat dataa val valid idat atio ion n 3. Dril Drilll pat path h val valid idat atio ion n 4. Prom Prompt ptin ing g repor reports ts test testin ing g 5. Othe Otherr val valid idat atio ions ns
1.1 1.1
Sche Schema ma Obje Object ctss val valid idat atio ion n
All the schema objects which are created are validated to ensure that they are mapp correct tables and the joins are happening with appropriate tables. This validation hel identifying the defect in the earlier stage of report d evelopment. The more advantage of validating this is, if any of the objects are mapping to different table all the reports which are using these objects will give incorrect data and hence will result in time & cost to fix the defect.
1.2 1.2
Repo Re port rt dat data val validat dation
up to voteto onensure this titlethat accurate The data retrieved by the report is validated with the dataSign warehouse Useful Not useful is appearing in the report.
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
Search
Home
Saved
882 views
0
Upload
Sign In
Join
RELATED TITLES
0
Report Testing Uploaded by vellotus
Bestsellers
Books
Audiobooks Magazines
News
Documents
Save
Embed
Share
Print
Download
1.4 Sheet Music
Deolitte ETL Testing
1
of 5
ETL Testing in Less Time
Etl Testing
Search document
Prompting reports
Some of the reports which the users use are prompt reports which help in giving diff data inputs. All the prompt reports are validated with different input data.
1.5
Other report validations
1. 2. 3. 4. 5. 6.
2.
Derived metrics validation Layout of report Color and format of the headers Sorting of data in report Movement of data in the report Performance of report generation
Testing Business objects
Business objects are generally used by Business users to analyze data and make business cri decisions. Hence testing needs to be of high priority and it should ensure that the tool is wor as expected for different scenarios and dataReading obtaineda for different scenarios is in sink with da You're Preview warehouse or any other data source. Unlock full access with a free trial.
Business object testing can be sub divided into two sections. 1) Testing Business Objects Universe Download With Free Trial 2) Testing the reporting tool
Business objects universe deals with complex data models and joins between tables and databases. Hence testing universe needs expertise in that particular domain. Universe testin mainly deals with testing every fact tables and joins of fact tables to its dimension tables. Sign up to vote on this title
Business objects reporting testing basically deals with front end validation of the tool like er Useful Not useful while preparing are running the report. Also, testing can be done to verify the functionality of every feature with report wherever
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
Search
Home
Saved
0
882 views
Sign In
Upload
Join
RELATED TITLES
0
Report Testing Uploaded by vellotus
Bestsellers
Books
Audiobooks Magazines
News
Documents
Save
Embed
Share
Print
Download
Deolitte ETL Testing
1
of 5
ETL Testing in Less Time
Etl Testing
Search document
b. Schema Object Validation Sheet Music
This section deals with verification of Classes, objects and measures to check if they are ma to correct fields. As discussed in section 2.3: Classes are mapped to tables / views in data warehouse Objects are mapped to fields in the tables in data warehouse Measures are mapped to calculated fields in the tables in data warehouse. Now as part of schema object validation we need to check if 1) All the tables required for reporting are present as Classes or not. 2) All the fields in the above tables are present as objects or not. 3) All the calculated fields are present as objects or not. We can achieve the above checks by opening the data warehouse and comparing the table structure with the Class structure of the report.
c. Report Data Validation
This is the main area of testing. Data is the soul of every report. Hence data validation deals You're Reading a Preview verification to make sure that correct data has come in the report. Unlock full access with a free trial.
The following scenarios needs to be verified as part of Report Data validation
Download With Free Trial - Verification of record count against DW tables to check for duplicates and Filtered records (Check inner and outer joins) - Verification of good sample of data against Data warehouse tables. - Verification of data against source itself. - Verification of Contexts Sign up to vote on this title
Let us cover each one in detail. Record Count Verification:
Useful
Not useful
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
Search
Home
Saved
882 views
0
Upload
Sign In
Join
RELATED TITLES
0
Report Testing Uploaded by vellotus
Bestsellers
Books
Audiobooks
Save
Embed
Share
Print
Download
Magazines
News
Documents
Sheet Music
Deolitte ETL Testing
1
of 5
ETL Testing in Less Time
Etl Testing
Search document
Sample Records Verification: This verification should be done after record count verification. Once we are sure that recor count is matching we can go ahead and check if data for each object is coming as expected o not.
Also, there can be cases where record count is matching but still few records can fall under t category of missing / extra or duplicate. We can identify such records under this validation section.
Here we can consider some good sample of records (around 5000) from Data warehouse tab and check if these records are coming as expected in the report or not. We get export the rep data into Excel and we can compare the data in excel with the help of function s/s macros.
Possible issue cases are: - Objects having values in Data warehouse table but coming as NULL in Report - Objects having NULL in Data warehouse tale but having some values in Report You're Reading a Preview - Objects having different values in Data warehouse table and in Report. It happens du outer joins. Unlock full access with a free trial. - Objects data getting truncated in Reports.
Download With Free Trial Source Verification: This check can be done once above two validations are complete. Above two validations are based on Data warehouse data. But there are chances that the dat itself may be incorrect in data warehouse. Hen ce it would be good practice if we verify the r data directly against the source. Sign up to vote on this title
Also, reports are generally used by business users and they can only see the data in source a Useful Not useful report. Hence verification against source will ensure that data is matching with what is prese source.
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
Search
Home
Saved
0
882 views
Sign In
Upload
Join
RELATED TITLES
0
Report Testing Uploaded by vellotus
Bestsellers
Books
Audiobooks Magazines
News
Documents
Save
Embed
Share
Print
Download
Sheet Music
Deolitte ETL Testing
1
of 5
ETL Testing in Less Time
Etl Testing
Search document
Now as part of context verification we need to make sure that each context has the correct jo and is fetching the data based on that particular join. Issues identified during this verification: - Joins for each context are not identified properly. - Outer joins and Equijoins issue. Replacing each other. - Some where conditions are missing for particular context. This technique may not be used in every project and hence this validation is optional.
d. Other Business Validation
Based on the requirements of the projects there can be other validation cases. Most common among them are
Verification of Performance: Performance of reports is of huge concern. Performance issues can be caused because of 2 b reasons: - Report is trying to access huge data. This issue can be resolved by using query filters. - Joins between tables may be incorrect / not fine tuned and hence resulting in huge number records. This issue can be resolved by fine tuning the joins and queries. You're Reading a Preview
Verification of synchronization errors during context Unlock full access with a free selection trial. Sometimes reports may not run if we are pulling objects from 3 or 4 classes. This is because classes are not joined in universe properly. During such cases we get synchronization errors Download With Free Trial
Verification of existing user reports: When universe is modified due to some issues or new functionality addition, it would be bes we verify existing user reports just to make sure that everything is working as expected. Sign up to vote on this title