Pivot Grid with OLAP in SharePoint

4 posts, 0 answers
  1. Amit
    Amit avatar
    3 posts
    Member since:
    Nov 2011

    Posted 03 Jun 2013 Link to this post

    Hi,

    I am using telerik version 2013.1.130.35.

    I am trying to bind Grid (RadPivotGrid) with OLAP Cube using ADOMD in a SharePoint application page.

    <OlapSettings ProviderType="Adomd">
                <AdomdConnectionSettings Cube="XXXX" DataBase="XX" ConnectionString="Provider=MSOLAP;Data Source=SERVERNAME;Initial Catalog=XX;User Id=Domain\UserName;Password=Password;">
                </AdomdConnectionSettings>
            </OlapSettings>

    When page gets loaded, no data gets populated in grid.

    Requesting you to provide assistance to have this issue resolved.

    Thanks and Regards,
    Amit Thakkar
  2. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 05 Jun 2013 Link to this post

    Hi Amit,

    Do make sure that you have the adomd provider dll (it goes with the telerik package) deployed on your sharepoint machine. If already done, take your grid set-up outside of SharePoint and test it to see if you get the same result.
     
    Regards,
    Tsvetoslav
    Telerik
    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. Amit
    Amit avatar
    3 posts
    Member since:
    Nov 2011

    Posted 07 Jun 2013 Link to this post

    Hi,

    Thanks for reply.

    There are 3 versions of Microsoft.AnalysisServices.AdomdClient [(1) 9.0.242.0 (2) 10.0.0.0 (3) 11.0.0.0] are deployed in SharePoint machine, might this be an issue?

    One more thing I would like to let you know is, connection string being used works perfectly in Excel.

    I tried to use connection string of Telerik Demo on SharePoint environment and it worked fine, so I am not sure whether this is issue of environment or not.

    Thanks and Regards,
    Amit Thakkar
  5. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 11 Jun 2013 Link to this post

    Hello Amit,

    With the current release RadPivotGrid supports only Microsoft.AnalysisServices.AdomdClient version 10.0. You can download it from here <http://www.microsoft.com/en-us/download/details.aspx?id=30440> . After installing it, you will find the Microsoft.AnalysisServices.AdomdClient.dll under C:\Program Files (x86)\Microsoft.NET\ADOMD.NET\100.

    http://www.microsoft.com/en-us/download/details.aspx?id=30440
     
    Regards,
    Tsvetoslav
    Telerik
    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 the blog feed now.
Back to Top