Custom data source API

Data source

HTML

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

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

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 500,
  toolbar: true,
  report: {
    "dataSource": {
        "type": "api",
        "url": "https://olap.flexmonster.com:9500",
        "index": "fm-product-sales"
    },
    "slice": {
        "rows": [
            {
                "uniqueName": "Color"
            },
            {
                "uniqueName": "Country",
                "filter": {
                    "measure": {
                        "uniqueName": "Price",
                        "aggregation": "sum"
                    },
                    "query": {
                        "greater": 68917
                    }
                }
            }
        ],
        "columns": [
            {
                "uniqueName": "Destination"
            },
            {
                "uniqueName": "[Measures]"
            }
        ],
        "measures": [
            {
                "uniqueName": "Price",
                "aggregation": "sum"
            }
        ],
        "expands": {
            "rows": [
                {
                    "tuple": [
                        "color.[red]"
                    ]
                }
            ]
        }
    },
    "version": "2.9.92",
    "creationDate": "2024-12-17T20:30:13.681Z"
}
});