Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

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

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?

Security
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    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)


     

    You can choose from UserInReadDataGroup, UserInReadWriteDataGroup and UserInAnyDataSecurityGroup