New to Kendo UI for Angular? Start a free 30-day trial

PivotOLAPBindingDirective

Directive

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

Definition

Package:@progress/kendo-angular-pivotgrid

Selector:[kendoPivotOLAPBinding]

Export Name:Accessible in templates as #kendoPivotOLAPBindingInstance="kendoPivotOLAPBinding"

Syntax:

html

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

Inputs

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.

Default:

[]

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.

Default:

[]

rowAxes

PivotGridAxis[]

Defines the row axes configuration of the PivotGrid.

Default:

[]

sort

SortDescriptor[]

Sets the initial sorted state of the PivotGrid.

Default:

[]

url

string

Defines the OLAP service endpoint where the data is processed and retrieved to render the pivot table.

Events

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.