ComponentOne ASP.NET Core OLAP Pivot Grid

MESCIUSData Analysis & OLAP Tools.NET

Deliver dynamic, Excel-like pivot tables for ASP.NET Core applications.

  • Provides an Excel-like pivot table UI with intuitive drag-and-drop fields.
  • Supports efficient data processing of millions of records instantly.
  • Connects seamlessly to SSAS cubes and various data sources.
MESCIUS logo

Prices from:

Loading...
Available in
ComponentOne Studio EnterpriseLoading
ComponentOne ASP.NET Core OLAP Pivot Grid product image
ComponentOne ASP.NET Core OLAP Pivot Grid enables developers to integrate advanced pivot table data analysis into ASP.NET Core applications. It mimics Excel's familiar pivot table panel, allowing users to interactively slice and dice large data sets, connect directly to Microsoft Analysis Services cubes, and visualize aggregated data with pivot charts. This component is designed for performance and usability in high-end business intelligence scenarios.

Excel-Like Pivot Panel Interface

Features a user-friendly drag-and-drop pivot panel modeled after Microsoft Excel pivot tables, enabling quick and intuitive arrangement of row, column, value, and filter fields for data summarization.

High-Performance Data Processing

Utilizes a supercharged pivot engine that handles millions of records in milliseconds, leveraging asynchronous processing to enable responsive user experiences with large data sets.

Multiple Data Source Connectivity

Supports direct connections to Microsoft SQL Server Analysis Services (SSAS) cubes, local and online OLAP cubes, data tables, collections of business objects, and various additional data sources via Data Engine Services.

PivotGrid for Summarizing Data

Incorporates an extensible PivotGrid control with automatic data binding, grouped rows and columns, summaries, sorting, filtering, resizing, and drill-down capabilities for detailed data examination.

Integrated PivotChart Visualization

Includes PivotChart components that visualize aggregated pivot data using multiple chart types with support for tooltips, legends, and hierarchical axes to reveal trends and insights visually.

Advanced Filtering and Slicing

Provides slicer controls for interactive filtering of pivot fields, enabling users to quickly modify and understand the scope of displayed data with visual filter states.

Save and Load Views

Allows users to save and restore custom configured pivot views, increasing productivity by preserving analysis setups for future sessions without additional coding.

Outline View Mode

Offers an outline view that presents row fields in a compact, hierarchical format to reduce whitespace and improve data readability on screen.

Export to Excel with Formatting

Supports exporting pivot grid data to Excel spreadsheets while preserving important formatting, including dimensions, fonts, colors, alignment, and more for seamless data sharing.

Product Compatibility

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

Component Type

  • .NET

.NET Version

  • .NET 10 LTS
  • .NET 9 STS
  • .NET 8 LTS
  • .NET 6 LTS

.NET Platform

  • ASP.NET Core Assembly

IDE Support

  • Visual Studio