Reports don’t always re-point well, unfortunately. I have found Deski re-point better than Webi, even with the Webi new mapping feature, I have founf formulae break 
.
Also, you are shafted if you have multiple Dps from different universes - Webi re-points all queries
If the data structures are going to be the same, I would probably go with re-pointing the - existing - universe and making amendments to the existing objects, or replacing the universe, see here:-
https://bobj-board.org/t/106492
Well, you have just hit the nail on the head with regards to, not ,running custom SQL in production .
This is going to be a major overhead, especially if many non-Ansi SQL functions are used, as Haider previously mentioned.
Mak 1 
(BOB member since 2005-01-06)