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...
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.
Hello tbabur,
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.
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.
Have you set clientaccesspolicy.xml to allow access to location where msmdpump.dll is located?
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.