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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


The OLAP grid control organizes and summarizes business data and displays the result in a cross-table format.

WPF OLAP grid control

Effective Data Binding

The OLAP grid control enables you to retrieve multidimensional data from SSAS or any XML/A provider. Following is the list of data sources our OLAP controls widely support:

  • Microsoft SQL Server Analysis Services (SSAS)
  • Mondrian
  • Active Pivot
  • Oracle

OLAP data source binding in WPF OLAP grid control

Data Exploration

Drill member funtionality in WPF OLAP grid control

Drill Member

OLAP grid delivers a detailed view of any selected level member while drilling down and shows an abstract view after drilling up.

Drill position funtionality in WPF OLAP grid control

Drill Position

Grid allows you to drill only the current position of a selected level member, excluding others.

Drill replace funtionality in WPF OLAP grid control

Drill Replace

The drill replace feature replaces an existing node with its respective child nodes that the end user drilled into.

Slicing and Dicing

Slicing and dicing creates a new view for the end user by selecting limited dimensions and measures from the Cube and filtering them.

Slicing and dicing functionalities in WPF OLAP grid control

Key Performance Indicators

KPI is a collection of calculations associated with a measure group that evaluates business success.

Key performance indicators, aka KPI support in WPF OLAP grid control

Named Sets

Named sets are MDX expressions that return a set of dimension members, which can be defined and saved as a part of the Cube definition. Named sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.

Named sets support in WPF OLAP grid control

Calculated Members

You can now create and display dimensions and measures on your own. This can be done only through the report programmatically.

Creates user-defined members in WPF OLAP grid control

Member Properties

Member properties provides basic information about each member in each tuple, including member name, parent level, and number of children.

Member properties support in WPF OLAP grid control

Drill Through

Drill through easily obtains the list of raw items for a particular value or summary cell.

Drill through support in WPF OLAP grid control

Persisting Reports

Settings in the OLAP grid can be serialized to a XML format and loaded back through the built-in deserialization options.

Saves current report in WPF OLAP grid control

Conditional Formatting

Conditional formatting allows users to define conditions that, when met, format value and summary cells’ font, color, and border settings.

Formats cells at run time based on user-defined criteria in OLAP grid control

Dynamic Paging

Extensive support has been provided to load and render large amounts of data without any performance constraint through pager.

Paging supoprt in WPF OLAP grid control

Summary Layouts

You can view grid summaries in different ways, such as normal, top summaries, no summaries, and Excel-like summaries.

Summary view of WPF OLAP grid control

Interactive Features

Freeze headers, aka frozen headers in WPF OLAP grid control

Freeze Headers

There is built-in support for freezing row and column headers for a better view of values.

Hyperlink support in WPF OLAP grid control

Grid retrieves information about a particular cell on hyperlink cell click. It later allows you to perform custom operations programmatically.

Selecting range of cells, aka cell selection in WPF OLAP grid control


Grid has extensive support to select a range of value cells.

Tooltip support in WPF OLAP grid control


Tooltip provides basic information about a cell while hovering the mouse pointer over it..


OLAP grid has a rich set of options available for exporting data to Excel, Word, PDF, and CSV. Several options are also provided to customize the exporting operations.

Exports to Excel, Word, PDF and CSV support in WPF OLAP grid control

Rich Look and Feel

Built-in theme support in WPF OLAP grid control

Built-in Themes

OLAP grid ships with built-in themes like Blend, Office, Visual Studio, and Metro.

Custom XAML styling support in WPF OLAP grid control

Custom Styling

OLAP grid provides ability to customize the appearance of the control to any extent programmatically.

Customizes WPF OLAP grid control appearance using theme studio

Theme Studio

Easily customize all aspects of appearance using the Theme Studio utility.


Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon