Clarity

 View Only
  • 1.  DWH_RES_SECURITY & Staff in Activities/Projects

    Posted May 18, 2020 03:04 PM
    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!


  • 2.  RE: DWH_RES_SECURITY & Staff in Activities/Projects
    Best Answer

    Broadcom Employee
    Posted May 19, 2020 01:02 AM
    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
    ------------------------------