Has anyone built a custom provider that can hook up to a backend SSAS database, or can direct me to information that can help me create one? I would like to not have to use msmdump.dll if there is an alternative.
Thanks
Cort
Hi, Cort,
I'm currently working on a sample that will demonstrate how to do this. I'll post it here when it is ready.
All the best,
Atanas
Hi,
I'm attaching a working solution, that uses a custom DataProvider that in turn uses a WCF service to access an MS Analysis Server and get data from it through the Adomd Client. The connection totally excludes the use of msmdpump.dll.
I will be publishing an article that clarifies how each part of this sample works. That will happen in the next two weeks. By that time feel free to experiment with the code in the zip file attached. I'll post the link to the post here when it is ready.
I hope this is helpful. Best regards,
P.S.
In order to make this sample work, you need:
to install the MS Adomd.NET Client. If you do not have it installed already you can download it freely from this location.
(optionally if the sample throws unknown exceptions) to install the following two components if you do not already have them:
They are part of the MS SQL Server 2008 R2 Feature Pack
Hi guys,
Atanas is on leave for a short while, but I've written an article that summarizes how to write the custom WCF/ADOMD data provider mentioned here. Check it out if you're interested:
http://community.infragistics.com/blogs/engineering/archive/2010/10/26/building-a-custom-data-provider-for-xampivotgrid-in-silverlight-using-wcf-and-adomd-net.aspx
Happy developing.