Menu
Download Free Trial

Configuring SSAS roles

Answered

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.

11 answers

Public
Tanya Gryshko Flexmonster 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

Public
Videira February 24, 2017

Thank you very much.

Public
Tanya Gryshko Flexmonster 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

Public
Videira 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 

  1. <soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/>
    1. <soap:Body>
      1. <soap:Fault xmlns=”http://schemas.xmlsoap.org/soap/envelope/>
        1. <faultcode>XMLAnalysisError.0xc10e0002</faultcode>
        2. <faultstring>Parser: The syntax for ‘OPTIONS’ is incorrect.</faultstring>
        3. <detail></detail>
        4. </soap:Fault>
      2. </soap:Body>
    2. </soap:Envelope>

 
 
 

<!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="http://www.flexmonster.com/" target="_blank"><img src="http://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="http://www.flexmonster.com/doc/" target="_blank">Documentation</a>
</td>
<td>
<a href="http://www.flexmonster.com/forum/" target="_blank">Technical support</a>
</td>
<td>
<a href="http://www.flexmonster.com/feedback/" target="_blank">Give a feedback</a>
</td>
<tr>
</table>
<br/>
</div>
</body>
</html>

 

Public
Videira 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

Public
Videira 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

Public
Dmytro Zvazhii Flexmonster 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.

Public
Videira 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
 

Public
Dmytro Zvazhii Flexmonster February 27, 2017

Hello Videira,
Please have a look at this article – http://www.flexmonster.com/doc/configuring-usernamepassword-protection/. 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.

Public
Videira 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
 
 

Public
Dmytro Zvazhii Flexmonster 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

Please login or Register to Submit Answer