UWP Pivot and OLAP Browser for slice and dice

Data binding

The UWP Pivot and OLAP Browser provides extensive support to bind OLAP and pivot data sources.

• OLAP data sources: SSAS, Mondrian, ActivePivot, and Oracle.
• Pivot data sources: DataTable, DataView, and DataSet from SQL databases or collections like IEnumerable, ICollection, IList, List, and ArrayList.

Drill down and drill up

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.

Axis element builder

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.

Pivot/Cube browser

• OLAP cube organizes its elements such as dimensions, hierarchies, measures, KPIs, and named sets from the selected cube in a tree-like structure.
• Fields are loaded in a list view structure for a pivot data source.

Cube selector

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.

Calculated field

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.

Expression field

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.

Member editor

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.

Measure editor

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.

Report manipulation

• New — Create a new report collection.
• Add — Add a new report in the current report collection.
• Rename — An individual report name can be modified in the current report collection.
• Remove — An individual report can be removed from the current report collection.
• Save — Save the current report collection in XML format.
• Save as — Save the current report with more than one name in XML format.
• Load — Load back the saved report collection that is in XML format.

Toolbar

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

• Toggle axis—Toggle the hierarchies in the row axis and column axis.
• Show and hide expander—Toggle the visibility of expanders used for drill operations.
• Full screen—View the pivot chart and pivot grid in the full screen of the device.
• Defer update—Users can refresh the control on-demand instead of during every user interaction.

Additional options are available only for OLAP data sources:

• Report options—Add, rename, save, load, and remove reports at runtime.
• Cube selector—Select any one of the cubes available in the connected database.
• Report list—Select any report from the report collection bound to the control.
• MDX—Show the MDX query of the current report.
• Paging—Enable or disable the paging option of 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.

Additional options are available only for pivot data sources:

• Expression field—Create a new expression field at runtime.
• Custom summary—Create a new custom summary at runtime.
• Calculated field—Create a new calculated field at runtime.

Layout customization

Users can render the control in different layouts with the help of built-in properties:

• During initial loading, the default view can be either pivot grid or pivot chart.
• At runtime, users can display either a pivot chart or pivot grid alone.
• Users can show or hide columns, rows, slicers, and the value axis.
• Users can show or hide the search box in the cube browser and also expand or collapse its view.
• At runtime, users can show or hide the Pivot Chart and Pivot Grid toolbar.
• Users can show or hide the toggle axis, expanders, report options, report list, and MDX dialog in the main toolbar.
• Users can customize size through the control’s API.

Save and load reports

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.