This is a migrated thread and some comments may be shown as answers.

SSAS 2012 with pivotgrid

1 Answer 68 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Lubos
Top achievements
Rank 1
Lubos asked on 05 Sep 2016, 01:15 PM
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"
                }
            }
        });

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 07 Sep 2016, 08:57 AM
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
 
Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
 
Tags
PivotGrid
Asked by
Lubos
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or