Hi Quentin, not sp_result.Final is source, sp_result.Temp is source which created in previous data step with new defined variables. sp_result.Final is output table. yes, after I ran data step, I had registered sp_result.Temp table in metadata, that's why I would have been able to set up prompt to refresh_date and refresh_mon from sp_result.temp table and able to get old date/month values for filter. adding step one more time with udpations... 1.which read data from DB table to 2.create temp table with new derived(date conversion variables), then registered temp table in Metadata. 3.create another table with complete where condition for Dynamic filter. I can see month and dates details in promt drop down which were there when the stp created. yesterday data been refreshed, the new month and date not being pulled and avaible in Dynamic prompt to select. Thanks..
... View more