Custom SQL in Webi reports reverting to gerenated SQL when exporting univ
Hi all -
I've searched the forum and didn't find any posts of the sorts regarding my issue. I was wondering if anyone has experienced the following behavior in WebI XI R2.
We have a few reports that run on a scheduled daily basis. The report writer created these reports with custom SQL to use the current date in the select criteria. But when we make changes to the specifc universe that these reports use and export that universe from Designer or import it from QA to Production via Import Wizard, these reports all revert to the initial generated SQL. The report writer need to go into each one of these reports to set them back to use custom SQL. I should also add that the generated SQL of these reports are fairly complicated.
We have about 20 of these report and right now we are on a monthly deploy cycle. So it's becoming an issue to get these reports set back to use custom SQL every month.
Has anyone come across an issue like this? If so, was there a resolution?
Thanks in advance for any advice on this.