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,