MicroStrategy OLAP Services Product Benefits
Reduce Cost
MicroStrategy OLAP Services' Intelligent Cubes leverage organizations' existing IT infrastructures to provide more functionality and performance to more users, at less cost. Tests indicate a system could run at 20% less server cost than before.
Optimal Use of Resources
Which Intelligent Cubes should be built? While RAM and Hard Drive space are relatively cheap, they are not limitless. MicroStrategy's Intelligent Cube technology works with the new Cube Advisor tool to determine the optimal set of Intelligent Cubes that should be built to reach a cost reduction goal.
Secure Data Sharing
When accessing Intelligent Cubes, MicroStrategy OLAP Services automatically leverages the user and object security in the MicroStrategy platform. The individual report objects in an Intelligent Cube retain all of the security provisions of the underlying report objects. Those security provisions are dynamically applied to each user's security profile when the Intelligent Cube is accessed. For example if a user only has privileges to view four of five metrics contained in an Intelligent Cube, that user will only have access to the Intelligent Cube data for those four metrics.
Increased User Self-Service and Productivity
With MicroStrategy OLAP Services, business users have more analytic flexibility allowing them to create and modify their own reports, create new calculations from existing Metrics, apply Filter conditions to the report as well spontaneously combine elements of an Attribute to create new lists, attribute filter groupings, and calculations. With MicroStrategy OLAP Services, accessing Intelligent Cubes for such fast OLAP analysis does not require processing on the data warehouse or IT assistance. Users can still seamlessly drill through to the full data warehouse with MicroStrategy's optimized relational SQL Generation Engine.
Better Business Scenarios with MicroStrategy OLAP Services: Beat "Manic Mondays"
Typically, Monday mornings witness the highest traffic of reports being sent to thousands of employees, customers and suppliers. This activity places a higher cost on limited resources. MicroStrategy's new Intelligent Cube is designed to absorb and reduce this strain on resources. By storing data is in an Intelligent Cube, the warehouse does not need to be accessed resulting in improved performance.
Faster Information for Better Decisions
CXOs need important information such as revenue performance, product sales and customer purchases to make important strategic decisions. However, if this information is delayed, it can create unnecessary bottlenecks in the effective functioning of an organization. MicroStrategy Cube Advisor allows prioritization of reports to ensure that the most important reports reach the most important users on time.
Shift Processing Away From the Database
Increasing database capacity is very expensive which makes it imperative for the IT department/administrators to use this limited resource wisely. Administrators can re-allocate expensive query jobs but shifting that processing to an In-memory Intelligent Cube and thus reduce the overall burden. MicroStrategy Cube Advisor is an good choice to effectively determine which queries would be good candidates In-memory cubes.