If Flexmonster is not yet embedded, set up an empty component in your web page:
Complete the Quick start guide. Your code should look similar to the following example:
var pivot = new Flexmonster({
container: "pivotContainer",
toolbar: true
});
Complete the Integration with Angular guide. Your code should look similar to the following example:
<fm-pivot
[toolbar]="true">
</fm-pivot>
Complete the Integration with React guide. Your code should look similar to the following example:
<FlexmonsterReact.Pivot
toolbar={true}
/>
Complete the Integration with Vue guide. Your code should look similar to the following example:
<Pivot
ref="pivot"
toolbar>
</Pivot>
The package contains the following files:
flexmonster-proxy-ssas.exe
– a server-side utility that handles the connection between Microsoft Analysis Services and Flexmonster Pivotflexmonster.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. 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).
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.
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):
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
}
}
});
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.
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