SSAS with PivotGrid

11 posts, 0 answers
  1. Volker
    Volker avatar
    3 posts
    Member since:
    Dec 2008

    Posted 04 Oct 2012 Link to this post

    Hello,

    I just had a look at the PivotGrid control - so far it looks quite good. My question is: How can I display data in the Grid that comes from a Sql Server Analysis Services cube?

    Thanks for your reply!
  2. Galin
    Admin
    Galin avatar
    526 posts

    Posted 05 Oct 2012 Link to this post

    Hello Volker,

    The RadPivotGrid does not support SSAS, but we are planning to integrate it in the Q1 2013 release.

    All the best,
    Galin
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Volker
    Volker avatar
    3 posts
    Member since:
    Dec 2008

    Posted 05 Oct 2012 Link to this post

    Hello Galin,

    thanks for your reply. When is Q1 2013 planned to be released?
  5. Galin
    Admin
    Galin avatar
    526 posts

    Posted 08 Oct 2012 Link to this post

    Hi Volker,

    We are planning to release the Q1 2013 in the middle of February.


    Kind regards,
    Galin
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  6. Julio
    Julio avatar
    6 posts
    Member since:
    Feb 2013

    Posted 05 Feb 2013 Link to this post

    Hi Galin,

     

    Now that OLAP support has been added, to go back to Volker’s question.  How can I display data in the Grid that comes from a Sql Server Analysis Services cube?

  7. Gary
    Gary avatar
    2 posts
    Member since:
    Feb 2013

    Posted 07 Feb 2013 Link to this post

    Yes, please answer this question.  I also want to attach to SSAS OLAP Cube...
  8. Galin
    Admin
    Galin avatar
    526 posts

    Posted 08 Feb 2013 Link to this post

    Hi,

    The beta version of SP1 2013 is released. Please check out this demo.

    Regards,
    Galin
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  9. Gary
    Gary avatar
    2 posts
    Member since:
    Feb 2013

    Posted 08 Feb 2013 Link to this post

    I have looked through the AJAX documentation http://www.telerik.com/help/aspnet-ajax/pivotgrid-olap-support.html but still cannot figure out how to connect to my OLAP cube.

    Is there some straight forward instructions on how this is done that could be forwarded along?

    I would really like to use ADOMD but can't get either method to go.

    Thanks

  10. Galin
    Admin
    Galin avatar
    526 posts

    Posted 13 Feb 2013 Link to this post

    Hello Gary,

    I am afraid the RadPivotGrid currently does not support MDX queries. Please use the connection as it is showed in the demo page.

    Kind regards,
    Galin
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  11. Daniel
    Daniel avatar
    16 posts
    Member since:
    Oct 2007

    Posted 25 Feb 2013 Link to this post

    Hi,

    Same problem for me. I cannot connect the Pivot Grid to SSAS using AdoMD (using the 2013 Q1 release). Neither can I figure out how to diagnose this issue -- how can I attach to an error handler or so?

    Thanks, Daniël 
  12. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 28 Feb 2013 Link to this post

    Hi Daniel,

    Unfortunately the current version of the RadPivotGrid does not have mechanism for handling errors from the OLAP servers; however I will forward this requirement to our developers for further considerations. At a meantime please note that you need to be sure that you have correct definition of your connection string:
    <AdomdConnectionSettings Cube="Adventure Works" DataBase="Adventure Works DW 2008R2"  ConnectionString="Data Source=http://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2">
    </AdomdConnectionSettings>

    Note that the name of the DB is set to Database and in the ConnectionString as Catalog. You need declared it on both places.
    Also could you please verify that you have Microsoft.AnalysisServices library into the bin folder of the application.

    Kind regards,
    Radoslav
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017