ComponentOne ASP.NET MVC OLAP Pivot Grid

MESCIUSData Analysis & OLAP Tools.NET

Excel-like pivot tables and analysis for ASP.NET MVC applications.

  • Supports drag-and-drop pivot panels like Microsoft Excel.
  • Handles millions of records with a fast in-memory engine.
  • Connects to Microsoft SSAS cubes and various data sources.
MESCIUS logo

Prices from:

Loading...
Available in
ComponentOne Studio EnterpriseLoading
ComponentOne ASP.NET MVC OLAP Pivot Grid product image
ComponentOne ASP.NET MVC OLAP Pivot Grid provides a highly interactive data analysis component for ASP.NET MVC developers. It enables users to slice and dice large datasets in real time, mimicking Excel pivot table functionality, with capabilities to aggregate, filter, and visualize data seamlessly within web applications.

Excel-Like Pivot Panel Interface

Users can intuitively drag and drop fields to create pivot views representing rows, columns, values, and filters, benefiting from a familiar and user-friendly layout modeled after Microsoft Excel pivot tables.

Advanced Data Aggregation and Summaries

The pivot grid aggregates and summarizes data across grouped rows and columns, supporting multiple value fields to compare different metrics within the same dimension efficiently.

Slicer Component for Dynamic Filtering

An interactive slicer UI lets users quickly filter pivot data via clickable buttons that clearly indicate the applied filtering states, enhancing data exploration and discovery.

Integration with Microsoft SSAS Cubes

It connects to Microsoft SQL Server Analysis Services (SSAS) cubes, supporting both online and local cube data sources without requiring additional server APIs.

Comprehensive Data Source Support

Beyond SSAS, the OLAP Pivot Grid supports binding to local data, business object collections, SQL databases, and web services through ComponentOne Data Engine Services, enabling versatile data connectivity.

PivotGrid Customization and Export

Developers can customize the grid's appearance using styles and owner-draw cells, and easily export the pivot data to Excel while preserving formatting and layout.

Built-In Save and Load Views

The control provides functionality to save and load pivot views allowing end-users to quickly return to saved analyses, boosting productivity and user experience.

Asynchronous Processing for UI Responsiveness

Background processing with progress indication enables multiple analytical operations simultaneously without blocking the user interface, improving responsiveness and user interaction.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • .NET

.NET Version

  • .NET 4.8 or earlier

.NET Platform

  • ASP.NET MVC

IDE Support

  • Visual Studio