Skip to Content
avatar image
Former Member

Universe LOV issue

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 13, 2017 at 08:01 PM

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

    Regards,

    Jin-Chong

    Add comment
    10|10000 characters needed characters exceeded