API call updateData: updating data from SSAS

Data source

by Flexmonster Pivot Table

HTML

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

<button onclick="updateDataSSAS()">Update data from SSAS</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/",
  report: {
    dataSource: {
      filename: "data/data.json"
    },
    slice: {
    	rows: [
      	{ uniqueName: "Country" }
      ],
      columns: [
      	{ uniqueName: "Color" },
        { uniqueName: "[Measures]" }
      ],
      measures: [
      	{ uniqueName: "Price" }
      ]
    },
    conditions: [
    	{
      	formula: "#value >= 10000",
        measure: "",
       	format: {
        	backgroundColor: "#F57C00",
        	color: "#FFFFFF"
        }
      }
    ]
  }
});

function updateDataSSAS() {
  pivot.updateData({
    type: "microsoft analysis services",
    proxyUrl: "https://olap.flexmonster.com/olap/msmdpump.dll",
    catalog: "Adventure Works DW Standard Edition",
    cube: "Adventure Works",
  });
}