ADOMD Data provider

8 posts, 0 answers
  1. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 10 Nov 2012 Link to this post

    Hi,
    I've tried to replace the data provider in the OLAP support example with the Adomd one by the following way but when I run the project I cannot see fields and data (but without errors). I'm using SQL Server 2012.
    I have used the same connection string used in Excel to open this local cube (that works).
    Local cube was generated with XMLA / ASSL and not with CREATE GLOBAL CUBE command.

    ...
    xmlns:telerikDataProviderAdomd="clr-namespace:Telerik.Pivot.DataProviders.Adomd;assembly=Telerik.Pivot.DataProviders.Adomd"
    ...
    <telerikDataProviderAdomd:AdomdDataProvider x:Key="dataProvider">
        <telerikDataProviderAdomd:AdomdDataProvider.ConnectionSettings>
            <telerikDataProviderAdomd:AdomdConnectionSettings
                Cube="MyCube"
                Database="MyDatabase"
                ConnectionString="Provider=MSOLAP.5;Persist Security Info=True;Data Source=C:\1.cub"/>
        </telerikDataProviderAdomd:AdomdDataProvider.ConnectionSettings>
    </telerikDataProviderAdomd:AdomdDataProvider>

    If I try to change C:\1.cub with "localhost" (I've a SSAS instance on localhost with the same cube), all works perfectly.

    Does Adomd provider supports local cube? Or what is wrong in my code?

    Many thanks in advance!
    Regards, 
    Davide


           

     

     

     

     

  2. Milan
    Admin
    Milan avatar
    1989 posts

    Posted 12 Nov 2012 Link to this post

    Hello,

    Ther should be no problem to connect to a local cube. Could you please try connecting to the cube that I have attached. Here are the connection settings:

    <pivot:AdomdDataProvider.ConnectionSettings>
                    <pivot:AdomdConnectionSettings
                        Cube="Northwind"
                        Database="Northwind"
                        ConnectionString="Provider=MSOLAP.5;Persist Security Info=True;Data Source=C:\Northwind.cub;Catalog=Northwind"/>
                </pivot:AdomdDataProvider.ConnectionSettings>


    All the best,
    Milan
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. UI for WPF is Visual Studio 2017 Ready
  4. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 12 Nov 2012 Link to this post

    Hi, 
    it works fine with SQL Server 2008 R2 (10.0) version, also with my local cube file!

    Just for information, I noticed that there is a reference to Microsoft.AnalysisServices.AdondClient.dll version 10.0 into Telerik ADOMD provider. It can be found also by watching the output window during debug:

    ...(Managed (v4.0.30319)): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.AnalysisServices.AdomdClient\10.0.0.0__89845dcd8080cc91\Microsoft.AnalysisServices.AdomdClient.dll'

    I'm working on SQL Server 2012. Perhaps my problem was related to this strong reference?

    Many thanks for the support!
    Regards, 
    Davide
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 15 Nov 2012 Link to this post

    Hi,

    Currently we are working with this version of the AdomdClient library. Is it a problem for you to use it or you can use version 10?

    Thank you for your feedback. I've updated your Telerik points as small sign of our appreciation.

    All the best,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  6. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 15 Nov 2012 Link to this post

    Hi, 
    thanks to you for support! :)

    For me is not a problem but I think that can be better if inside the adomdprovider there is not a specific version reference to AdomdClient assembly. I don't know if it's possible to do this: if I have Adomd 11 on machine, adomdprovider reference is to 11, else if I have Adomd 10, the provider references version 10.

    Thanks!
    Regards, 
    Davide
  7. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 15 Nov 2012 Link to this post

    Hi Davide,

    Thank you for your feedback. We've planned this and in the future we'll probably do it in the same manner you've described.

    Thanks again for your help. Please inform us for any concern, problems or ideas you have regarding RadPivotGrid.

    All the best,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  8. Ihab
    Ihab avatar
    4 posts
    Member since:
    Oct 2014

    Posted 30 Jan 2015 Link to this post

    Has this been fixed yet ?
  9. Polya
    Admin
    Polya avatar
    199 posts

    Posted 30 Jan 2015 Link to this post

    Hi Ihab,

    With the current release RadPivotGrid supports only Microsoft.AnalysisServices.AdomdClient version 10.0.
    You can read more about it in this help article.

    However, we have a feature request for upgrading to Microsoft.AnalysisServices.AdomdClient version 11 logged in our Feedback portal where you can track its status and vote to raise its priority.

    Hope this helps.

    Regards,
    Polya
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for WPF is Visual Studio 2017 Ready