OLAP Services features

As an extension of MicroStrategy Intelligence Server, OLAP Services uses Intelligent Cube Technology—an in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent Cubes to achieve the best efficiency and performance in your application.

As a MicroStrategy user, you may already take advantage of the many standard OLAP features that MicroStrategy provides out of the box, such as page-by, pivoting, sorting, and subtotals.

With the OLAP Services feature, you can perform additional OLAP analysis, using the following features:

• Displaying data on the fly: dynamic aggregation
• Creating metrics on the fly: derived metrics
• Defining attribute elements on the fly: derived elements
• Filtering data on the fly: view filters and metric filters
• Importing data as an Intelligent Cube