Setting up security roles for Analysis Services with Pyramid
Pyramid's security integration with Analysis Services is tight - allowing customers to securely query OLAP cubes or Tabular models and use any data level security definitions that have been included in the cube/model.
If Pyramid is using its own database as the authentication provider, admins simply provide the active Directory User Principal Name (UPN) for each user connecting to the cube. If, instead, Active Directory is the authentication provider, the user's UPN is automatically used to connect to the cube.
The only requirement for this framework, is that the SSAS server is attached to an Active Directory. Pyramid itself does not need to be.
The video in this post will show most of these elements and its effect.
Hi, I have a question regarding security roles regarding Analysis Services.
We are developing a Tabular model at one of our customers (retail and wholesale). We have connected the model to PA18. Our experience was, that not only the user connecting to the cube has to be server admin on OLAP server, but also has to be Pyramid user. Since this is usually a generic user, this means it is a waste of one licence just for OLAP connection purpose. Why is that?
The user used to connect to your Tabular data source in Admin>data>source does not have to be added to Pyramid as a user. It just has to be in the administrators group as set in SQL Management studio. If when you remove the user from the list of Pyramid users, you cannot connect to the tabular data source, please open a support case and we can investigate this further with you. To open a ticket please browse to https://support.pyramidanalytics.com .