MicroStrategy Office™ Features
Fully Interactive Reporting, Analysis & Monitoring Capabilities
MicroStrategy Office can meet all the needs of all types of users, whether they require powerful ad hoc analysis, more high-level reporting or simple report-viewing capabilities. MicroStrategy Office users can quickly build new calculations, filter report data, pivot and add subtotals for full OLAP functionality directly from within Microsoft Office. Users can even modify report contents on the fly for instant ad hoc analysis.
Access Corporate Data With MicroStrategy Reports Via Microsoft Office
With MicroStrategy Office, business users never need to leave their Microsoft application to access and present corporate data. Business users can format, sort, and organize data from MicroStrategy reports just as they would any other Microsoft table or chart. Microsoft files can become live repositories of corporate data, continually linked back to the MicroStrategy business intelligence platform. With MicroStrategy Office, users refresh data across all reports in a document with one simple click.
One-click Refresh of All Reports in an Office Document
Once the report book is assembled, business users can reuse it for as long as they like; it is a “live” document. MicroStrategy Office offers one-click refresh that will automatically refresh every report in the workbook. For example, new data may be available every week. With one-click refresh, business users can refresh their report book weekly with one button. This includes parameterized reports; the business user can even specify whether they’d like to re-answer prompts or just reuse their previous prompt selections. And because all the reports originate from a MicroStrategy BI application, the business user and IT can rest assured the data is accurate and secure.
Access Enterprise Data not just in Excel, but also in PowerPoint and Word
Because MicroStrategy Office is integrated as a standard Microsoft Office extensibility interface, users of PowerPoint and Word enjoy easy access to Enterprise Data too. The MicroStrategy Office toolbar works just the same as in Excel, and users enjoy the same range of features, security, and scalability.
Comprehensive Security from Encryption to Cell-Level Security
Data is secured at the cell level using security filters and access control lists. MicroStrategy Office avoids insecure direct database connectivity by using MicroStrategy Web Services, with all the security benefits of the MicroStrategy Platform. As a result, databases are always secured against any hacker attacks, unlike our competitors' products.
Familiar Microsoft Office Conventions and Navigation
With MicroStrategy Office everything works just as you would expect it to within Excel, PowerPoint and Word. Running a report uses intuitive dialog boxes just like any Microsoft Office application. A single click of the mouse accomplishes common tasks like refreshing a report. Additionally, MicroStrategy Office recognizes PivotTables, PivotCharts and gives the user many formatting choices.