SSAS 2012 with pivotgrid

2 posts, 0 answers
  1. Lubos
    Lubos avatar
    1 posts
    Member since:
    Aug 2016

    Posted 05 Sep Link to this post

    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"
                    }
                }
            });

  2. Stefan
    Admin
    Stefan avatar
    272 posts

    Posted 07 Sep Link to this post

    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.
     
  3. Kendo UI is VS 2017 Ready
Back to Top