ComponentOne Studio ASP.NET MVC controls introduces OLAP, a powerful data analysis control designed and developed to cater high-end business intelligence needs. It provides analytical processing features to those found in Microsoft Excel Pivot Table and Pivot Charts. OLAP provides asynchronous processing that improves the performance of the controls as multiple processes can occur simultaneously on separate threads.
OLAP can take up data in any format and provides an easy-to-use interface so users can quickly and intuitively create summaries that display the data in different ways, uncovering trends and providing valuable insights interactively. OLAP uses Pivot Engine which is designed to speed up the retrieval of data from the databases, that helps the user to process huge amount of data with ease.
OLAP uses the following components to do online analytical processing.
- Pivot Panel - The PivotPanel represents as the core component of OLAP, as it provides a user interface for interactively representing the regular data tables into PivotTable, PivotGrid and PivotChart. You can simply provide a database to the PivotPanel, and represent the data in a PivotTable that provides custom views summarizing the data according to your requirements.
- Pivot Grid - The PivotGrid is an extension to an already existing FlexGrid class that helps users to create PivotTables and use the FlexGrid features in your OLAP control. There are many different features of FlexGrid that can be utilized in MVC OLAP such as, automatic data binding, grouped row and columns, resizing columns, filtering data and showing details for each cell in the grid.
- Pivot Chart - The PivotChart component is an extension to FlexChart class that helps the user to automatically bind data to PivotPanel object, automatic tooltips, chart type selection, and palette selection. You can export these charts to different file formats such as PNG and JPEG, and you can customize the chart styles and interactivity according to your requirements.
- Pivot Engine - The data engine is a a low-footprint C# component that can be easily integrated in your OLAP applications. The engine stores data in memory-mapped files, which are retrieved instantly without any delay in importing these files. The Pivot Engine does not put any restriction on the size of the dataset that you wish to analyze or display, and that too without compromising the performance.