Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Install the Accelerator using the console application

Requirements

  • Flexmonster Pivot version 2.2 or higher
  • Microsoft Analysis Services installed and configured
  • Microsoft .NET Framework 4.5.2 or higher

Step 1: Embed the component into your web page

If Flexmonster is not yet embedded, set up an empty component in your web page:

In pure JavaScript

Complete the Quick start guide. Your code should look similar to the following example:

var pivot = new Flexmonster({
    container: "pivotContainer",
    toolbar: true
});

In Angular

Complete the Integration with Angular guide. Your code should look similar to the following example:

<fm-pivot 
[toolbar]="true">
</fm-pivot>

In React

Complete the Integration with React guide. Your code should look similar to the following example:

<FlexmonsterReact.Pivot
toolbar={true}
/>

In Vue

Complete the Integration with Vue guide. Your code should look similar to the following example:

<Pivot
ref="pivot"
toolbar>
</Pivot>

Step 2: Configure Flexmonster Accelerator on the server

The package contains the following files:

  • flexmonster-proxy-ssas.exe – a server-side utility that handles the connection between Microsoft Analysis Services and Flexmonster Pivot
  • flexmonster.config – a file that contains configuration parameters for the utility (connection string, port, etc.)

The flexmonster.config file contains the following parameters:

  • CONNECTION_STRING – (required) the connection string for Microsoft Analysis Services. Example: Data Source=localhost;.
  • PORT – (optional) the port number for the proxy service endpoint. Default value: 50005.
  • CACHE_MEMORY_LIMIT – (optional) the maximum memory size available for caching (in MB). Default value: 0 (unlimited).
  • CACHE_ENABLED – (optional) indicates whether caching is enabled.
    Available since version 2.211. Default value: true.
  • GZIP – (optional) indicates whether server response compression is enabled. Available since version 2.409. Default value: true.
  • HTTPS – (optional) indicates whether the HTTPS protocol is enabled. Default value: false.
  • WINDOWS_AUTH – (optional) indicates whether Windows authorization is enabled. Default value: false.
  • ALLOW_ORIGIN – (optional) the origin from which the server accepts the requests. If ALLOW_ORIGIN is set to *, requests from all origins are accepted. Note that if authorization is enabled (WINDOWS_AUTH=true), * cannot be set as the origin. In this case, specific origins must be defined. Several origins can be defined as follows: ALLOW_ORIGIN = http://localhost, https://example.com. Default value: *.

After configuring all the necessary options, the Accelerator is ready to be launched. Just run the flexmonster-proxy-ssas.exe with administrator privileges.

You can check whether the Accelerator is up and running by navigating to its URL in the browser (by default: http://localhost:50005).

Step 3: Open a port for the Accelerator in the firewall

If you plan to allow connections to the Accelerator from outside the server, open the appropriate port in the firewall. The default port number is 50005, but it can be changed using the PORT parameter in the flexmonster.config file.

Step 4: Configure the component

Now it’s time to configure the client – Flexmonster Pivot Table and Charts. Let’s create a minimal configuration using the JavaScript API (replace proxyUrl, catalog and cube parameters with your specific values):

Connect to a multidimensional model

var pivot = new Flexmonster({
container: "pivotContainer",
toolbar: true,
report: {
dataSource: {
type: "microsoft analysis services",

/* URL to Flexmonster Accelerator */
proxyUrl: "http://localhost:50005",

/* Catalog name */
catalog: "Adventure Works DW Standard Edition",

/* Cube name */
cube: "Adventure Works",

// Flag to use the Accelerator instead of XMLA protocol binary
binary: true
}
}
});

Connect to a tabular model

var pivot = new Flexmonster({
container: "pivotContainer",
toolbar: true,
report: {
dataSource: {
type: "microsoft analysis services",

/* URL to Flexmonster Accelerator */
proxyUrl: "http://localhost:50005",

/* Database name */
catalog: "Adventure Works DW Standard Edition",

/* Model name */
cube: "Adventure Works",

// Flag to use the Accelerator instead of XMLA protocol binary
binary: true
}
}
});

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

Cache control

Usually a cache can improve performance greatly. However if the underlying database ever changes, the cache goes out of date. By default, caching is enabled and controlled by the Accelerator.

It is also possible to disable the cache with the CACHE_ENABLED parameter in the flexmonster.config (available since version 2.211):

CACHE_ENABLED = false