Hi, I meet with Infragistics XamPivotGrid newly and I start to search about it. I apologize if my question is simple.
In my project I use OLAP cubes and They do not respond quickly. So I decide to use XamPivotGrid. It respond quickly and visual is simple. When I am exploring could not find answer to these two question:
1. I could not decide what I have to use, XmlaDataSource or Adomd. İf I use XmlaDataSource I have to open all cubes to all users . (Because I must allow IUSR role on Analysis Server ). And I have read on blog that Adomd is used for local Cubes. But my cubes is not local. They are served on about 40 servers.
2. Nowadays, I try all connection types on WPF and Silverlight application. I connect to my cubes by using XmlaDataSource on WPF project. But I used same connection sentences on Silverlight applicaition but I could not access to cubes. I am doing somthing wrong with msmdpump.dll file but what?It is my connection code:
Uri uri = new Uri("...../olap/msmdpump.dll");
XmlaDataSource ds = new XmlaDataSource();
xamPivotGrid1.DataSource = ds;
xamPivotDataSelector1.DataSource = ds;
I would be glad, if you help me. Thank you in advance...
Hello tbabur,
I have been looking into your issue and I can see a couple of things that would prevent you from using this. I’d like to start with the AdomdDataSource, since this is posted in the Silverlight community forum, I assume you are going to use this in a Silverlight application, however the AdomdDataSource is available only for WPF projects, as you have suggested, and is installed only with the NetAdvantage for WPF DV, so this would rule out that option.
Regarding the second part of your question and the code snippet you have provided, I am not sure whether this Uri path is correct as it would target an object inside you project folder. If you want to test this out I can suggest you use this path: "http://sampledata.infragistics.com/olap/msmdpump.dll". Also in your code snippet you never set the “uri” variable to the XmlaDataSource’s ServerUri property. With all that in mind your code can be changed to:
Uri uri = new Uri("http://sampledata.infragistics.com/olap/msmdpump.dll");
ds.ServerUri = uri;
xamPivotSataSelector1.DataSource = ds;
Please let me know if I can be of any further assistance on the matter.
Thank you or reply. I don't know Adomd connection is possible only WPF. So I have to use XmlaDataSource. I use "http://sampledata.infragistics.com/olap/msmdpump.dll" URL and I saw the cubes. But when I use my url I do not see my cubes. But with same url I reached my cubes on WPF application.
Maybe it is about the sql server 2005. I use sql server 2005. Maybe It does not support the silverlight?
Hello,
I am just checking if you got this worked out or you still require any assistance or clarification on the matter.
If this is what you were looking for please verify the answer so it helps other users as well.
I checked the role permissions and do the same steps like this post but I still can' t reach my cubes.
I reached with WPF applicaiton but not silverlight. I could not solve my problem.
Have you set clientaccesspolicy.xml to allow access to location where msmdpump.dll is located?
Yes I've Checked the clientaccesspolicy.xml file and located it in the folder that contain msmdpump.dll file. They are in the same folder. But the problem continues.
Yes. I could see the my cubes. I had put the clientaccesspolicy.xml ile wrong folder. Now I put it in the wwwroot folder and it is Ok. Thank you your answers.
I have been following your correspondence with Plamen and my understanding is that the clientaccesspolicy.xml should be located in the wwwroot virtual folder and not in the same folder as the msmdpump.dll, as in your case.
Please let us know if you require any further assistance on the matter.