Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
335
XmlaDataSource or Adomd ?
posted

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...

Parents
No Data
Reply
  • 27093
    posted

    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");

    XmlaDataSource ds = new XmlaDataSource();

    ds.ServerUri = uri;

     

    xamPivotGrid1.DataSource = ds;

    xamPivotSataSelector1.DataSource = ds;

     

    Please let me know if I can be of any further assistance on the matter.

Children