Flexmonster Software License Agreement (“Agreement”) has been significantly revised and is effective as of September 30, 2024.
The following modifications were made:
The modified version of Flexmonster Software License Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after September 30, 2024, constitutes Licensee’s acceptance of the terms and conditions of the modified version of Flexmonster Software License Agreement. If Licensee does not agree to any of these terms and conditions, they must cease using Flexmonster Software and must not download, install, use, access, or continue to access Flexmonster Software. By continuing to use Flexmonster Software or renewing the license under License Model or Maintenance after the effective date of any modifications to Agreement, Licensee accepts and agrees to be bound by the terms and conditions of the modified Agreement.
This tutorial explains how to manage the authentication process when working with SQL Server Analysis Services (SSAS) via XMLA. We support two different approaches:
Note If you do not have XMLA configured (msmdpump.dll
), we recommend using Flexmonster Accelerator — a special server-side utility developed by Flexmonster.
In SQL Server Analysis Services, access rights are provided based on roles. More information about role configuration can be found in this tutorial from Microsoft.
After roles are configured in Analysis Services, they can be specified in Flexmonster reports by using the roles
property. The following sample demonstrates how to specify roles
:
dataSource: { type: "microsoft analysis services", /* URL to msmdpump.dll */ proxyUrl: "http://localhost/OLAP/msmdpump.dll", catalog: "Adventure Works DW Standard Edition", cube: "Adventure Works", /* roles from SSAS, you can add multiple roles separated by comma */ roles: "Sales Manager US" }
To configure Windows authentication for the XMLA connection, do the following:
In CORS, the browser sends the OPTIONS
preflight request to the server. This request determines which request methods and headers the server allows.
The OPTIONS
preflight request cannot contain any credentials, so Windows Integrated Authentication will reject this request and ask for authentication. Thus, the server should always accept the preflight request. To allow the OPTIONS
request, see the following guide: CORS tutorial.
Windows authentication should be allowed on the client side as well. To enable the authentication on the client, set the withCredentials
property of the DataSourceObject to true:
var pivot = new Flexmonster({ container: "pivotContainer", componentFolder: "node_modules/flexmonster/", toolbar: true, report: { dataSource: { type: "microsoft analysis services", proxyUrl: "http://localhost/OLAP/msmdpump.dll", catalog: "Adventure Works DW Standard Edition", cube: "Adventure Works", withCredentials: true } } });
After applying the configurations, the requests to Microsoft Analysis Services will be performed using your current Windows user.
You may be interested in the following articles: