Gets or sets a value that determines whether users should be allowed to edit the properties of the PivotField objects owned by this PivotEngine.

Gets or sets a value that determines whether view updates should be generated asynchronously.

This property is set to true by default, so summaries over large data sets are performed asynchronously to prevent stopping the UI thread.

Gets or sets a value that determines whether the engine should generate fields automatically based on the itemsSource.

Gets the ICollectionView that contains the raw data.

Gets the list of PivotField objects that define the fields shown as columns in the output table.

Gets or sets the default filter type (by value or by condition).

Gets the list of PivotField objects exposed by the data source.

This list is created automatically whenever the itemsSource property is set.

Pivot views are defined by copying fields from this list to the lists that define the view: valueFields, rowFields, columnFields, and filterFields.

For example, the code below assigns a data source to the PivotEngine and then defines a view by adding fields to the rowFields, columnFields, and valueFields lists.

// create pivot engine
var pe = new wijmo.olap.PivotEngine();

// set data source (populates fields list)
pe.itemsSource = this.getRawData();

// prevent updates while building Olap view
pe.beginUpdate();

// show countries in rows
pe.rowFields.push('Country');

// show categories and products in columns
pe.columnFields.push('Category');
pe.columnFields.push('Product');

// show total sales in cells
pe.valueFields.push('Sales');

// done defining the view
pe.endUpdate();

Gets the list of PivotField objects that define the fields used as filters.

Fields on this list do not appear in the output table, but are still used for filtering the input data.

Gets a value that indicates whether the engine is currently being updated.

Gets a value that determines whether a pivot view is currently defined.

A pivot view is defined if the valueFields list is not empty and either the rowFields or columnFields lists are not empty.

Gets or sets the array or ICollectionView that contains the data to be analyzed, or a string containing the URL for a ComponentOne DataEngine service.

ComponentOne DataEngine services allow you to analyze large datasets on a server without downloading the raw data to the client. You can use our high-performance FlexPivot services or interface with Microsoft's SQL Server Analysis Services OLAP Cubes.

The PivotEngine sends view definitions to the server, where summaries are calculated and returned to the client.

For more information about the ComponentOne DataEngine services please refer to the online documentation.

Gets the ICollectionView containing the output pivot view.

Gets the list of PivotField objects that define the fields shown as rows in the output table.

Gets or sets a value that determines whether the output pivotView should include columns containing subtotals or grand totals.

Gets or sets a value that determines whether the output pivotView should include rows containing subtotals or grand totals.

Gets or sets a value that determines whether the Olap output table should use zeros to indicate the missing values.

Gets or sets a value that determines whether row and column totals should be displayed before or after regular data rows and columns.

If this value is set to true, total rows appear above data rows and total columns appear on the left of regular data columns.

Gets the list of PivotField objects that define the fields summarized in the output table.

Gets or sets the current pivot view definition as a JSON string.

This property is typically used to persist the current view as an application setting.

For example, the code below implements two functions that save and load view definitions using local storage:

// save/load views
function saveView() {
  localStorage.viewDefinition = pivotEngine.viewDefinition;
}
function loadView() {
  pivotEngine.viewDefinition = localStorage.viewDefinition;
}