OLAP Client

23 Oct 2019 / 1 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.