Specify catalog name when connecting to SSAS cubes with pivot engine in angular

Specify catalog name when connecting to SSAS cubes with pivot engine in angular

Posted by: elliot on 17 January 2020, 1:18 am EST

• 

  elliot

  • Post Options:
  • Link
    Copy

  Posted 17 January 2020, 1:18 am EST

  I’m trying to connect to SSAS cubes using the Angular2 pivot engine but can’t find where I can specify the catalog name.

  https://www.grapecity.com/blogs/working-with-olap-cubes This article from 2018 talks about connecting to SSAS cubes using a connection string where the catalog can be set, however the documentation for the angular pivot engine only mentions setting the URL for the msmdpump.dll and the cube name. Is there a way to specify the catalog when I connect with the pivot engine?

          this.ng = new PivotEngine({
              itemsSource: {
                  url: 'https://[URL]/olap/msmdpump.dll',
                  cube: 'Media Cube'
              }
          });
  

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2020, 4:16 pm EST

  Hi Elliot,

  We are currently working on this and will update you as soon as possible.

  Regards,
  
  Ashwin

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2020, 10:45 pm EST

  Hi Elliot,

  I have asked the dev team on this issue. The internal tracking id of the case is 417935. I will provide you with an update as soon as I will hear from them.

  ~regards

• 

  elliot

  • Post Options:
  • Link
    Copy

  Posted 21 January 2020, 3:42 am EST

  Hi Ashwin,

  Thanks for your response, I’ll wait and see!

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 26 January 2020, 8:01 pm EST

  Hi Elliot,

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

  ~regards

• 

  elliot

  • Post Options:
  • Link
    Copy

  Posted 27 January 2020, 9:54 pm EST

  Hi Ashwin,

  Thanks for that, do you have an idea when the next release will be?

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 27 January 2020, 10:01 pm EST

  Hi Elliot,

  Currently, we do not have an ETA on when the next build will be released. But, in the meantime, you may install the nightly build of wijmo and try using the catalog property.

  Let us know if this works for you.

  PS: Nightly builds have not passed through the QA cycles as all of our release builds do. Therefore, they are not suitable in a production environment.

  ~regards

• 

  elliot

  • Post Options:
  • Link
    Copy

  Posted 28 January 2020, 2:26 am EST

  Hi Ashwin,

  Thanks for that I’ll have a look at the nightly build.