Prompting a View Filter in a Cube Report

Here is a very valuable tip that not everyone is aware of.  While you normally can’t add prompts into the View Filter of your report, you can if you’re using a View Report, which is a report that is explicitly linked to an Intelligent Cube.  You can use existing Element and Expression Prompts in it’s View Filter,  which allows you to create prompted reports off of cubes.

Step 1 – Create your View Report

Create an Intelligent Cube, right click it, and choose Create Report.  This will create a report that is explicitly linked to this cube and never hit the database.
Step 2 – Add your Prompt
Simply click to add a new qualification in the View Filter and you’ll find an option to Select a Prompt:
Click that, and then you can choose either an Element Prompt or Expression Prompt:
I chose an Element Prompt for Regions. 
Now when you run this report, it’ll have an Element prompt like normal.  Another nice advantage of this method is that the prompt is sourced from the cube itself.  This is the only place in MicroStrategy where this happens.  The difference between this and Element Caching is that Element Caching only caches the initial list of elements returned to the prompt.  If you search the prompt for a particular element, that query always goes back to the database.  However, for a View Report Prompt, an element search on the prompt will query the cube, which is fast and in memory.  If you’re having prompt performance issues, you may want to consider making your data sets instead View Reports and using this method to improve prompt searching performance.

You may also like...

13 Responses

  1. Hi Bryan,

    Nice article, please let me know which MSTR version supporting this feature.


  2. Hi Bryan,

    Thank you for answering.


  3. Hi Bryan,

    Please let me know about “Expression Prompt” and how to create this prompt.


  4. Peter says:

    how can i acheive login Security feature for Cube based reports / documents where the Security is defined in Database

  5. Mathieu says:

    Hi Brian,

    Sometimes the ‘select a prompt’ option is just not there Oo I can’t figure out why : I create a new report from the cube as usual, but when I try to add a prompt in the view filter, the menu item is not present. Any clue on what could explain this ?

    • Anish says:

      Mathieu, the prompts in the View Report cannot be added in the grid view. Go to Design view to be able to see this in the menu option!

  6. James says:

    this is a great article. I did not know this was possible. On the reverse side, what objects can’t you use with an Intelligent Cube?

  7. Denis says:

    Hi Brian,
    how could I do that prompt creation using the web version instead of developer?

  8. sandy says:

    Hi Brian,

    I am working on MSTR 9.4.1. I have a prompted dashboard based on 2 cubes. I created view reports and added prompts to the view filters, the same method which you explained. But when I run my report the prompt is hitting the DB and not the cube. Please let me know what to do to make my prompt hit my cubes.


  9. Gonzalo says:

    Is there a way to create an Attribute or Metric Prompt from a Cube? I can do this on grids but I havent found the possibility for a cube.

Leave a Reply

Your email address will not be published. Required fields are marked *