Hi Mattis
Have a look at
Implement Row Level Security for BI Reports section in our documentation. That exactly explains the way you want to populate
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
------------------------------
Original Message:
Sent: 05-18-2020 03:04 PM
From: Mattis Kristoffersson
Subject: DWH_RES_SECURITY & Staff in Activities/Projects
Hi guys,
So I have stumbled across a problem regarding the DWH_RES_SECURITY_V table. We have implemented a Power BI report solution and in it we have RLS security activated using both the DWH_INV_SECURITY_V table and the DWH_RES_SECURITY table. Since we are using both tables to filter values for resources in projects we are unable to view values for resources that does not belong to a Resource Manager in the Investment tables (INV_TEAM PERIOD_FACT) when logging on as a Investment Owner that does not have the role of a Resource Manager.
Is there anyone that knows if it is possible to populate the DWH_RES_SECURITY table with staff (RESOURCE_KEY) from an (or serveral) investments and link that staff to the USER_KEY in the DWH_RES_SECURITY table.
Grateful for answers!