I have a stored process that is creating a filtered dataset based on parameters.
I also have another stored process that refreshes the LOVs of the first SP to contain distinct values found in the source mart.
When I run the SP to create my dataset in Enterprise guide I am presented with the refreshed list of values, however when I run a report in WRS that references the SP it is giving me the list from the last time I saved the report.
Do I need to do something extra in order to see the new LOV in WRS?
Thanks
... View more