High-Speed Excel-Like Pivot Tables and Charts
Process and aggregate thousands of rows in milliseconds with no server-side dependencies
- Incorporate Wijmo's Excel-like web-based pivot tables and charts
- Interpret data types and intelligently place fields in an intuitive, modern UI with our PivotPanel
- Connect your Microsoft SSAS cubes directly to Wijmo's OLAP controls
- First-class Angular, React, and Vue support
Why Choose Wijmo's High-Speed Excel-Like Pivot Tables and Charts?
Increase User Productivity
Wijmo's OLAP module includes the ability to allow users to save and load views, process large amounts of data asynchronously, and run background work on the data. This allows users to increase productivity by processing more data at a time.
Server-Side OLAP Support
Use the ComponentOne Web API on your server to add server-side support to Wijmo's OLAP controls. This will allow you to offload features from the client to the server, such as data sorting and filtering. Requires ComponentOne Web API.
Connects Directly to Microsoft SSAS Cubes
Bind your PivotGrid or PivotChart controls directly to your existing SQL Server Analysis Service cubes. Does not require the ComponentOne Web API.
Built for Speed
Wijmo's OLAP controls are optimized for speed and efficiency. Process, aggregate, sort, and filter hundreds of thousands of rows of data in milliseconds.
Excel-Like Panel Design
Wijmo's Pivot Panel provides users with a familiar, Excel-like panel for managing your data. Select the fields to add to your PivotGrid or PivotChart, determine what fields to filter by, and set your row and column fields.
Multiple Ways to View your Data
Display your data in a PivotGrid or PivotChart, and use OLAP's Slicer module to allow users to quickly and easily change the data being viewed.
Drag and Drop Pivot Fields in the Smart PivotPanel
- Feels familiar to users with the Excel-like panel design feel
- Allows users to drag fields into “view” lists representing row, column, value, and filter
- Save time with smart data interpretation—panel intelligently places fields, and build-in save/load views
- Use the same field multiple times in values
- Asynchronous processing provides a progress bar and background work
- Read more about creating basic pivot tables
- See how to answer recurring questions with pre-defined views
Display Excel-Like Data Summaries in PivotGrid
Visualize Large Data Sets With PivotChart
Visually Filter Data With Slicers
Wijmo's Slicer control allows users to filter data based on values and indicates the current filter state. This makes it easy for users to understand what's being displayed in filtered PivotGrid and PivotChart components.
Server-Side OLAP Support
Client-side OLAP engine: Wijmo’s Pivot components were created for analyzing datasets on the client. Our client-side OLAP engine can handle relatively large amounts of data (in the order of hundreds of thousands of records), but it requires the raw data to be downloaded to the client, and that makes it impractical to analyze really large datasets (millions of records), so we've added server-side options.
Direct connection to Microsoft SSAS cubes: There's no need for the server-side API if you already have Microsoft SSAS cubes in place! Learn more in the blog.
Optional server-side support: Use a URL in the itemSource property to instruct the OLAP components to query a Web API on the server instead of analyzing an array on the client. The server-side engine is part of our ASP.NET MVC product line and must be installed and licensed separately. We recommend purchasing Ultimate so that you have both server and client-side components for our OLAP components.
The PivotGrid control allows you to heavily customize the look, feel, and functionality of every cell within the pivot table to match your style requirements. You're able to conditionally style cells, add custom components and sparklines to cells, and dynamically update cells within the PivotGrid.
Both PivotGrid and PivotChart support exporting their content. Wijmo's PivotGrid control allows users to export the pivot table to either XLSX, CSV, or PDF, while the PivotChart allows users to export the chart as a PNG, JPEG, or SVG image.