MicroStrategy Desktop Features: Comparison
by Version |
Desktop
Analyst |
Desktop
Designer |
| Browse and view
reports and documents |
|
|
| Run live reports |
|
|
| Ability to create
reports |
|
|
| Print and print
preview |
|
|
| Incremental fetch
of large data sets |
|
|
| Prompts on reports
and documents |
|
|
| Search for reports
and documents |
|
|
| User, data and
object level security |
|
|
| Sort by multiple
columns or rows |
|
|
| Format grid using
a choice of built-in styles |
|
|
| Change view mode
between grid and graph |
|
|
| Graph interaction
and modification |
|
|
| Page by viewing
using attributes |
|
|
| Drill down (simple
drill) |
|
|
| Investigative
workflow (drill to template) |
|
|
| Multiple dated
versions of same subscribed report available in history list |
|
|
| Add reports to
history list for later access |
|
|
Simultaneously execute
and retrieve results for multiple reports/documents |
|
|
| View report details
including attribute, metric and filter details |
|
|
| Drill anywhere |
|
|
| Drill on metrics |
|
|
| Investigative
workflow (custom drill paths) |
|
|
|
Export reports to a wide
variety of formats including Microsoft® Excel and PDF |
|
|
| Page by manipulation
(i.e. move attribute to page by axis) |
|
|
| Pivot items between
rows and columns |
|
|
| Save to my reports |
|
|
| Publish user created
reports in shared reports |
|
|
| Rename report
objects |
|
|
| Delete reports,
templates and filters |
|
|
| Add or modify
subtotals |
|
|
| Enable or disable
formatting and report toolbars |
|
|
| Create and save
custom autostyle |
|
|
| Set grid options |
|
|
| Create new folder |
|
|
| Choose attribute
form to display in report |
|
|
| Use data explorer |
|
|
| Create and modify
thresholds |
|
|
| Set report data
options |
|
|
| Create new metric
calculations from existing metrics¹ |
|
|
| Apply view filters
to reports¹ |
|
|
| Modify reports
within predefined analysis area based on Intelligent Cube™¹ |
|
|
| Ad-hoc report
creation within predefined analysis area based on Intelligent Cube¹ |
|
|
| Use report design
mode to build reports from scratch |
|
|
| Use report design
mode to design Intelligent Cubes |
|
|
| Create and modify
report templates that define Intelligent Cubes |
|
|
| Create and modify
report filters that define Intelligent Cubes |
|
|
| Access all objects
for report, template, and filter modification |
|
|
| Save individual
templates and filters |
|
|
| View SQL generated
for a report |
|
|
| Row, column, and
cell level formatting for grid report |
|
|
| Create and modify
consolidations |
|
|
| Create and modify
custom groups |
|
|
| Define and modify
datamarts |
|
|
| Create and modify
documents |
|
|
| Define custom
drill paths |
|
|
| Use the metric
editor to create and modify global metrics |
|
|
| Create and modify
prompts |
|
|
| Create and modify
report filters using Filter Editor |
|
|
| Create and modify
templates using Template Editor |
|
|
| Set VLDB properties |
|
|
| View
ETL info |
|
|
| Define OLAP Cube Reports |
|
|
| Define Freeform SQL
Reports |
|
|
| Create and modify custom
subtotals |
|
|
Generate project documentation |
|
|
| Use PMML models to create
predictive metrics |
|
|