When a report is executed with URL API having promptAnswerMode=2 to leave a prompt empty, this report execution won’t hit existing cache.
To avoid this, the following example demonstrates how to construct URL API to run a Report with empty answers for the element prompts to hit the existing report cache in Strategy Web 9.4.x and later.
Sample URL API:
(.NET Version) http://WebServer/MicroStrategy/asp/Main.aspx? (JSP Version) http://WebServer/MicroStrategy/servlet/mstrWeb? evt=4001 &src=Main.aspx.4001 &reportViewMode=1 &reportID=E3886DFF48FA78E021CC41A4D489910C &elementsPromptAnswers=8D679D3811D3E4981000E787EC6DE8A4
evt=4001 &src=Main.aspx.4001 &reportViewMode=[1:grid,2:graph,3:grid/graph] &reportID=[Report ID]
&elementsPromptAnswers=[Attribute ID of the element prompt1]