I wanted to know if queries and WAD can remain changeable in production environment ?. I have worked in both environments where the reports are less frequently changed and hence they are transported to production and in environment where the reports are frequently changed in production to enable users to have flexibility of reporting and to accommodate immediate changes.
However , we are right now in a position where reports are transported to production , where as Web application designers are created in Production directly to enable quick change .Now the client is requesting to transport WAD too .
Can anybody help me out, in what is the best practice to manage WAD's in frequently changed environment.
Pros and Con of keep WAD reports editable in production.