MicroStrategy ONE
How Drilling and Selectors Work Together
When you drill on a document that contains an element selector, the attribute, consolidation, or custom group used in the selector becomes the page-by element for the drilled-to report or document.
- If only one element is chosen in the selector, the drilled-to report displays that element.
- If multiple elements are chosen in the selector, the drilled-to report displays the first selected element.
For example, a document contains a grid report that displays revenue values by Category and Subcategory. The document also contains a selector on Year that targets the grid. (Although Year is not displayed on the grid, it is included in the dataset.) The document is displayed after 2010 has been selected in the selector. Note that the revenue for the Art & Architecture subcategory is $158,651.
Drill to Item from Art & Architecture. On the drilled-to report, display subtotals (from the Data menu, select Show Totals). Notice that the report is paged by Year (2010 only) and the revenue total for Art & Architecture is $158,651, the same as shown in the grid in the document.
Return to the original document (by using the MicroStrategy back button), which still has 2010 selected. Select 2011 in the selector as well. The revenue amount for Art & Architecture is now $365,872, as shown below. (Only a portion of the full document is shown in the sample.)
Once again drill to Item from Art & Architecture. On the drilled-to report, display subtotals. Notice that the report is paged by Year (2010 only, since it is the first year selected in the original report) and the revenue subtotal for Art & Architecture is $158,651, the same as shown in the grid in the document.
Related Topics
Drilling Into Related Data on Grids and Graphs
Interacting with a Document: Selectors
How Links, Drilling, and Selectors Work Together
How to Use Selectors to Change the Data Displayed in a Document