asked on February 24, 2017
I'm testing the Flexmonster and I like it very much, however, I can't use my roles that I have on my SSAS to restrict data to different users.
⋅ February 24, 2017
Hello,
We would like to inform you that Flexmonster Pivot Component supports credentials to access the data source.
If you connect to the cube via XMLA you can use roles from SSAS. Just specify roles parameter along with dataSourceType, proxyUrl, catalog and cube. For example, set roles the following way:
dataSource: {
dataSourceType: "microsoft analysis services",
proxyUrl: "http://olap.flexmonster.com/olap/msmdpump.dll",
catalog: "Adventure Works DW Standard Edition",
cube: "Adventure Works",
roles: "admin,manager"
}
If you connect to the cube via Flexmonster Accelerator you can configure username/password protection with different roles and access levels inside Flexmonster. Read more in our documentation.
Please let us know if it works for you.
Regards,
Tanya
⋅ February 24, 2017
Thank you very much.
⋅ February 24, 2017
Hello Videira,
Thank you for details. Could you please share with us code how you are connecting to your cube?
Regards,
Tanya
⋅ February 24, 2017
Hi Tania
For now I use this code. But I want put the component inside a MVC project.
I try in a different PC with and now have a different error
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Welcome to Flexmonster Pivot Table and Charts Component</title>
<link href="../style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="container">
<div class="header">
<div class="headerLogo">
<a href="https://www.flexmonster.com/" target="_blank"><img src="https://www.flexmonster.com/images/email/logo.svg" height="40" border="0" /></a>
</div>
</div>
<!-- 1. Create a DIV container to insert the component -->
<div id="pivotContainer" style="padding-bottom: 30px;"></div>
<!-- 2. Include jquery.min.js file -->
<script type="text/javascript" src="flexmonster/lib/jquery.min.js"></script>
<!-- 2. Include flexmonster.js file -->
<script type="text/javascript" src="flexmonster/flexmonster.js"></script>
<!-- 3. Embed the component using flexmonster.embedPivotComponent() -->
<script type="text/javascript">
var pivot = $("#pivotContainer").flexmonster({
toolbar: true,
report: {
dataSource: {
dataSourceType: "microsoft analysis services",
/* URL to the Data Speed Accelerator */
proxyUrl: "http://localhost/OlapBridge/msmdpump.dll",
/* Catalog name */
catalog: "AdventureWorksDW2014Multidimensional-EE",
/* Cube name */
cube: "Adventure Works"
}
},
licenseKey: "Z723-XAG25T-0V4D4K-4T374R"
});
</script>
<table class="BottomLinks">
<tr>
<td>
<a href="./" target="_blank">Open source folder</a>
</td>
<td>
<a href="https://www.flexmonster.com/doc/" target="_blank">Documentation</a>
</td>
<td>
<a href="https://www.flexmonster.com/technical-support/" target="_blank">Technical support</a>
</td>
<td>
<a href="https://www.flexmonster.com/contact/" target="_blank">Give a feedback</a>
</td>
<tr>
</table>
<br/>
</div>
</body>
</html>
⋅ February 25, 2017
Hi Tanya,
I did some changes on IIS the provide the URL to connect the cube.
I follow this topic http://www.flexmonster.com/question/stream-error-occurred-while-loading-httplocalhost8080olapmsmdpump-dll/.
And now, have again the other error.
I suspect that a problem is on my IIS Configuration. You can send to me the Web.config file that you have on your folder, for a OLAP Virtual directory, to compare with mine.
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>XMLAnalysisError.0xc10e0002</faultcode>
<faultstring>Parser: The syntax for 'GET' is incorrect.</faultstring>
<detail>
<Error ErrorCode="3238920194" Description="Parser: The syntax for 'GET' is incorrect." Source="Unknown" HelpFile=""/>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>
Thanks,
Vid
⋅ February 25, 2017
Hi Tanya,
A quick update.
I check with different browser and the results are:
- Chrome: Not work
- Vivaldi: Not work
- Firefox: Not work
- Internet Explore : Work!!!!!!!!!!!!!! WHY?!?!?!?!?!?!?!?!?
Do you have idea why this happens?
On Chrome console I have these errors
jquery.min.js:4 OPTIONS http://localhost/Olap/msmdpump.dll 500 (Internal Server Error)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
k4.load @ flexmonster.js:9
X0.Wu @ flexmonster.js:9
X0.load @ flexmonster.js:9
P5.connect @ flexmonster.js:9
w.A3 @ flexmonster.js:9
w.cs @ flexmonster.js:9
w.AP @ flexmonster.js:9
w.y3 @ flexmonster.js:9
w.Jx @ flexmonster.js:9
(anonymous) @ flexmonster.js:9
index.html:1 XMLHttpRequest cannot load http://localhost/Olap/msmdpump.dll. Response for preflight has invalid HTTP status code 500
Thanks,
Vid
⋅ February 27, 2017
Hello Videira,
Thank you for your detailed explanation. Different browsers have the different policy for the different dataSources connections. In such case we suggest you using our Flexmonster Accelerator as a tool for connecting to your MSAS cube. It was designed by Flexmonster developers team to provide a better experience using Flexmonster Pivot Component with the OLAP cubes. Our accelerator allows you to rich a better performance and it is much easier to configure. All the necessary information you can find here - http://www.flexmonster.com/doc/getting-started-with-accelerator-ssas/ .
Please let us know if it works for you.
Best regards,
Dmytro.
⋅ February 27, 2017
Hi Dmytro,
I can use the Roles parameter with your accelerator tool. Otherwise is not a possible for me.
I need restrict data by user, when you load the component.
Thanks,
Videira
⋅ February 27, 2017
Hello Videira,
Please have a look at this article - https://www.flexmonster.com/doc/configuring-authentication-process/. It describes how you can use Accelerator for the different users with different credentials.
Please let us know if you have any questions left.
Best regards,
Dmytro.
⋅ March 2, 2017
Hi Dmytro,
I try the Accelarator and it works fine, but I cant use the roles property.
var pivot = $("#pivotContainer").flexmonster({
toolbar: true,
report: {
dataSource: {
dataSourceType: "microsoft analysis services",
/* URL to the Data Speed Accelerator */
//proxyUrl: "http://localhost:10101/OLAP/msmdpump.dll",
proxyUrl: "http://localhost:50005/",
/* Catalog name */
catalog: "AdventureWorksDW2012Multidimensional-EE",
/* Cube name */
cube: "Adventure Works",
roles: "TeamLeader",
binary:true
}
When I used it, I have this error "Request signature is not trusted or invalid."
This is a reason, why would like connect using XMLA.
Thanks,
Vid
⋅ March 2, 2017
Hi Vid,
In my last message, I meant that you can define username/password in flexmonster.config on the server instead of defining roles from the client-side. Please look at Step 3: Configure Accelerator in Configuring username/password protection. I think it's much better for the security of your application.
Thanks,
Dmytro