I'm trying to connect an ultra pivot grid and mdx data selector to our SSAS tabular model but the MDX data selector is showing as disabled and unpopulated and cannot select anything from the drop downs. Currently I'm still using a trial version of infragistics ultimate. Are these controls disabled in the trial version or do they not work with SSAS tabular model or what else could I be doing wrong?
I'm creating a new ADomdDatasource using an AdomdInitialSettings to initialize the data source. If set the connection string in the settings object as well as the catalog and cube. However, when I look in at the object in the watch window I noticed neither the catalog or cube properties have been set even though they've been specified in the AdomdDatasource.
In the connection string I'm using Provider = MSOLAP;Integrated Security=SSPI;data source = SSASTabularServer;
Thank you for your post!
I am rather curious if you are seeing any handled exceptions within the Output window in Visual Studio. More specifically, if you are seeing any System.ArgumentException instances. If you are, I would then recommend setting your Debug => Windows => Exception Settings so that you break on Common Language Runtime Exceptions => System.ArgumentException. The break message will likely give you more information as to why the AdomdDataSource is not populating, as your connection string looks fine to me in this case.
For example, I have tried to use a connection string that you have provided, but since I am using an http link to the data source, the “integrated security” link is not supported and a System.ArgumentException is thrown.
It’s also worth noting that we have a sample project available as well as a documentation article about creation of an AdomdDataSource that actually uses a tabular model that we host on our site. I am linking the documentation article here, and you can find a sample that runs this in the Windows Forms Samples Browser at WinPivotGrid => Data => PivotGridBindingToAdomd.
Please let me know if you have any other questions or concerns on this matter.
Apologies for the delay in getting back to you. No not seeing any exceptions. Indeed when using the Microsoft Analysis services library I can connect without any issues.
The sample you provided is the one I used when I first set this up. The problem with it though is that it's set up for an http connect. I need to see the correct full syntax for a windows connection. (Would actually be helpful to have this in the same sample).
I've finally found the silent error in this.
Turns out this was the offending error when binding the AdomdDatasource to the MDX Selector control.
System.IO.FileNotFoundException HResult=0x80070002 Message=Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Source=Infragistics4.Olap.DataProvider.Adomd.v19.1 StackTrace: at Infragistics.Olap.Adomd.Core.AdomdDataProvider.DiscoverCatalogsAsync(IEnumerable`1 properties, IEnumerable`1 restrictions) at Infragistics.Olap.Xmla.MdxDataSourceInternal.LoadCatalogs()
I'm surprised a 2019 version of this control requires V 10 of the adomd client as I'm currently working with SQL Server 2017.
I've looked online to find a V10 version but am struggling to find one.
Do you know where I can download this dll? Also I put this forward as a bug please as it should be able to run off the latest version of the adomdclient.
Actually ignore me. School boy error.
I referenced the latest version of the dll in my project and all now is working fine.
Though as I start using it I'm finding some rather quirky behaviour which I will pass on through the support window as I think they're actual bugs.
Thanks again for you help on this and apologies again for late responses.