PivotOLAPBindingDirective

Represents a directive that binds the PivotGrid to data using an Online Analytical Processing (OLAP) service (see example).

html

<kendo-pivotgrid
    kendoPivotOLAPBinding
    [url]="url"
    catalog="Adventure Works DW 2008 SE"
    cube="Adventure Works"
    [columnAxes]="columnAxes"
    [rowAxes]="rowAxes"
    [measureAxes]="measureAxes">
</kendo-pivotgrid>

Selector

[kendoPivotOLAPBinding]

Export Name

Accessible in templates as #kendoPivotOLAPBindingInstance="kendoPivotOLAPBinding"

Inputs

Name	Type	Default	Description
catalog	string		Sets the database name that is used to retrieve the data from the specified connection string.
columnAxes	PivotGridAxis[]		Defines the column axes configuration of the PivotGrid.
cube	string		Sets the cube name that is used to retrieve data for the pivot table rendering.
filter	FilterDescriptor[]		Sets the initial filtered state of the PivotGrid.
measureAxes	PivotGridAxis[]		Defines the measure axes configuration of the PivotGrid.
rowAxes	PivotGridAxis[]		Defines the row axes configuration of the PivotGrid.
sort	SortDescriptor[]		Sets the initial sorted state of the PivotGrid.
url	string		Defines the OLAP service endpoint where the data is processed and retrieved to render the pivot table.

Events

Name	Type	Description
configurationChange	EventEmitter<ConfigurationChangeEvent>	Fires when the Configurator Apply button is pressed. The event is preventable. If you prevent the event, the PivotGrid will not rerender with the new state that results from the configuration changes.
dataLoaded	EventEmitter<PivotDataRowItem[]>	Fires each time 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	EventEmitter<ExpandChangeEvent>	Fires each time a row or column header gets expanded or collapsed by the user. The event is preventable. If you prevent the event, the PivotGrid will not rerender with the new state that results from the user interaction.