EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB310539: How to construct URL API to run a report with empty answers of the element prompts to hit the existing report cache in MicroStrategy Web 9.4.x and later.


Community Admin

• Strategy


This article describes a way to construct URL API to run a Report with empty answers for the element prompts to hit the existing report cache in MicroStrategy Web 9.4.x and later.

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

The parameters below are required to execute a report:
 

evt=4001
&src=Main.aspx.4001
&reportViewMode=[1:grid,2:graph,3:grid/graph]
&reportID=[Report ID]

The parameters below are required as empty answers for the element prompts :
 

&elementsPromptAnswers=[Attribute ID of the element prompt1]


Comment

0 comments

Details

Knowledge Article

Published:

May 26, 2017

Last Updated:

May 26, 2017