Search Box Selector is not getting filtered by any other selector

Hi Everyone,

The searchbox selector was recently introduced in Microstrategy in it's 9.3 upgrade. No doubt it's a very welcome feature which can come handy for many cases. But the selector had one major flaw in it till 10.3 was released. The issue is when you target a search selector by any other selector, the list of values that appear in the searchbox doesn't get filtered, it shows all the elements that are present in the that field.

The issue was recently fixed in 10.3 though this is missing the release note.

What should I do in the older versions?

Only thing you can do is to uncheck the 'Search on Server' checkboax which you have in the Selector Properties-> Layout. This should resolve your problem.

Thank you

Pass prompt answers dynamically to different kinds of prompts e.g. Element prompt, Hierarchy prompt

There are cases where you need to pass some values dynamically from a dashboard or a normal web page to a target dashboard. The prompt(s) present in the target dashboard should be automatically answered while navigating from the source. To achieve this what we can modify the URL of the target dashboard which will contain the required answers along with the specific parameters for the target prompts. Now there could be different kind of prompts like

1. Attribute element prompt
2. Value prompt
3. Hierarchy prompt

The URL must be crafted according to the type of target prompt. I will discuss the structure of each URL needed for the above mentioned prompts


Attribute Element Prompt:
            This is the most common scenario. The structure of the URL should be something like the following one

http://mstra/MicroStrategy/asp/Main.aspx?evt=2048001&src=Main.aspx.2048001&visMode=0&currentViewMedia=8&documentID=9FDF2E62433EA047A48E2CA5A058C0F3&server=XXXX&Project=YYYY&port=0&share=1&elementPromptAnswers=074819

To build this URL do the following
1. Get the actual link of the dashboard
2. Append the highlighted part
3. The value mentioned in the last is the value which you want to pass

Value Prompt:
             This is similar the element prompt. Follow the same thing to get the following URL

http://mstra/MicroStrategy/asp/Main.aspx?evt=2048001&src=Main.aspx.2048001&visMode=0&currentViewMedia=8&documentID=9FDF2E62433EA047A48E2CA5A058C0F3&server=XXXX&Project=YYYY&port=0&share=1&valuePromptAnswers=074819

Hierarchy Prompt:
              This is a very rare scenario but we can still answer it dynamically.

1. Add the prompted report in a blank document
2. In the body of the document, add the following autotext {&PROMPTXML}
3. This autotext will generate the required text that is required in the URL
4. Run the document and copy the XML

The XML will look like following

<rsl><pa pt="8" pin="0" did="1965EB7842BD4B37D56AD69F58386662" tp="10"><exp><nd et="5" nt="4" dmt="1" ddt="-1"><nd et="1" nt="5" dmt="1" ddt="-1"><at did="650A0FA446E9F26CE7B66AA1F81965A7" tp="12"/></nd><nd et="1" nt="2" dmt="1" ddt="-1"><mi><es><at did="650A0FA446E9F26CE7B66AA1F81965A7" tp="12"/><e emt="1" ei="650A0FA446E9F26CE7B66AA1F81965A7:123055432"/></es></mi></nd><op fnt="22"/></nd></exp></pa></rsl>

ID of the Hierarchy on which the prompt is built
ID of the Attribute which is selected by the user while answering the prompt.
Value of the prompt


The final URL will be

http://WBSERVER/MicroStrategy/asp/Main.aspx?evt=2048001&src=Main.aspx.2048001&visMode=0&currentViewMedia=8&documentID=3767E4C349F3D949B77297855678EEE0&server=XXXX&Project=YYYY&port=0&share=1&promptsAnswerXML=<rsl><pa pt="8" pin="0" did="1965EB7842BD4B37D56AD69F58386662" tp="10"><exp><nd et="5" nt="4" dmt="1" ddt="-1"><nd et="1" nt="5" dmt="1" ddt="-1"><at did="650A0FA446E9F26CE7B66AA1F81965A7" tp="12"/></nd><nd et="1" nt="2" dmt="1" ddt="-1"><mi><es><at did="650A0FA446E9F26CE7B66AA1F81965A7" tp="12"/><e emt="1" ei="650A0FA446E9F26CE7B66AA1F81965A7:123055432"/></es></mi></nd><op fnt="22"/></nd></exp></pa></rsl>

Hope this helps :)