Skip to main content
A
Anonymous
June 18, 2020

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

  • June 18, 2020
  • 1 reply
  • 0 views
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

A
Anonymous
June 26, 2020
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
Terms & ConditionsAccessibility statement