WPF Olap Client Overview

6 May 20211 minute to read

The OLAP client control for WPF supports browsing multidimensional data that is organized in the form of dimensions, measures, named sets, and KPI (key performance indicators) in a cube format. You can visualize the results in graphical and tabular formats (chart and grid). The OLAP client control is also used to create and edit a report on-the-fly that is stored for later use.

Key features

  • Slice and dice: You can slice and dice the cube database.
  • Saving the current session: You can save your current session in an XML file or as a stream for future use and reload it whenever needed.
  • Filtering and sorting: You can specify filters and sorting criteria by using the provided UI options.
  • Chart: A chart is a graphical representation of data, in which data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart.
  • Grid: A grid is a tabular representation of data, arranged in the form of rows and columns and categorized accordingly.
  • Cube selector: Comprises multiple cubes obtained from the data source.
  • Cube dimension browser: Tree view structure that comprises measures, dimensions, hierarchies, named sets, KPI, and so on, belonging to the current cube into independent logical groups.
  • AxisElementBuilder: Allows building an OLAP report by placing elements in different axes of the OLAP client. There are three axes that are supported namely column, row, and slicer.
  • Member editor: A tree view control that displays the member elements of the selected dimension.
  • Measure editor: Comprises a collection of measures.
  • Toolbar: Toolbar provides options for filter, sorting, exporting, and manipulating the OLAP report.
  • Export: You can also export the OLAP grid and OLAP chart to PDF, Microsoft Excel, Microsoft Word, CSV, and other supported image formats.