Target

Report Tableau Report Name TableName Report Column Name Sample_data

RPT001 Tax Payment Summary report TPS_Table Tax Account Number 53987
RPT001 Tax Payment Summary report TPS_Table Title Mr/Mrs
RPT001 Tax Payment Summary report TPS_Table First Name Stephen
RPT001 Tax Payment Summary report TPS_Table Last Name Mark
RPT001 Tax Payment Summary report TPS_Table Address Line 1 Locardo Street
RPT001 Tax Payment Summary report TPS_Table Address Line 2 Philandra
RPT001 Tax Payment Summary report TPS_Table Zone North
RPT001 Tax Payment Summary report TPS_Table State Sillicon Valle
RPT001 Tax Payment Summary report TPS_Table Country US
RPT001 Tax Payment Summary report TPS_Table Tax File Number #3456789
RPT001 Tax Payment Summary report TPS_Table Total Gross Tax 2345.00
RPT001 Tax Payment Summary report TPS_Table Total Net 1345.00
RPT001 Tax Payment Summary report TPS_Table Total Tax Withheld 1000.00
RPT001 Tax Payment Summary report TPS_Table Payer's PAN Number BAVPD1234B5
RPT001 Tax Payment Summary report TPS_Table Payer's Name Hilton
Source
Attribute Number Attribute Name DWH/BAL_Column Names Refresh Frequency
A0001 Tax Number Tax Account Number Yearly
Hardcoded N/A N/A Yearly
A0002 First Name First Name Yearly
A0003 Last Name Last Name Yearly
A0004 Address Line 1 Address Line 1 Yearly
A0005 Address Line 2 Address Line 2 Yearly
A0006 Zone Area Yearly
A0007 State State Yearly
A0008 Country Country Yearly
A0009 Tax File Number Tax File Identity Yearly
A0010 Total Gross Tax Total Gross Yearly
A0011 Total Net Total Yearly
A0012 Total Tax Withheld Total Tax Withheld Yearly
A0013 Payer's PAN Number PAN Number Yearly
A0014 Payer's Name Payer's Name Yearly
Source
DWH/BAL Table
TPS_Table .Tax Account Number
TPS_Table .N/A
TPS_Table .First Name
TPS_Table .Last Name
TPS_Table .Address Line 1
TPS_Table .Address Line 2
TPS_Table .Area
TPS_Table .State
TPS_Table .Country
TPS_Table .Tax File Identity
TPS_Table .Total Gross
TPS_Table .Total
TPS_Table .Total Tax Withheld
TPS_Table .PAN Number
TPS_Table .Payer's Name
RPT001_TAX Payment Summary Report
Date Generated:
Financial Year Start Date:
Financial Year End Date:
Tax Refrence Number:

Tax
First Last Address Address Tax File
Account Title Name Name Line 1 Line 2 Zone State Country Number
Number
mary Report

Payer's
Total Total Tax Payer's
Gross Tax Total Net Withheld PAN Name
Number
New Attribute Attribute Name
A0001 Tax Number
A0002 First Name
A0003 Last Name
A0004 Address Line 1
A0005 Address Line 2
A0006 Zone
A0007 State
A0008 Country
A0009 Tax File Number
A0010 Total Gross Tax
A0011 Total Net
A0012 Total Tax Withheld
A0013 Payer's PAN Number
A0014 Payer's Name
Description
It will create the Tax Number for customer
Customer first Name
Customer Last Name
Address line 1
Address line 2
Customer Current Zone
Customer state
Customer Country
When cutomer file the tax then this number is auto generated in system.
Total tax amount need to pay
Total amount of tax paid by customer
Total amount of tax pending
Customer PAN number
Cutomer Name
DWH/BAL Table Joins
TPS_Table .Tax Account Number
TPS_Table .First Name
TPS_Table .Last Name
TPS_Table .Address Line 1
TPS_Table .Address Line 2
TPS_Table .Area
TPS_Table .State
TPS_Table .Country
TPS_Table .Tax File Identity
TPS_Table .Total Gross
TPS_Table .Total
TPS_Table .Total Tax Withheld
TPS_Table .PAN Number
TPS_Table .Payer's Name
TestCaseName TestStep Description(Design Steps)
TC001_Generate_RPT001_Tax Payment 1 Login to Tableau Server
Summary Report from Tableau server https://scodeen.sharepoint.com/sites/
VP98770/sitepages/home.in
2 Navigate to report and click to scodeen
finance .
3 Verify all the reporting view thumbnails
are present.
4 Navigate to RPT001 report and click
and open
5 Verify whether user is able to
download report in the below formats
image , data , crosstab(.xlsx , .CSV),PDF
and powerpoint.

TC002_Verify_RPT001_Report Layout 1 Verify RPT001_Tax Payment summary

report is populated as per report
wireframe.
TC003_Verify_RPT001_Report Logic 1 Verify all the Tax Payment related
information is populated in report as
per report logic.
TC004_Verify_RPT001_Report attributes_Set1. 1 Verify below attributes from Tax
payment summary report against
DWH. Tax
Account Number
Title
First Name
Last Name
Address Line 1
Address Line 2
Zone
State
Country
Tax File Number
Total Gross Tax
Total Net
Total Tax Withheld
Payer's PAN Number
Payer's Name

TC005_Verify_RPT001_Report Count Validation 1 Verify RPT001_Tax Payment summary

report count against Source(DWH)
Count.
TC006_Verify_RPT001_Report Completeness. 1 Generate RPT001 Report

2 Verify whether it has picked all the

attributes as per requirement(Logic).
TC006_Verify_RPT001_Report Completeness.

3 Verify Count of records that matches

with no of records extracted against
Source(DWH/other sources)
ExpectedResult
Login should be succesful.

Report icon should be able to click ,

present on scodeen sharepoint
Reporting thumbnails should be
present.
RPT001 report should be clicked and
open.
User sholud be able to download the
report in all mentioned formats.

RPT001 report should be as per

wireframe

RPT001 report should contain all the

tax related information as per report
logic.
RPT001 report should be as per
wireframe

RPT001 report count should be same as

source.

RP001 Report should generate

succesfully.
Report should pick all the attributes as
per requirement(Logic).
Count of records in report should
match with no of records extracted
from Source(DWH).
Customer_Details Product Cust_Prod_Details
CID PID Logic CID,City,Product
FN PNAME
LN Pcategory
City CID
Address
Pin
Profession