WPF OLAP Client Control for slice and dice

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.

• Data binding documentation

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.

Named sets

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

• Named sets documentation

Calculated members and measures

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

• Calculated members and measures documentation

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.

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.

• Axis element builder documentation

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 documentation

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.

• Cube selector documentation

Sorting

Orders the columns and rows based on measure values.

• Sorting documentation

Paging

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

• Paging documentation

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 documentation

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.

• Measure editor documentation

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 documentation

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.

• Toolbar documentation

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.

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.

• Save and load reports documentation