MicroStrategy Selector Types

There are various selector types available in MicroStrategy. I don’t mean the display style (e.g Pull-down, link bar, bullet , etc), I mean what the selectors actually do. It’s worth reviewing the use cases for each of selector types which are available to create the best user experience possible.


Metric Selector

Metric Selector In Action

Metric selectors provide users the ability to select which Metrics they'd like to have displayed. For example, let's say we have a grid which has two metrics available - "Category Sales" and "Net profit". Without the selector, both metrics would be display on the grid and the graph. When using a metric selector, the user has the choice to select either of the metrics, or both (depending on how you've configured it).


Attribute Element Selector


Attribute element selector

This is the selector type I most commonly use, or rather, is most frequently indirectly requested by users I have worked with. Attribute element selectors allow you to slice/dice the available data by the attribute values. Let's take a "Year" attribute for example. Let's say we have a report which has 3 years of data available - 2019, 2018, 2017. An attribute element selector will allow the users to select which year(s) they would like to see in the report. To quickly note, the image above uses a secret multi-select pull down selector. Details of how to configure it can be found here - https://www.omarvidaure.com/post/secret-microstrategy-selector


Attribute Selector


Attribute Selector

Attribute selectors allow the users the ability to "swap' which attribute is on display in the grid/graph. take the "Year" attribute for example. let's say that the user would like to have the ability to select either "Year" or "Month" but not both. Just set the attribute selector to use these two attributes


Panel Selector

There are times we use Panel Stack to display varying types of information. For example, we may have a panel stack which has a grid on the first panel and a graph on the second panel. We want to provide the users the ability swap the view of either the grid panel or the graph panel.


And that's It!

Thanks for checking out this blog post. If you found this post helpful please consider donating. Any contribution is appreciated! Just click the PayPal icon at the bottom of this page.






380 views
  • LinkedIn Social Icon
  • Twitter Social Icon
  • MicroStrategy_Icon
  • paypal-square-social-media-512