so we are stuck with the question like;
what tables the perticular report is going to hit.?
What is i add the new column to existing repots ?
Why my query is taking tables X as join condition ?
We Answer these question , what we can do kind of quick validation is
Select the all columns you have selected in report in presentation catalog and then you select
either Logical table source and physical tables.
as below

Cheers
Nawneet