PivotOLAPBindingDirective
A directive which binds the PivotGrid to data using an Online Analytical Processing (OLAP) service (see example).
Selector
[kendoPivotOLAPBinding]
Export Name
Accessible in templates as #kendoPivotOLAPBindingInstance="kendoPivotOLAPBinding"
Inputs
Name | Type | Default | Description |
---|---|---|---|
catalog |
|
The database name that is used to retrieve the data from the specified connection string. | |
columnAxes |
|
Represents the column axes configuration of the PivotGrid. | |
cube |
|
The cube name that is used to retrieve data for the pivot table rendering. | |
filter |
|
Represents the initial filtered state of the PivotGrid. | |
measureAxes |
|
Represents the measure axes configuration of the PivotGrid. | |
rowAxes |
|
Represents the row axes configuration of the PivotGrid. | |
sort |
|
Represents the initial sorted state of the PivotGrid. | |
url |
|
The OLAP service endpoint where the data is processed and retrieved to render the pivot table. |
Events
Name | Type | Description |
---|---|---|
configurationChange |
|
Fires when the Configurator Apply button is pressed. The event is preventable. If you prevent the event, the PivotGrid will not be rerendered with the new state, resulting from the configuration changes, applied through the configurator interface. |
dataLoaded |
|
Fires each time when new data is loaded and transformed to show aggregated values. The event fires upon initialization and on user interaction that changes the state of the PivotGrid. |
expandChange |
|
Fires each time a row or column header gets expanded or collapsed by the end user. The event is preventable. If you prevent the event, the PivotGrid will not be rerendered with the new state, resulting from the end user interaction. |