Now, when I create a report that only takes init_id, topic_cd ad topic_nm, the SQL that is fired still include the table init_sector which is not there in the report.
This then creates duplicates, unless if I use the distinct or distinct count option.
Is there a way to build the view of set up yellowing so that tables that are not called in the front end are not triggered in the SQL
Can you let us know which version and build of YF you are currently using? E.g. 7.1, 2015 20150828?
I have included three links below for your review, two from our current Wiki and one from our Forum.
View Builder Overview
Forum - Optimized Views Explained
Please review the following information and let us know if this helps with your present issue.