How to restrict the PPM contract data based on the roles of the user logged in in OTBI Dashboard
Summary:
We are trying to restrict the data based on the roles available for the user logged in specifically Principal Investigator role (PI role).
Content (required):
Version (include the version you are using, if applicable):
Oracle Cloud Application 22A (11.13.22.01.0)
Code Snippet (add any code snippets that support your topic, if applicable):
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Projects - Cross Subject Area Analysis - Real Time"."- Project Type Attributes"."Project Type Name" s_1,
"Projects - Cross Subject Area Analysis - Real Time"."Award Funding Source"."Funding Source Name" s_2,
"Projects - Cross Subject Area Analysis - Real Time"."Award"."Award End Date" s_3,