ADOMD Data provider

[purdav]

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


       

 

 

 

 

[Milan]

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

[purdav]

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

[Rosen Vladimirov]

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

[purdav]

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

[Rosen Vladimirov]

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

[Ihab]

Has this been fixed yet ?

[Polya]

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