|
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 |
|
 |