This is a migrated thread and some comments may be shown as answers.

Custom AdodmDataProvider

3 Answers 19 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Ângelo
Top achievements
Rank 1
Ângelo asked on 07 Nov 2013, 05:58 PM
Is it possible to use the RadPivotGrid with a custom AdodmDataProvider ?

Actually i'm using the Infragistics PivotGrid and i was able to do that like this:

XmlaDataSource xmlaDataSource = new XmlaDataSource();
xmlaDataSource.DeferredLayoutUpdate = false;
xmlaDataSource.ConnectionSettings = new AdomdConnectionSettings();
this.PivotGrid.Datasource = xmlaDataSource;

All i had to do was to create the AdomdConnectionSettings implementing IConnectionSettings interface, where i define my custom AdomdDataProvider.

Can i do that with using RadPivotGrid (silverlight) ?

Regards,

3 Answers, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 12 Nov 2013, 01:15 PM
Hello,

RadPivotGrid for Silverlight doesn't support Adomd connection, but you can use XmlaDataProvider and modify the connection settings based on your needs. For this purpose you can define Cube, Database, ServerAddress, Credentials, Encoding, etc. In order to define additional properties to the connection, you can use QueryProperties collection to add your custom properties that have to be specified to the connection string:
var xmlaConnectionSettings = new XmlaConnectionSettings()
{
    Cube = "Adventure Works",
    Database = "Adventure Works DW 2008R2",
    ServerAddress = @"http://someaddress/olap/msmdpump.dll",
                 
};
 
var xmlaQueryProperty = new XmlaQueryProperty();
xmlaQueryProperty.Name = "QueryPropertyName";
xmlaQueryProperty.Value = "QueryPropertyValue";
 
xmlaConnectionSettings.QueryProperties.Add(xmlaQueryProperty);
 
var xmlaDataProvider = new XmlaDataProvider();
xmlaDataProvider.ConnectionSettings = xmlaConnectionSettings;

Hopefully this helps.

Regards,
Rosen Vladimirov
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
0
rho
Top achievements
Rank 1
answered on 09 Dec 2013, 03:54 PM
a small sample would be helpfull
0
Rosen Vladimirov
Telerik team
answered on 12 Dec 2013, 07:49 AM
Hello Reinhard,

The code below is everything you need. Just use the created DataProvider in your RadPivotGrid and RadPivotFieldList and everything should work as expected. You can also take a look at this article for more details on the usage of XmlaDataProvider.

Hope this helps.

Regards,
Rosen Vladimirov
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Tags
PivotGrid
Asked by
Ângelo
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
rho
Top achievements
Rank 1
Share this question
or