How to control Presentation object visibility dynamically based on Report Prompt?

AbinashBehera

Hi All,

I got a new requirement which eating my brain out.....

Suppose user gives Month Prompt value As 'APR', then I need to hide or disable certain measures in the Left pane of Criteria Tab, so that user wont be able to drag those columns for report. And also those objects should be enabled/unhide for a different Scenario of prompt values.

As per my knowledge, report prompt or dashboard prompt does control Subject Area content. Because once it comes to Edit page of report, BI server doesn't store the Applied Prompted Values. So user will again has to give the Prompt values to run it. Is this understanding wrong?

Or Is there a way out to implement the above requirement?

Thanks,

Abinash