WPF OLAP Grid Control for slice and dice

Overview

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

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.

• Data binding documentation

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.

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

• KPIs documentation

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.

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.

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 documentation

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.

• Conditional formatting documentation

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.

• Cell formatting documentation

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.

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.

Exporting

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

• Exporting documentation