Investment and Resource data is available in the DWH. However, we do not want to show all the records to all the users in our organization, when reports are built using DWH. How to implement security so that records that are visible to users in PPM, are the only ones shown in DWH based reports?
There are two views available in DWH schema that can be used to implement data security:
USER_KEY in these views are IDs derived from SRM_RESOURCES table in PPM schema.
A sample query is as below.
JOIN dwh_inv_security dis ON dis.investment_key = dii.investment_key
dis.user_key = 5005004;
A prerequisite for the use of this table is that the Load Data Warehouse Access Rights job is scheduled and completes successfully in the system.
Do not use the following views for new development. They are available to support legacy reports only.