# PivotDataSourceBuilder

## Methods

### Xmla()

Selects XMLA binding for multidimensional data and returns a builder for configuring the cube connection, axes, measures, and requests.

#### RETURNS

The [PivotXmlaDataSourceBuilder](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/pivotxmladatasourcebuilder) object to support method chaining.

#### Example

```
 
            @(Html.Kendo().PivotGrid()
               .Name("pivotgrid")
               ...
               .DataSource(dataSource => dataSource.
                   Xmla()
                   .Columns(columns => {
                       columns.Add("[Date].[Calendar]").Expand(true);
                   })
                   .Rows(rows => rows.Add("[Geography].[City]"))
                   .Transport(transport => transport
                       .Connection(connection => connection
                           .Catalog("Adventure Works DW 2008R2")
                           .Cube("Adventure Works"))
                       .Read(read => read
                           .Url("https:\\//demos.telerik.com/service/v2/olap/msmdpump.dll")
                           .DataType("text")
                           .ContentType("text/xml")
                           .Type(HttpVerbs.Post)
                       )
                   )
               )
            )
             
```

### Custom()

Selects custom binding and returns a builder for configuring the response schema, transport, axes, measures, and filters.

#### RETURNS

The [PivotCustomDataSourceBuilder](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/pivotcustomdatasourcebuilder) object to support method chaining.

#### Example

```
 
            @(Html.Kendo().PivotGrid()
               .Name("pivotgrid")
               ...
               .DataSource(dataSource => dataSource
                .Custom()
                 ...
                )
            )
             
```

### Ajax()

Selects ASP.NET MVC Ajax binding for remote flat data and returns a builder for configuring the model, schema, transport, sorting, and filters.

#### RETURNS

The [PivotAjaxDataSourceBuilder](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/pivotajaxdatasourcebuilder) object to support method chaining.

#### Example

```
 
            @(Html.Kendo().PivotGrid()
               .Name("pivotgrid")
               ...
               .DataSource(dataSource => dataSource
                .Ajax()
                 ...
                )
            )
             
```