igPivotGrid
Namespace: Wisej.Web.Ext.Ignite
Assembly: Wisej.Web.Ext.Ignite (4.1.0.0)
The igPivotGrid is a jQuery UI widget that displays multidimensional (OLAP) data in a pivot table, allowing users to arrange hierarchies and measures in rows, columns and filters.
- C#
- VB.NET
public class igPivotGrid : igBase
Public Class igPivotGrid
Inherits igBase
Constructors
igPivotGrid()
Constructs a new instance of the igPivotGrid class.
Example:
The following example creates a pivot grid and connects it to an OLAP cube through the Options object.
var grid = new igPivotGrid();
grid.Options.dataSourceOptions = new
{
xmlaOptions = new
{
serverUrl = "https://myserver/olap/msmdpump.dll",
catalog = "Adventure Works DW Standard Edition",
cube = "Adventure Works"
},
rows = "[Date].[Calendar]",
columns = "[Product].[Product Categories]",
measures = "[Measures].[Internet Sales Amount]"
};
grid.Dock = DockStyle.Fill;
this.Controls.Add(grid);
igPivotGrid(options)
Constructs a new instance of the igPivotGrid class using the specified options.
| Name | Type | Description |
|---|---|---|
| options | Object | Initial set of options passed to the igPivotGrid widget: an anonymous object, a JSON string or a dynamic object. |
Example:
The following example creates a pivot grid that shows the sales amount by product category and calendar year, read from an OLAP cube.
var grid = new igPivotGrid(new
{
dataSourceOptions = new
{
xmlaOptions = new
{
serverUrl = "https://myserver/olap/msmdpump.dll",
catalog = "Adventure Works DW Standard Edition",
cube = "Adventure Works"
},
rows = "[Product].[Product Categories]",
columns = "[Date].[Calendar]",
measures = "[Measures].[Internet Sales Amount]"
},
compactColumnHeaders = true
});
grid.Dock = DockStyle.Fill;
this.Controls.Add(grid);