The main features of OLAP for MVC that you may find useful are as follows:
- Multiple Value Fields
OLAP supports multiple fields in the Values list. Users can drag multiple fields into the Values list and see the results in grid and chart.
- Enhanced and Powerful Data Engine
OLAP is built with a new, powerful data engine that stores data in memory-mapped files using column-oriented technology. The C1DataEngine offers high-speed processing of very large datasets that makes it possible to reach high performance of up to hundreds of millions records in a fraction of a second. The engine also supports query operations such as Aggregation, Joins, Grouping, Filter, Unary/Binary operations, etc. For more information, see Data Binding topic.
- Enhanced User Interface
OLAP comes with an enhanced, Excel-like user interface (UI) offering modern color schemes in toolbar, drop-down menus, tables and charts.
- Multiple Theme Support
OLAP allows developers in choosing a theme that suits their application requirements. To support multiple themes, ASP.NET MVC controls include build in theme support.
- Plot data on PivotGrid
OLAP provides you PivotGrid control support to display data in a grid-like view. The FlexGrid class library enables you to customize your OLAP application. For information on FlexGrid control, see FlexGrid topic.
- Display data at runtime
Use the PivotPanel to determine which fields of your data source should be used to display data and how. Drag fields between the lower areas of the PivotPanel to create a filter, column headers, row headers, or get the sum of values from a column or a row. For more information, see PivotPanel topic.