OLAP features in Microstrategy
MSTR OLAP Services uses Intelligent Cube Technology—an in-memory version of report data that can 1 About MicroStrategy OLAP Services can be manipulated by the MicroStrategy Analytical Engine. MicroStrategy Desktop, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse.Many of the standard OLAP features that MicroStrategy provides out of the box, such as:
- Page-by
- Pivoting
- Sorting
- Subtotals
- Banding
- Aliasing
- Outline mode
- Thresholds etc..
- Displaying data on the fly: dynamic aggregation, page
- 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
Comments
Post a Comment