Universe condition & Report LOV's

building reports desktopintelligence
1

I have a condition in the universe and is used in the report for the prompt (passing parameter). This prompt has an LOV, and has been working for several months now. A change is needed to one of the list of values in the prompt and i have made the change to the condition on the universe, this change is shown in the query, but not in the LOV drop down. It still shows the old value, am i missing something here, once the condition is changed, is there anything that needs to be updated in the report.

This is how it is after the change:
AND ( ( decode(CAD_RAW_TEMP.SECTOR,null,‘Not Geo-Validated’,CAD_RAW_TEMP.SECTOR) ) IN @prompt(‘4.Select Sector’,‘Not Geo-Validated’,‘Cad Raw Temp\Sector’,multi,free) or ‘%’ in
@prompt(‘4.Select Sector’,‘Not Geo-Validated’,‘Cad Raw Temp\Sector’,multi,free) )

Before change it was
AND ( ( decode(CAD_RAW_TEMP.SECTOR,null,‘A’,CAD_RAW_TEMP.SECTOR) ) IN @prompt(‘4.Select Sector’,‘A’,‘Cad Raw Temp\Sector’,multi,free) or ‘%’ in
@prompt(‘4.Select Sector’,‘A’,‘Cad Raw Temp\Sector’,multi,free) )

Even after the the LOV value is still shown as ‘A’

Please help

socl99 (BOB member since 2008-03-01)

2

I’m writing this without BO at hand, so it might not be precise.
In your LOV in the DeskI/WebI interface you can click the “Refresh” button. In the universe you have several options to click. You would want “Export with universe” on and maybe “Refresh on use”.

HenkK

HenkK :netherlands: (BOB member since 2004-03-02)