Hi ,
I have a WEBI report based on Bex query using BICS connection, I am using Bex variables as prompts in WEBI ,every thing was working well..
now it is not showing list of values for the prompts which are defined as variables and wild card search functionality is not working for the prompts created in WEBI, where as if I create a new report on the same bex query every thing is working well
can some one please help why this is not working with existing report ? do I need some clear some cache or something in BW side or BO side?
And i am searching through Key search box is working only facing issue with text search, in another report which built in same query in search box working with text and key for both.