Hey,
I am trying to build a solution using a PivotGrid to connect to a cube data source. I have connected to this data source in .NET using ADOMD and I was able to query the cube fine.
However, in silverlight using the infragistics PivotGrid control, I am unable to connect to my cube. I have tried several different approaches:
- First I tried the example supplied with the tool kit, the XMLADataSource example. This did not help as the msmdpump.dll is not exposed on my server and I dont think I will be able to expose this.
- I then tried the 'working solution' here: http://community.infragistics.com/forums/p/44832/252837.aspx#252837 and then I replaced the missing references with my newer ones, and now I get a build error about missing a directive or assembly reference for the type/namespace: MeasureAggregator and I can't find any information about this class anywhere.
Can anyone help me? We are basically trying to get a treemap generated from cube data and we are running into a lot of problems.
Cheers
Hi,
I think the OP's point was how to get the example solution for doing a custom provider for the xmla data , as described in 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 to work in newer releases than the 10.2 that the example was for.
I got it working on 11.1 after a bit of fiddling, but 11.2 broke it again.
As some of us dont wish to or cant expose the data straight to the net. And using the pump also brings forth the problem of supplying end users with suitable credentials for their data. As our silverlight projects are already handling authentication and authorization, providing the xmla data with wcf services seems more feasible.
Hello,
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. I have been looking into your post and I suggest you go through this walkthrough:
http://blogs.infragistics.com/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspx
Where it is explained in details what you need to do to achieve your goal. Also here you can read more about Data binding in XamPivotGrid:
http://help.infragistics.com/NetAdvantage/DV/2011.2/CLR4.0/?page=xamPivotGrid_Binding_Data_to_the_xamPivotGrid.html
Feel free to write me if you have further questions.