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

KB10534: How to create a link to execute a report with answers to an attribute element list prompt using URL API in MicroStrategy Web 9.4.1 and above.


Community Admin

• Strategy


This article describes how to create a link to execute a report with answers to an attribute element list prompt using URL API in MicroStrategy Web 9.4.1 and above.

The following steps describe how to create a link to a Strategy Web report in a document so that users can click on the link to execute the report. This report contains an attribute element list prompt and will allow users to execute without providing prompt answers explicitly:

ka04W000001MKxvQAG_0EM440000002HhS.png

 

  • Retrieve the link to the report by going to Strategy Web and browsing to the desired report. Right-click on the Report object > Properties, and copy the Link.
ka04W000001MKxvQAG_0EM440000002HhX.png
  • Retrieve the Attribute ID of the attribute used in the element list prompt; this can be done by browsing to the attribute object via Developer, right clicking it, and going to Properties.
  • Retrieve the ID of the elements that should be used to answer the prompt; this can be done by running the report with the attribute showing the ID form next to the DESC form. The element ID will be a combination of the attribute ID and the element ID separated by a colon.

 
With the above information:

  1. Report URL
  2. Attribute ID
  3. Element ID

The report link can be created as follows:
Sample Code/Error


http://servername/MicroStrategy/asp/main.aspx?Server=localhost&Project=Strategy+Tutorial&Port=0&evt=4001&src=Main.aspx.4001&reportID=reportID&elementsPromptAnswers=AttributeID;ElementID1;ElementID2

For the example used in this document, the following link is created for South East and Central:
 
Sample Code/Error
 

http://servername/MicroStrategy/asp/main.aspx?Server=localhost&Project=Strategy+Tutorial&Port=0&evt=4001&src=Main.aspx.4001&reportID=reportID&elementsPromptAnswers=8D679D4B11D3E4981000E787EC6DE8A4;8D679D4B11D3E4981000E787EC6DE8A4:4;8D679D4B11D3E4981000E787EC6DE8A4:3

 
Note: Use a COMMA to separate answers to distinct element prompts:
Example (two distinct prompts for Store and Dept Group, the COMMA separates the two "answer-sets")
Sample Code/Error

&elementsPromptAnswers=5EDE76D94C271F9204B288B72102C92F;5EDE76D94C271F9204B288B72102C92F:{Store@ID},43F4803A4B66FD392948028BD0AA8B5F;43F4803A4B66FD392948028BD0AA8B5F:{@ID}

 
Customization Warning:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.


Comment

0 comments

Details

Knowledge Article

Published:

March 31, 2017

Last Updated:

March 31, 2017