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

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

The WPF OLAP Grid control organizes and summarizes business data and displays results in a cross-table format.

WPF OLAP grid control


OLAP data source binding in WPF OLAP grid control

Data binding

The WPF OLAP Grid control enables you to retrieve multidimensional data (OLAP) from SSAS or any XML/A provider. The data sources supported are SSAS, Mondrian, ActivePivot, and Oracle.


Slice and dice

With the slice and dice feature, you can create a new view for end users by selecting dimensions and measures from the OLAP cube and filtering them.

Slicing and dicing functionalities in WPF OLAP grid control


Drill-down and drill-up

Drill down (expand) and drill up (collapse) to visualize the grid information in both abstract and detailed views.

Drill member funtionality in WPF OLAP grid control

Drill member

This option 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

You can drill only the current position of a selected level member.

Drill replace funtionality in WPF OLAP grid control

Drill replace

This option replaces an existing node with its child nodes into which the end user has drilled.


Key performance indicators support in WPF OLAP grid control

Key performance indicators (KPIs)

KPIs are collections of calculations associated with a measure group that evaluates business success. Typically, these calculations are a combination of multidimensional expressions (MDX) or calculated members. Four different types of KPI indicators available are:

  • Goal
  • Status
  • Trend
  • Value

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 OLAP 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


Creates user-defined members in WPF OLAP grid control

Calculated members and measures

You can create and display your own dimensions and measures in reports through code behind.


Member properties

Member properties provide basic information about each member in each tuple, including member name, parent level, and number of children. These member properties are available for all members at any given level and can be enabled in reports through their code behind.

Member properties support in WPF OLAP grid control


Filtering

With built-in filtering options, you can easily filter and visualize data. It is also possible to filter programmatically.

Member filtering support in WPF OLAP Grid

Filtering by member

You can filter the headers in rows and columns based on hierarchy members to selectively display records.You can filter the headers in rows and columns based on hierarchy members to selectively display records.

Value filtering support in WPF OLAP Grid

Filtering by value

You can filter the results in rows and columns based on active measures to selectively display records.


Value sorting support in WPF OLAP Grid

Sorting

Order the columns and rows based on measure values. You can do this only through reports in code behind.


Paging

Load and render a large amount of data without any performance constraints through paging.

Paging support in WPF OLAP Grid


Drill through support in WPF OLAP grid control

Drill-through

The drill-through feature obtains a list of raw items for a particular value cell or summary cell.


Conditional formatting

Define conditions that, when met, format the font, color, and border settings of values and summary cells.

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


Cell template support in WPF OLAP grid control

Cell template

Format the column header, row header, summary cell, and value cell of the control.


Number formatting and date formatting

Number formatting and date formatting help to transform the appearance of the actual cell value.

Formats cells at run time in OLAP grid control


Visualization

Users can visualize the control as a pivot table, similar to Excel. Users can also position summaries at the top or hide the summaries.

Normal layout

The normal layout looks like the pivot table in earlier Excel versions, allowing end users to view the parent and child members adjacent to each other.

Normal view of WPF OLAP Grid control

Summary layout

The summary layout easily switches the summary position to either the top or bottom beside each member in the control.

Summary view of WPF OLAP Grid control

Excel-like layout

The Excel-like layout simulates the pivot table look and feel of Excel with child members positioned below their parent member with some indent space.

Excel-like view of WPF OLAP Grid control

No summaries

The no-summaries layout hides the subtotal and grand total and shows only header and value cells.

No summary view of WPF OLAP Grid control


Totals in WPF OLAP grid control

Totals

Subtotals and grand totals are calculated automatically by the engine inside the control and displayed in the grid. This helps users make decisions based on the totals.


Column and row

Hyperlink support in WPF OLAP grid control

Clicking a hyperlink cell helps users retrieve information about that particular cell. This feature allows you to perform custom operations through code.

Tooltip support in WPF OLAP grid control

Tooltip

Tooltip provide basic information about a value cell while the pointer hovers over it.

Freeze headers in WPF OLAP grid control

Freeze header

Users can freeze row and column headers while performing scroll operations to have a precise view of the content.

Cell selection in WPF OLAP grid control

Selection

Select a range of value cells.


Save and load reports

Settings in the WPF OLAP grid control can be serialized to an XML format and saved. The saved report can be loaded back through the built-in deserialization options.

Saves current report in WPF OLAP grid control


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

Exporting

Export data to Excel, Word, PDF, and CSV formats. You can customize the exporting operations.


Custom style and themes

Built-in theme support in WPF OLAP Grid

Built-in themes

Ships with built-in themes like Blend, Office 2010, Office 2013, Office 2016, Office 365, Visual Studio 2013, Visual Studio 2015, and Metro.

Custom XAML styling support in WPF OLAP Grid

Custom styling

You can customize the control’s appearance to any extent in code behind.

Customize WPF OLAP Grid appearance using theme studio

Theme studio

Easily customize all aspects of the control’s appearance using the Theme studio utility.


Developer-friendly API

For a great developer experience, flexible built-in APIs are available to define and customize the WPF OLAP Grid control. Developers can optimize the data bound to the control and customize the user interface (UI) completely using code with ease.


Globalization and localization

Globalization support in WPF OLAP Browser

Globalization

Users from different locales can use the control by applying appropriate date formats, currency formats, and number formats.

RTL support in WPF OLAP Browser

Right to left (RTL)

The text direction and layout of the control can be displayed in from right-to-left(RTL).

Localization support in WPF OLAP Browser

Localization

Users can customize the text in the user interface based on the local culture.


95+ WPF CONTROLS

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion reduces customers’ development time.
Here are some of their experiences.

Rated by users across the globe

Transform your applications today by downloading our free evaluation version Download Free Trial

Syncfusion WPF Resources

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Up arrow icon
Live Chat Icon For mobile