Skip to Content
0

Universe LOV issue

Jun 12, 2017 at 01:06 PM

44

avatar image

Hello,

We are facing a strange issue with universe LOV's:

1) An object LOV was defined as select distinct Z from Table A

2)We changed the LOV SQL to select distinct Z from Table A , Table B where Tablea.Col1=TableB.col1 checking the option "Do not generate SQL before running"

3)"Automatic refresh before use" and "Export with universe" is selected.

4) When the object is selected in the webi report it shows the old sql and not the modified one. Can you advise why and if the above process is correct to get what we want to achieve?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

JinChong Tsai Jun 13, 2017 at 08:01 PM
0

Have you clean up webi cache defied in the WIReportServer's "Output Cache Directory"?

Regards,

Jin-Chong

Share
10 |10000 characters needed characters left characters exceeded