- 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:
- Report URL
- Attribute ID
- 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.