<div id="pivotgrid"></div>
<script>
$("#pivotgrid").kendoPivotGridV2({
    pdf: {
        fileName: "Sales-Report.pdf",
        autoPrint: true,
        margin: {
            top: "2cm",
            left: "1cm",
            right: "1cm",
            bottom: "1cm"
        }
    },
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: 'https://demos.telerik.com/service/v2/olap/msmdpump.dll'
        }
    }
});
</script>