Custom AdodmDataProvider

4 posts, 0 answers
  1. Ângelo
    Ângelo avatar
    1 posts
    Member since:
    Nov 2013

    Posted 07 Nov 2013 Link to this post

    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,
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 12 Nov 2013 Link to this post

    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 >>
  3. DevCraft banner
  4. rho
    rho avatar
    9 posts
    Member since:
    Feb 2006

    Posted 09 Dec 2013 Link to this post

    a small sample would be helpfull
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 12 Dec 2013 Link to this post

    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 >>
Back to Top