MicroStrategy ONE
Selectors in an RS dashboard with multiple datasets
Before you begin
Selectors provide Report Services (RS) dashboards with interactivity, allowing each user to change how he sees the data, as described in Providing interactivity to users: Selectors. You should know the difference between filtering and slicing selectors, as described in Applying selections as filters or slices.
If an RS dashboard contains multiple datasets, which items are displayed in a selector depends on the selector type:
-
A slicing selector shows only the items available on the target.
-
A filtering selector shows all the items available in all the datasets.
For example, an RS dashboard contains the following datasets:
-
Profit by Category, which contains Category and Profit, and is filtered for Books, Electronics, and Movies
-
Revenue by Category, which contains Category and Revenue, and is filtered for Movies and Music
A Grid/Graph is created using the Profit by Category dataset as the data source. A slicing selector is created to target the Grid/Graph. The selector displays Books, Electronics, and Movies as selector items, based on the elements available in the target.
If the selector is changed to be a filtering selector, the selector displays Books, Electronics, Movies, and Music as selector items, based on the categories available in all the datasets on the RS dashboard. Because the Profit by Category data source does not contain data on Music, Music cannot be displayed on the Grid/Graph.
If the Grid/Graph used the Revenue by Category dataset as the data source instead, a filtering selector still displays all the categories. Even when the All item is selected, the Grid/Graph displays only Movies and Music, since those are the only categories available on the Grid/Graph's data source.
Change the selector to slice the target, and only the categories in the data source's filter (Movies and Music) are shown in the selector.