What’s New in DXperience 12.1
Silverlight Pivot Table Control
Standalone Field Header Areas
With this release, the DevExpress Silverlight PivotGrid Control allows you to arrange its Field Header Areas via a custom display. This feature is based on the ability of standalone FieldList controls to display both hidden fields and fields from any specified pivot grid area. You need only create individual FieldList controls, configure them to display fields from different areas and place them wherever required. You can even create a tabbed or dock-based layout.
Improved OLAP Browsing in Field List
In OLAP mode, the DevExpress Silverlight PivotGrid Control automatically retrieves measure groups and folders from the server and displays them in the Field List. KPI measures are now shown within a separate category.
User Folders in Field List
For standard data source mode, this release introduces the ability to arrange fields into user-defined folders in the Field List. To implement this new feature, specify a folder for each field. Whenever the field is displayed in the Field List, it will be shown in the specified folder. As you would expect, you can create folder hierarchies, by placing folders one into another.
Displaying and Hiding Fields via Field Lists
Field Lists can now optionally display both visible and hidden fields. In this mode, each field header is accompanied by a check box that allows end-users to control the visibility of corresponding fields.
If an OLAP cube contains KPI (Key Performance Indicator) information, the pivot grid automatically recognizes it and display it using the appropriate format. KPIs are also available for tabular data sources - if a data field contains only 1, 0 and -1 values, you can easily enable KPI graphics for such a field.
An end-user can select the graphics used via the context menu.
Charting Automation Features
When displaying the PivotGrid Control’s data in a chart, you rarely need to compare cell values to Totals or Grand Totals as these values differ significantly. At the same time, when selecting large cell blocks, Total values inevitably appear within the selection. To solve this with previous versions, you had to manually disable a few options that controlled Total value visibility within the bound chart control.
With this release, PivotGrid automatically defines which values should be passed to ChartControl. It analyzes the current selection, finds the lowest-level data and excludes all higher-level Totals. The following animation shows how selection changes are reflected within a bound Chart control.
Yet another new automation feature "rotates" the chart by changing series into arguments and vice versa depending on the current selection. In this mode the control makes sure that the number of series never exceeds the number of arguments.
Data Field Popup Windows
If data field headers do not fit within the Data Header Area, they are displayed in a popup invoked when hovering over the Data Header Area.
Filtering by OLAP Member Unique Names
By default, a pivot grid identifies field values by the corresponding OLAP member values. With this release, you can configure the pivot grid to use OLAP member unique names instead. This option is useful if your cube contains several members with the same value, as it enables the pivot grid to distinguish between such members.
Optimized Performance and Memory Consumption for OLAP
The Silverlight PivotGrid consumes much less memory when fetching summary values if the layout contains one to three data fields. The query generation engine has also been optimized, giving you up to two times faster performance against certain operations (such as expanding field values).
Simplified OLAP Binding
You no longer need to create data source objects nor reference additional assemblies to bind the pivot grid to OLAP cubes. Simply specify the connection string via the OlapConnectionString property.
Interactive Sort by Summary Indicator
The Sort by Summary indicator now displays actual sort order and allows end-users to switch it via a mouse click.
Context Menu Enhancements
- Context Menus for Data Cells
This release adds support for the creation of custom context menus invoked when right-clicking data cells.
- New Event for Customizing Context Menus
Handle the newly introduced PopupMenuShowing event to create and modify context menus on the fly.
- Multirow Filter Area
When the Filter Area contains too many fields to fit within a single line, they are displayed across multiple lines.
- Improved Top N Values Feature
We have introduced a new way to define the number of top values to be displayed (an update for the Top N Values feature – available in OLAP mode). You can now specify the maximum allowed sum of the corresponding summary values and the pivot grid will display the maximum number of field values whose summaries do not exceed the specified number in total.
- New Event for Easy Customization of Data Passed to a Chart
We have introduced a new CustomChartDataSourceRows event that allows you to add, modify and remove specific rows from the chart data source.
- Improved Clipboard Interaction
We have added several settings that allow you to control clipboard interaction, including the copying of fragmentary multi-selections and field value hierarchies with both collapsed and expanded values.