[Solved] SSAS 2012 with pivotgrid

[Lubos]

Is it possible to connect kendo ui pivotgrid to our SSAS service in SQL 2012 Ent ? I configured HTTP XMLA on IIS and it works with Excel, Visual Studio or Management studio. I am sure in my configurations. your demo example works but it is obviously SSAS 2008R2.

 

$("#pivotgrid").kendoPivotGrid({
            configurator: "#pivotconfigurator",
            height: 550,
            dataSource: {
                type: "xmla",
                transport: {
                    connection: {

                       catalog: "AdventureWorksDW2012Multidimensional-EE",
                       cube: "Adventure Works"
                    },
                    read: {
                        url: "http://test.cz/olap/msmdpump.dll",
                    }
                },
                error: function (e) {
                    alert("error: " + kendo.stringify(e));
                },
                schema: {
                    type: "xmla"
                }
            }
        });

[Stefan]

Hello Lubos,

I can suggest checking the following articles on the recommended way to setup the Kendo UI PivotGrid to work with SSAS service:

http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/fundamentals

http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/olap-cube-setup

Also, if the error still occurs, please check the console for additional errors, and if the requests are successful.

If additional assistance is needed, please provide more information about the used setup and the steps to reproduce the issue.

Regards,
Stefan
Telerik by Progress