This article illustrates how to build a report based on an Elasticsearch data source. 

Step 1: Embed the component into your web page

Set up an empty component in your HTML page. If Flexmonster is not yet embedded – return to Quick start. Your code should look similar to the following example:

<div id="pivotContainer">The component will appear here</div>
<script src="flexmonster/flexmonster.js"></script>
<script>
	var pivot = new Flexmonster({
		container: "pivotContainer",
		toolbar: true,
		licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
	});
</script>

Step 2: Enable cross-origin resource sharing (CORS)

By default, the browser prevents JavaScript from making requests across domain boundaries. CORS allows web applications to make cross-domain requests. To enable CORS, open elasticsearch.yml and add the following configuration:

http.cors.enabled: true
http.cors.allow-origin: "*"
http.cors.allow-credentials: true
http.cors.allow-headers: "X-Requested-With, Content-Type, Content-Length, Authorization"

To allow connection to the Elasticsearch server from outside the localhost, you need to open an appropriate port in the firewall. The default one is 9200, but it may be different depending on the configuration in the elasticsearch.yml file.

Step 3: Configure the report with your own data

Now it’s time to configure the pivot table on the web page. Let’s create a minimal report for this (replace host and index parameters with your specific values):

 var pivot = new Flexmonster({
  container: "pivotContainer",
  toolbar: true,
  report: {
    "dataSource": {
      "dataSourceType": "elasticsearch",
      /* the host for connection */ 
      "host": "https://olap.flexmonster.com:9200",
      /* the name of Elasticsearch index to connect */ 
      "index": "fm-product-sales"
    }
  },
  licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
}); 

Launch the web page from a browser — there you go! A pivot table is embedded into your project. Check out the example on JSFiddle.

Configure index mapping

In the example above, the fields like @timestamp and @version are displayed in the Field List. They can be hidden by setting the mapping property:

 
var pivot = new Flexmonster({
  container: "pivotContainer",
  toolbar: true,
  report: {
    "dataSource": {
      "dataSourceType": "elasticsearch",
      /* the host for connection */
      "host": "https://olap.flexmonster.com:9200",
      /* the name of Elasticsearch index to connect */
      "index": "fm-product-sales", 
      /* additional setting to configure index mapping */
      "mapping": {
        "@timestamp": {
          "visible": false
        },
        "@version": {
          "visible": false
        },
        "host": {
          "visible": false
        },
        "message": {
          "visible": false
        },
        "path": {
          "visible": false
        }
      }
    }
  },
  licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
}); 

Check out the example on JSFiddle.