06-18-2020 08:49 AM - last edited on 06-06-2023 08:09 AM by JackLacava
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?
06-26-2020 11:03 AM
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)