How is the cursor cache expire limit.
Try increasing the expire minutes to more time i.e.,1380 minutes here in your case but it will effect entire OBI reports/dashboards.
But, are the report prompts not coming from same table?
Prompts are not coming from the same table , but those prompt columns are there in report.
Just to clarify..You have created the prompt,Did you select the cache persistence time for that table?