MicroStrategy is a comprehensive enterprise analytics platform that transforms raw data into actionable intelligence through a unified metadata architecture. Founded in 1989, it provides end-to-end BI capabilities from data modeling and report authoring to mobile delivery and embedded analytics. Unlike many cloud-first competitors, MicroStrategy's ROLAP architecture with Intelligent Cube in-memory acceleration offers both flexibility and performance at scale. A key mental model: MicroStrategy treats everything as metadata objects — reports, metrics, attributes, even security filters — stored in a central repository that drives consistency across the entire platform, making large-scale BI governance practical where ad-hoc tools fail.
What This Cheat Sheet Covers
This topic spans 20 focused tables and 129 indexed concepts, 112 flashcards. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
A jump-to index of every table row in this cheat sheet.
An interactive map of every table and concept in this topic.
Table 1: Core Platform Architecture
MicroStrategy runs as a classic three-tier stack, and these are the pieces you actually install and operate. The Intelligence Server is the engine room — everything else either feeds it definitions, queries it, or renders what it returns — so seeing how the metadata repository, web tier, and authoring tools orbit that server is the first step to reasoning about any deployment.
| Component | Example | Description | |
|---|---|---|---|
mstrsvr.exe process managing 100+ concurrent users | • Central application server that orchestrates query execution, caching, scheduling, and security • the heart of MicroStrategy's 3-tier architecture | ||
SQL Server database storing all object definitions | • Centralized relational database that stores definitions of all reports, dashboards, metrics, security settings, and schema mappings • enables single-source-of-truth governance | ||
Importing 200 tables from Oracle data warehouse | • Schema discovery tool that reads physical database structures and maps them to MicroStrategy logical objects • maintains synchronization between warehouse and metadata | ||
Tomcat or IIS hosting MicroStrategy Library UI | • Presentation layer serving dashboards, dossiers, and reports through modern HTML5 interfaces • supports responsive design and mobile devices | ||
Desktop application for schema design and advanced authoring | • Unified desktop tool combining schema modeling, dossier creation, and administrative tasks • replaces legacy Developer and Architect tools | ||
iOS/Android native apps with offline capabilities | • Native mobile platform delivering dashboards with touch gestures, camera integration, and geo-location • works offline with cached data |