Browse multidimensional data organized into dimensions, measures, named sets, and KPIs in a cube format, as well as pivot data, with the UWP Pivot and OLAP Browser. You can visualize the results in graphical (UWP Pivot Chart) and table (UWP Pivot Grid) formats. The control can also be used to create and edit reports at runtime that can be stored for later use.
The UWP Pivot and OLAP Browser provides extensive support to bind OLAP and pivot data sources.
All features work smoothly on touch devices with ease. Features such as drag and drop, drill up and drill down, filtering, sorting, and report manipulation can be done on the fly.
View the control layout on mobile devices.
End users can enable the built-in features of Pivot Grid either through UI or a simple, user-friendly API in code behind.
For more details about the built-in UWP Pivot Grid features, check here
End users can enable the built-in features of UWP Pivot Chart either through UI or a simple user-friendly API in code-behind.
For more details about the built-in UWP Pivot Chart features, check here
End users can easily slice and dice the OLAP cube elements of their choice to visualize performance, trends, outliers, and more.
The slice-and-dice feature creates a new view for the end user by selecting limited dimensions and measures from the OLAP cube and filtering them.
KPIs are a collection of calculations associated with a measure group that evaluates business success. A few KPIs are defined and listed earlier during the time of OLAP cube creation itself.
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 user preference.
Load and render large amounts of data through paging without any performance constraints.
Named sets simplify MDX queries and provide useful aliases for complex, commonly used set expressions.
You can create and display your own dimensions and measures at runtime.
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.
There is built-in support to drill down (expand) and drill up (collapse) to visualize the pivot grid and pivot chart information in both abstract and detailed views.
The axis element builder is similar to the pivot table field list in Excel, as it allows you to create and manage the control with multidimensional (OLAP) and pivot data sources. End users can drag hierarchies or fields and filter them to create reports at runtime.
The cube selector allows you to select any one of the cubes available in the connected database. Based on the selected cube, the corresponding cube element gets loaded into the control. You can perform this only for OLAP data sources.
Easily filter and view data using built-in normal and Excel-like filter UIs with advanced filtering options. It is also possible to filter programmatically.
Display only selective values for a field either through the UI or code behind.
Filter column and row headers based on either label text or grand total value.
Order rows and columns either in ascending or descending order.
Order the column and row header either in ascending or descending order. You can do this only for pivot data sources.
Order the column and row header based on the custom comparer defined by the user. You can do this only for pivot data sources.
Orders the columns and rows based on measure values. You can do this only for OLAP data sources through reports in code behind.
Along with 10 built-in summary types, you can define your own custom summaries. You can do this only for pivot data sources.
You can insert new calculations and use 16 built-in calculation types. You can do this only for pivot data sources.
The calculated field, otherwise known as an unbound field, generates a unique field with your own calculated value by executing a simple user-defined formula. You can use this only with pivot data sources.
An expression field generates data by executing a user-defined expression. The generated data is specific to a few field(s) from the underlying data source. You can apply this only for pivot data sources.
The member editor dialog displays members of the selected field in a tree-like structure. You can filter the members and this is applicable only with OLAP data sources.
The measure editor dialog displays a collection of measures from the current report. You can filter the measures and this is applicable only with OLAP data sources.
The following options are available in the toolbar to perform reporting operations:
Additional options are available only for OLAP data sources:
Additional options are available only for pivot data sources:
Users can render the control in different layouts with the help of built-in properties:
You can save reports from the current session in XML format for later use. UI support is provided for Save, Save As, and Load Report operations. You can do this only with OLAP data sources.
Ships with built-in themes like Blend, Office 2010, Office 2016, Office 365, Visual Studio 2013, Visual Studio 2015, Metro, Lime, and Saffron.
You can customize the control’s appearance to any extent in code behind.
For a great developer experience, flexible built-in APIs are available to define and customize the UWP Pivot and OLAP Browser. Developers can optimize the data bound to the control and customize the user interface (UI) completely using code with ease.
Users from different locales can use the control by applying appropriate date formats, currency formats, and number formats.
The text direction and layout of the control can be displayed in the right-to-left (RTL) direction.
Users can customize the text in the user interface based on the local culture.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.