Connecting to MS Analysis Services via XMLA - subquery example

Data source

HTML

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

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

JavaScript

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
	toolbar: true,
	report: {
    "dataSource": {
        "dataSourceType": "microsoft analysis services",
        "proxyUrl": "https://olap.flexmonster.com/olap/msmdpump.dll",
        "catalog": "Adventure Works DW Standard Edition",
        "cube": "Adventure Works"
    },
    "slice": {
        "reportFilters": [
            {
                "uniqueName": "[Geography].[Country]",
                "filter": {
                    "members": [
                        "[Geography].[Country].&[Canada]",
                    ]
                }
            }
        ],
        "rows": [ { "uniqueName": "[Delivery Date].[Calendar]" } ],
        "columns": [ 
            { "uniqueName": "[Product].[Category]" },
            { "uniqueName": "[Measures]" }
        ],
        "measures": [ { "uniqueName": "[Measures].[Order Count]" } ]
    }
	}
});