Filtering dimesnsions and authentication

[Ed]

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.

Thanks!

[Sastha Prathap Selvamoorthy]

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.  

  

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/roles-and-permissions-analysis-services 

https://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services 

 

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. 

 

Regards, 

Sastha Prathap S.