MicroStrategy OLAP Services Product Features
Enhanced Intelligent Cube
MicroStrategy OLAP Services provides the enhanced Intelligent Cube, a dynamic in-memory ROLAP cube. MicroStrategy Desktop, MicroStrategy Web, and MicroStrategy Office users enjoy greater analytical flexibility at greater speed than ever before, without having to re-execute SQL against the data warehouse. Intelligent Cubes can make full use of Security Filters, Access Control Lists, and Personalization Engines so a single Intelligent Cube can server many more user requests.
Complete Drilling Capabilities
Drilling from summary level KPIs on scorecards or other reports to transaction level details is effortless with MicroStrategy. By combining Intelligent Cube technology with the industry's only multi-pass SQL generation engine, MicroStrategy lets users freely drill beyond their predefined reports to other Intelligent Cubes' data, or to the complete data warehouse.
Business Attribute Analytics
On-the-fly, business users can create new metrics from existing ones, called Derived Metrics. Users can also dynamically filter the report data to focus their analysis using View Filters. Lastly, users can combine elements of a business attribute to create Filters, Lists, and consolidation Calculations called Derived Elements. All of these significantly enhance and speed up analysis critical for decision making.
World-Class Analytical Function Library
The Analytical Function Library is now included in MicroStrategy Web, revealing the depth and breadth of the analytic capability of the enhanced MicroStrategy OLAP Services module. Over 250 arithmetic and statistical functions, organized in different categories, are available for sophisticated metric definition.
Deploy Easily to Web or Windows®
MicroStrategy OLAP Services enables fast multi-dimensional analysis that can be easily deployed to a Windows client using MicroStrategy Office or MicroStrategy Desktop, or to MicroStrategy Web users through a zero-footprint Web interface.
Dynamically Source Data from Intelligent Cubes
MicroStrategy’s Dynamic Sourcing automatically checks a report request, and automatically sources data from a MicroStrategy Intelligent Cube wherever possible. It also automatically allows the report to source data from warehouse if the data requirements for the report change, or cannot be satisfied by an Intelligent Cube.
Unique Intelligent Cube Insights from the New Cube Advisor Tool
Cube Advisor scans the MicroStrategy Intelligence Server metadata, and suggests the optimal set of Intelligent Cubes to service the reports and users' most valuable requests. Where an application has been generating MicroStrategy Enterprise Manager data, Cube Advisor will use that too, and suggest Intelligent Cubes that are optimized for reducing total Database Time, Job Load, User Satisfaction, and Rows Required.