nVision Scope Value Table
Hello,
I've created a view, which shows only those projects that exist in the PROJ_RESOURCE table.
SELECT A.PROJECT_ID FROM PS_PROJECT A WHERE EXISTS ( SELECT DISTINCT 'X' FROM PS_PROJ_RESOURCE B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROJECT_ID = A.PROJECT_ID) ORDER BY 1
When this view is used as the Value Table in the nVision Scope and run for All Detail Values, the nVision report generates a single report for each project for the business unit, - even those projects that do not exist in the view. Which means that it doesn't really matter what Value table is selected. What can I do to the view to make sure the report generates for only those values (projects) that exist in the view?