🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Passing user credentials to OLAP cube connection.

Nagaraj Chatiri asked on November 8, 2019

Hello Team, 
We are using OLAP Connection to connect to Cube. We also had SSO (Single Sign On) implemented.
The data should be reflected using user’s access like some user may had access to some specific data Example – product details.
We had implemented this on Cube and getting correct data when using Excel and connecting to Cube. But when we are using it with OLAP Connection, we are not able to pass user’s credentials.
So, how could we pass users credentials to OLAP Connection, so it will recognize the user and provide only accessible details?

3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 11, 2019

Hello, Nagaraj,
Thank you for reaching out to us.
Our team kindly recommend checking out how to configure the authentication process by following the link below:
We hope it helps.
Kind Regards,

Nagaraj Chatiri December 5, 2019

Hi Illia, 
As we are left with limited options as per project needs. we need to proceed with only this option.
Step 3: Configure Flexmonster Accelerator.
CONNECTION_STRING=Data Source=<endpoint_url>;UID=<username>;Password=<password>;
In above the password should be captured and saved dynamically during user creation by SSO. We are not saving password anywhere. Do you have any JSFiddler example to demo the same?

Vera Didenko Vera Didenko Flexmonster December 6, 2019

Hello, Nagaraj,
Thank you for writing to us.
We would like to explain that it is not possible to set the user credentials dynamically using the approach described in step 3 (“Configure Flexmonster Accelerator”). 
For your case, our team kindly suggests trying the customData approach which is discussed in the following thread: https://www.flexmonster.com/question/cube-security-using-customdata-and-ssas/
Via the customData property you can also pass the user credentials. 
Please let us know if such an approach would work for you.
Best Regards,

Please login or Register to Submit Answer