We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Syncfusion Feedback

Overview

The Blazor Pivot Table can now be connected to multidimensional data (OLAP) that is organized into dimensions, hierarchies, measures, named sets, etc. Its result can be visualized in both tabular (pivot table) and graphical (pivot chart) formats. End users can customize its report on the fly with the help of grouping bar and field list. Reports can be stored for later use.


OLAP cube

OLAP cube is a multidimensional array of data formed by its elements such as dimensions, hierarchies, levels, members, measures, named sets, etc. With the help of the field list UI, end users can visualize and use the OLAP cube elements at runtime.


Drill up/Down

Drill down and drill up

Drill down (expand) and drill up (collapse) actions to visualize data in both abstract and detailed views.


Slice and dice

With slice and dice, the end users can create new views by selecting dimensions and measures from the OLAP cube and filtering them to provide useful information.

Slice and dice


Virtualization

Virtualization

In the Blazor Pivot Table, support has been provided to bring data to the browser with the help of paging MDX query while scrolling and render the component without any performance constraints.


Calculated members and measures

Built-in UI to create and display dimensions and measures according to the requirement. The dynamically created members and measures can be bound to the report to visualize the same in a pivot table.

Calculated members and measures


Named sets

Named sets

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


Drill through

Retrieve the underlying raw data of any aggregated value cell and visualize it in the grid component.

Drill through


Measure groups

Measure groups

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



Struggling to decide on the right product?

Our comprehensive competitor comparison of Blazor components will guide you to the perfect choice.

tick-mark 85+ UI components
tick-mark 960+ interactive Blazor demos
tick-mark 2.2M+ downloads
competitive-banner-FT-image

Blazor Components – 85+ UI and DataViz Components

Scroll up icon