Hi Everyone,

I am designing a BI project that will use Excel and PowerView in SharePoint for reporting, and I want to implement a security in the cube.

I want the security to be able to hide attributes that are not related to user (e.g. based on department)

For instance, 

Employee Name          Department             Salary

Smith Adams               Finance                   10,6000

Kate Henz    Finance                   20,0000

XXXXXX                     Sales                       15,0000

XXXXXX           Operations               12,9900

XXXXXX                       IT                         12,4000

So in this case, the Employee Name marked XXXXX will not display for someone who does not have access to names of employees in that depar

Hi Lilutchay,

If you go to your BI server, u can setup different roles per cube. (Or you do it in the OLAP cube if u define ur roles there).

Per role/membership u can than decide who can see what dimensions/attributes/cells etc

https://msdn.microsoft.com/en-us/library/ms174799.aspx

Hi lilutchay,

According to your description, you want to hide the members which are not related to the current user. Right?

In Analysis Services, we can only allow/limit the members set of the dimension in role security. In this scenario, we can apply dynamic security based on the current user. Then use STRTOMEMBER() in allow/limit members set. Please refer to links below:

SSAS Dynamic Security

Analysis Services Dynamic Security

However, if we limit the members set in role security, the user can only the see the members related to the user itself. It's not supported to mask other non-related members.

Regards,