- MicroStrategy - OLAP Services
- MicroStrategy - Importing Data
- MicroStrategy - Architecture
- MicroStrategy - Desktop
- MicroStrategy - Environment Setup
- MicroStrategy - Overview
- MicroStrategy - Home
MicroStrategy Objects
- MicroStrategy - Report Objects
- MicroStrategy - Schema Objects
- MicroStrategy - Public Objects
- Configuration Objects
MicroStrategy Basic Reporting
- MicroStrategy - Nested Metrics
- MicroStrategy - Creating Metrics
- MicroStrategy - Rollup
- MicroStrategy - Drilldown
- MicroStrategy - Pivoting
- MicroStrategy - Dicing
- MicroStrategy - Slicing
- MicroStrategy - Report Types
MicroStrategy Advanced Reporting
- MicroStrategy - Intelligent Cubes
- MicroStrategy - Refreshing Reports
- Shortcut & Embedded Filters
- MicroStrategy - Advanced Filters
- MicroStrategy - Creating Filters
- MicroStrategy - Metric Comparison
- Creating Derived Metrics
MicroStrategy Dashboards
- MicroStrategy - Adding Web Content
- Filtering Data in Dashboard
- Visualization with Multiple Datasets
- MicroStrategy - N/W Visualization
- Heat Map Visualization
- MicroStrategy - Grid Visualizations
- MicroStrategy - Graph Visualizations
- Formatting a Dashboard
- Creating a Dashboard
MicroStrategy Office
- MicroStrategy - Predictive Models
- MicroStrategy - Data Marts
- MicroStrategy - Report Cache Flow
- MicroStrategy - Custom Groups
- Conditional Formatting
MicroStrategy Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
MicroStrategy - Drilldown
Drilldown is the process of going down in a hierarchy of dimensions to get more granular values of the measures. In a data set with more than one dimension, which is pnked to each other in an hierarchical fashion, we start with a dimension at the top and then gradually add more dimensions to get new granular values.
Drill-down options give more insight into how different values at each level get aggregated.
Example
In the all_slaes data set, let’s consider the following 3 dimensions appped to the measure Sales.
Product Line
Category
Subcategory
Following are the steps to perform a drill-down.
Step 1
Create a visuapzation with dimension - product pne and measure sales as shown in the following screenshot.
Step 2
Add the dimension category to the visuapzation below Product Line. As you can see the value of the sales column changes, reflecting the values for each category under the product pne.
Step 3
Next, let’s add the dimension sub-category below the dimension category and it further changes the values in the sales column.
Advertisements