Flexmonster Software License Agreement (“Agreement”) has been revised and is effective as of January 8, 2025.
The following modifications were made:
The modified version of Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after January 8, 2025, constitutes Licensee’s acceptance of the terms and conditions of the modified version of 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 or maintenance after the effective date of these 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 authentication and data access 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. For more information about role configuration, visit Microsoft documentation on roles and permissions.
After roles are configured in Analysis Services, specify them in the dataSource.roles property when connecting Flexmonster Pivot to SSAS:
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
// To add multiple roles, separate them with a comma
roles: "Sales Manager US"
}
In CORS, the browser sends the OPTIONS
preflight request to check which request methods and headers the server permits. This request does not contain any credentials, so servers using Integrated Windows Authentication may reject the request and prompt for authentication instead.
To prevent this, configure the server to accept the OPTIONS
preflight request without requiring authentication. The Microsoft CORS tutorial provides details on how to allow the OPTIONS
request.
Windows authentication must be enabled on the client side as well. To enable the authentication in Flexmonster, set the dataSource.withCredentials property to true
:
const pivot = new Flexmonster({
container: "pivotContainer",
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.