Connecting to MSAS via XMLA - localeIdentifier example

Data source

by Flexmonster Pivot Table

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",
				// URL to msmdpump.dll 
        proxyUrl: "http://olap.flexmonster.com/olap/msmdpump.dll",
        catalog: "Adventure Works DW Standard Edition",
        cube: "Adventure Works",
        // Microsoft Locale ID Value for French
        //localeIdentifier: 1036,
        subquery: "select {[Delivery Date].[Calendar].[Calendar Year].&[2008]} on columns from [Adventure Works]"
    },
    "slice": {
        "rows": [
            {
                "uniqueName": "[Product].[Product Categories]"
            }
        ],
        "columns": [
            {
                "uniqueName": "[Delivery Date].[Calendar]",
                "caption": "Delivery Date.Calendar"
            },
            {
                "uniqueName": "[Measures]"
            }
        ],
        "measures": [
            {
                "uniqueName": "[Measures].[Revenue Trend]",
                "aggregation": "sum"
            }
        ]
    }
	}
});