Category Archives: Prompt search

Adding a prompt to a filter based on a metric

Hello there,

If you need to add a prompt to a filter based on a metric, you just need to do this:

  1. Create a filter using a metric in a report;
  2. In the parameters, just use Custom for the expression;
  3. Insert an Applysimple function. Ex.:

ApplySimple(“Dateadd(Month, Datediff(Month, 0, DATEADD(m, -#0, current_timestamp)), 0)”,? Months)

4.   In this example, I’m using a Months prompt to get an integer answer from the user to fill the #0 wildcard.

The trick here is the put the prompt name as: ? NAME_OF_THE_PROMPT

Hope it helps.

God bless you.

Change the default behavior in prompt search

Hello there!

Here is a tip of a great friend called Rafael Gourlart.

By default, a space between words in a prompt search is interpreted as a logical ‘OR’ in MicroStrategy Web. This behavior be changed to use ‘AND’ instead.

For example, if you are trying to search for “FelipeVilela” a possible result would be:

pic2

Now, if you change to “And”:

pic3

 

To change from “OR” to “AND” you just have to:

1.In the FilterValidation.properties file under WEB-INF\classes\resources, set the elementSearchBehavior parameter to ‘2’, and restart the MicroStrategy Web.

pic1

That’s it.

 

Hope it helps.

God bless you.