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 Atanas,
I've tried the attached sample but it has some issues with local cubes. con.Open throws exceptions when I'm setting up the dimensions/measures with the dataselector. Is this a known limitation or just a bug?
Thanks and best regards,
Tamás
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,
Atanas
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, 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,