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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

Browse multidimensional data (OLAP) organized into dimensions, measures, named sets, and KPIs in a cube format with the WPF OLAP Browser. You can visualize the results in graphical (OLAP Chart) and table (OLAP Grid) formats. The control can also be used to create and edit reports at runtime that can be stored for later use.


Data binding

The WPF OLAP Browser 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.

OLAP data source binding in WPF OLAP Browser


WPF OLAP Grid

End users can enable built-in features in the OLAP Grid either through UI or a simple, user-friendly API in the code-behind.

For more details about the built-in OLAP Grid features, check out the documentation


WPF OLAP Chart

End users can enable built-in features of the OLAP Chart either through UI or a simple, user-friendly API in the code-behind.

For more details about the built-in OLAP Chart features, check out the documentation


Slicing and dicing functionalities in WPF OLAP Browser

Slice and dice

Slice and dice creates a new view for end users by selecting limited dimensions and measures from the cube and filtering them.


KPIs

KPI support in WPF OLAP Browser

Predefined KPIs

KPIs are a collection of calculations associated with a measure group that evaluates business success. A few KPIs are defined and listed when the OLAP Cube is created.

Virtual KPI support in WPF OLAP Browser

Virtual KPIs

Users can create their own KPIs at runtime and write expressions as well. In an expression, positive numbers will be represented by a green light or up arrow, and negative numbers will be represented by a red light or down arrow, depending on the users preferences.


Named sets

The named sets simplify MDX queries and provide useful aliases for complex, commonly used set expressions.

Named sets support in WPF OLAP Browser


Creates user-defined members in WPF OLAP Browser

Calculated members and measures

You can create and display your own dimensions and measures at runtime.


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 programmatically.

Member properties support in WPF OLAP Browser


Drill-down and drill-up

There is built-in support for drilling down (expand) and drilling up (collapse) to visualize the OLAP Grid and OLAP Chart information in both abstract and detailed views.

Drill member support in WPF OLAP Browser

Drill member

This option delivers a detailed view of any selected member while drilling down and shows an abstract view after drilling up.

Drill position support in WPF OLAP Browser

Drill position

You can choose to drill only at the current position of a selected member.


Axis element builder support in WPF OLAP Browser

Axis element builder

The axis element builder is similar to the pivot table field list in Excel, and allows you to create and manage the control with multidimensional (OLAP) data sources. End users can drag hierarchies and filter them to create reports at runtime.


Cube browser

Organizes the selected OLAP cube’s elements such as dimensions, hierarchies, measures, KPIs, named sets, and more in a tree-like structure.

Cube browser support in WPF OLAP Browser


Cube selector support in WPF OLAP Browser

Cube selector

Allows you to select any of the cubes available in the connected database. Based on the selected cube, the corresponding cube element is loaded into the 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 Browser

Filtering by member

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

Value filtering support in WPF OLAP Browser

Filtering by value

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


Sorting

Orders the columns and rows based on measure values.

Value sorting support in WPF OLAP Browser


Paging support in WPF OLAP Browser

Paging

Extensive support has been provided to load and render a large amount of data without any performance constraints through paging.


Member editor

The member editor dialog displays members of the selected hierarchy in a tree-like structure for easy filtering. When a large number of members is bound to the member editor, lazy loading is enabled automatically.

Member editor support in WPF OLAP Browser


Measure editor support in WPF OLAP Browser

Measure editor

The measure editor dialog displays a collection of measures from the current report. You can apply filters, reorder them, and remove a specific measure from the current report at runtime.


Report manipulation

  • New: Create a new report collection.
  • Add: Add a new report in the current report collection.
  • Rename: Individual report names can be modified in the current report collection.
  • Remove: Individual reports can be removed from the current report collection.
  • Save: Save the current report collection in XML format.
  • Save as: Save the current report by different names in XML format.
  • Load: Load back a report collection saved in XML format.

Report manipulation support in WPF OLAP Browser


Toolbar support in WPF OLAP Browser

Toolbar

The following options are available in the toolbar to perform common reporting operations:

  • Connect to server: Connect a data source with the WPF OLAP browser through offline cube, online server, or connection string.
  • Report options: Add, rename, save, load, and remove reports at runtime.
  • Report list: Select any report from the report collection bound to the control.
  • Toggle axis: Toggle the hierarchies in the row axis and column axis.
  • Show or hide expanders: Toggle the visibility of expanders used for drill operations.
  • MDX: Show the MDX query of the current report.
  • Paging: Enable or disable the paging option to the control.
  • Calculated members and measures: Create a new calculated member or measure at runtime.
  • Virtual KPI: Create a new virtual KPI element at runtime.
  • Filtering: Filter members based on the grand total of a specific measure.
  • Sorting: Sort headers based on the grand total of a specific measure.
  • Full screen: View the OLAP Chart and OLAP Grid in full-screen mode.

Layout customization

Allows users to render the control in different layouts with the help of the following built-in features:

  • During initial loading, the default view can be either the OLAP Grid or OLAP Chart.
  • Display either the OLAP Chart or OLAP Grid alone.
  • Show or hide the cube selector.
  • Show or hide columns, rows, and slicer axes at runtime.
  • User can show or hide the search box in the cube browser and also expand or collapse its view.
  • Show or hide the OLAP Chart and OLAP Grid toolbar.
  • Show or hide subset filters, cube connections, loaded reports, saved reports, expanders, the report list, and the MDX dialog in the main toolbar at runtime.
  • Customize the layout’s size through the control’s API.

Layout customization support in WPF OLAP Browser


Saves current report in WPF OLAP Browser

Save and load reports

You can save reports from the current session in XML format for later use. You can also save and load reports from databases programmatically.


Custom style and themes

Built-in theme support in WPF OLAP Browser

Built-in themes

Ships with built-in themes like Blend, Office 2010, Office 2007, Office 2003, Transparent, and Metro.

Custom XAML styling support in WPF OLAP Browser

Custom styling

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

Customize WPF OLAP Browser appearance using theme studio

Theme studio

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


Globalization and localization

Globalization support in WPF OLAP Browser

Globalization

Allows users from different locales to 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

Allows users to customize the text in the user interface based on the locale culture.


Developer-friendly API

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


90+ WPF CONTROLS

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