We need to build review CVs based on entities users are responsible for

OSAdmin
Valued Contributor
Originally posted by Michael Malandra

8/15/2017

Member list driven by security - we need to build review CVs based on entities users are responsible for, i.e. John Doe is responsible for 3 entities that do not have a common parent. He needs a report with his entities by total revenue without selecting the entities. Does anyone have the BR to do this?

1 REPLY 1

OSAdmin
Valued Contributor
Originally posted by Nick Kroppe

You will be able to leverage the entity security in your member formulas of your report. In the member filter of the cube view row or column, use the where clause to filter on a specific entity security setting. In the member filter example I have here, the report will only return entities that the user has read/write access to.

E#

[TotalGolfStream].Descendants.Where(UserInReadWriteDataGroup = True)


1bc84b47db611c108feee3a84b9619b6.png

 

You can choose from UserInReadDataGroup, UserInReadWriteDataGroup and UserInAnyDataSecurityGroup