OLAP/XMLA connectivity

Data source

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<button onclick="diagnostic()">Diagnostic</button>

<div id="pivot-container"></div>

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true
});

let proxyUrl = 'https://olap.flexmonster.com/olap/msmdpump.dll';
let dataSourceInfo = '';
let dataSourceType = '';
let catalog = '';
let cube = '';

function diagnostic() {
  getDataSources();
}

function getDataSources() {
  pivot.getXMLADataSources(proxyUrl, onDataSourceLoaded);
}

function onDataSourceLoaded(result) {
  dataSourceInfo = result[0];
  dataSourceType = pivot.getXMLAProviderName(proxyUrl);
  pivot.getXMLACatalogs(proxyUrl, dataSourceInfo, onCatalogsLoaded);
}

function onCatalogsLoaded(result) {
  catalog = result[0];
  pivot.getXMLACubes(proxyUrl, dataSourceInfo, catalog, onCubesLoaded);
}

function onCubesLoaded(result) {
  cube = result[0];
  pivot.connectTo({
    dataSourceType: dataSourceType,
    proxyUrl: proxyUrl,
    dataSourceInfo: dataSourceInfo,
    catalog: catalog,
    cube: cube
  });
}