Custom AdodmDataProvider

[Ângelo]

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,

[Rosen Vladimirov]

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

[rho]

a small sample would be helpfull

[Rosen Vladimirov]

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