MVC Pivotgrid with OLAP Cube

3 posts, 0 answers
  1. Konstantinos
    Konstantinos avatar
    2 posts
    Member since:
    May 2015

    Posted 07 May 2015 Link to this post

    I have an AnalysisServices Server Installed and i have created a cube in it. I need to add a pivotgrid into my site for browsing said cube.
    My site is done using MVC controls and i have added an MVC Pivotgrid using the code below:

            .DataSource(dataSource => dataSource
                .Transport(transport => transport
                    .Connection(connection => connection
                    //.Read(read => read
                    //    .Url("RDC-35")
                .Events(e => e.Error("onError"))

     But i cannot understand where to put the server name. As far as i can tell i need to use .Read(x => x.Url("http://blah.blah") ). and that i need to have an http address for my server installed, as mentioned here:

    The PivotDataSource component communicates with OLAP cube instance on HTTP using the XMLA protocol
    Is this the only way? Can't i use Adomd or ADO.NET?


    P.S. i have found examples with code like the one below that imply using adomd is an option:

     <AdomdConnectionSettings Cube="Adventure Works" DataBase="Adventure Works DW 2008R2" ConnectionString="Data Source=;Catalog=Adventure Works DW 2008R2"></AdomdConnectionSettings>

    Please forgive me if i have misunderstood anything, i am new to your controls and doing my best to understand them and start using them

  2. Konstantinos
    Konstantinos avatar
    2 posts
    Member since:
    May 2015

    Posted 07 May 2015 in reply to Konstantinos Link to this post

    Forgot to mention that i am currently working localy. Both analysis services and IIS are on the local machine.
  3. Georgi Krustev
    Georgi Krustev avatar
    3742 posts

    Posted 12 May 2015 Link to this post

    Hello Konstantinos,

    The Kendo UI PivotGrid can be bound either to msmdpump.dll service (HTTP access to SSAS) or to server proxy that communicates with OLAP cube using ADOMD. Here is a code library that demonstrates how to use the latter approach:
    Let me know if something is not clear.

    Georgi Krustev

    See What's Next in App Development. Register for TelerikNEXT.

Back to Top