We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Filtering dimesnsions and authentication

Thread ID:





132514 Sep 6,2017 08:30 AM UTC Sep 7,2017 12:17 PM UTC JavaScript 1
Tags: ejPivotGrid
Asked On September 6, 2017 08:30 AM UTC

Hi All,

We have a multi-tenant OLAP database and use Client's login name to filter dimension attributes (using the standard method straight out of SSMS).
I could not find if this can be achieved with ejPivotGrid, i.e. I did not find any documentation regarding authentication connection to Microsoft Analysis Services.
Would someone please direct me to a resource or am I on a completely wrong path thinking that it would be part of ejPivotGrid component?
I'm a DBA with basic JS understanding.


Sastha Prathap Selvamoorthy [Syncfusion]
Replied On September 7, 2017 12:17 PM UTC

Hi Ed, 
Thanks for contacting Syncfusion support. 
We think that your requirement is related to restrict the dimension attributes from the cube. If so, you can use the parameter “Roles” in the connectionString to use the user level restriction on cube level. Please find the following link that provides detailed information about Roles and permission on cube level.  
You can apply Role-based filtering to OLAP components by specifying the appropriate role name designed for specific set of users in the SSAS Cube. You must specify the role name in the “Roles” attribute of the connection string. The following code example illustrates this. 
Sample Code snippet: 
string connectionString = @"Data Source=http:// bi.domainname.com/olap/msmdpump.dll; Roles=UserRolesName; Initial Catalog=Adventure Works DW 2008 SE;"; 
If the above provided information doesn’t meet your requirement. Please provide us detailed information, that would be more helpful to assist you further. 
Sastha Prathap S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon