Pivot Grid with OLAP in SharePoint

[Amit]

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

[Tsvetoslav]

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

[Amit]

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

[Tsvetoslav]

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