OLAP Browser for the React Pivot Table

  • Connects multidimensional data (OLAP) provided by Microsoft Analysis Services (SSAS) via XMLA.
  • Creates a report using dimensions, hierarchies, measures, named sets, calculated members and measures, etc., from OLAP cube at runtime.
  • Virtual scrolling of large data is possible.
FREE TRIAL

No credit card required.

React React Pivot Table Olap

Overview

Connect the React Pivot Table to multidimensional (OLAP) data organized into dimensions, hierarchies, measures, and named sets. Visualize results in both tabular and graphical formats. Customize reports through the field list and grouping bar, and save report configurations for later use. OLAP data binding supports multidimensional data analysis through Pivot Tables and Pivot Charts.

OLAP cube

An OLAP cube is a multidimensional array of data organized into dimensions, hierarchies, levels, members, measures, and named sets. Explore and analyze OLAP cube elements at runtime through the field list interface.

Drill up/Down

Drill down and drill up

Built-in support for drill down (expand) and drill up (collapse) has been provided to visualize data in both abstract and detailed views.

Slice and dice

Create new views by selecting dimensions and measures from the OLAP cube and applying filters through slice-and-dice operations.

Slice and dice

Virtualization

Virtualization

Virtual scrolling retrieves data through paging MDX queries as users scroll and renders the data returned for the current view. It is suitable when large OLAP datasets need to be explored across multiple data ranges.

Calculated members and measures

Built-in UI is available to create and display calculated members and measures according to the user requirement. The dynamically created members and measures can be bound to the report in order to visualize the same in pivot table.

Calculated members and measures

Named sets

Named sets

Named sets are collections of dimension members created from predefined MDX expressions in the OLAP cube.

Drill through

Retrieve and display the underlying raw data for any aggregated value cell in a grid for detailed analysis and review.

Drill through

Measure groups

Measure groups

Organize measures belonging to the same underlying fact table in a group.

Explore all Syncfusion React components

Explore over 140+ React UI components featuring established, and production-ready controls built for modern web app development.

Scroll up icon
Syncfusion Feedback