by admin

MicroStrategy is an enterprise business intelligence (BI) application software vendor. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. Interfaces include web, desktop (for developers) and Microsoft Office integration. MicroStrategy Mobile also supports mobile BI.

Unlike a traditional multidimensional OLAP (MOLAP) architecture, which supports summary level reporting, MicroStrategy’s relational OLAP (ROLAP) architecture allows users to “drill anywhere” in the entire relational database, all the way down to transactional-level detail. MicroStrategy has optimizations for all major relational database and data warehouse vendors and can also access multidimensional databases and flat files. While many BI vendors offer full-featured solutions, MicroStrategy’s ROLAP architecture and integrated metadata are key differentiators.

The MicroStrategy platform uses a single common metadata for consistency and streamlined maintenance. MicroStrategy’s 64-bit architecture supports in-memory analytics with “Intelligent Cubes” (i.e. OLAP reports cached in memory as data sets). Metrics and attributes are created once and used across different types of reports. Changes are made in one place and all related reports are automatically updated. Similarly, security permissions are granted in one place, reducing administration costs.