We would like to be able to handle modification of BW query directly in Production. However, we would like to control this process. We imagined the following process:
- Copy the query to modify
- Make change to this copy and test it
- If test are successful, overwrite the original query with the modified copy
We would like to keep the original query because it may be embedded in workbook or web template.
However, this process doesn't work because it is not possible to overwrite an existing query. Has anybody imagined another process to handle this situation ?