Setting the Catalogue when connecting to msmdpump.dll

Setting the Catalogue when connecting to msmdpump.dll

Posted by: graz on 5 March 2020, 7:21 am EST

• 

  graz

  • Post Options:
  • Link
    Copy

  Posted 5 March 2020, 7:21 am EST

  Hi I have a connection problem where I have two database instances with one cube each.
  
  I’m able to connect to the first cube i created on the first instance, but can’t seem to connect to the one on the other instance. I suspect this is due to not specifying the catalogue when connecting to the cube. Is it possible to do that anywhere?

  I’ll try to illustrate my setup here below:

  http://localhost/OLAP/msmdpump.dll
  
  |
  
  |- Instance 1
  
  | |
  
  | Cube 1
  
  |
  
  |- Instance 2
  
  |
  
  Cube 2

  I can connect to Cube 1 by using the following connection string:

  var ng = new wijmo.olap.PivotEngine({
  
  itemsSource: {
  
  url: ‘http://localhost/OLAP/msmdpump.dll’
  
  cube: ‘Cube1’
  
  }
  
  });

  But if i try to connect to the other one with Cube2 it does not work.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2020, 1:53 am EST

  Hi,

  We have replied to your case on SupportOne:

  http://supportone.componentone.com/casedetail/424013

  For reference, we are adding the response here:

  Currently, we cannot provide the catalog name. But we have added another property, catalog, that can be added to the itemsSource of PivotEngine along with the url and cube, and will be used to provide the catalog name. This property will be added in the next release of wijmo.

  In the meantime, you can try installing the nightly build of Wijmo and try using the catalog property. But, nightly builds have not been tested properly so I would not recommend you use it in production.

  Regards,
  
  Ashwin