We have a few important queries whose outputs form the basis of several (even hundreds) of other queries and reports. If we wanted to make a change in one of these main ones, is there a simple way to tell which other queries use it for an input?
Outputs sales data that can be used as an input file in the following:
So if we need to make a change in ABCD2014, all of the queries that hang off it need to be changed as well. Is there a report or a function that can list every instance of where ABCD2014 is used as an input? So we can see a list like the SALES queries above?
We thought that it might be possible because when you enter a query and library as an input, the system checks to see that it exists – so if it is able to look backwards to ascertain that ABCD2014 is in Lexample1, can it look forwards to see where the output is used as an input?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!