Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to restrict the PPM contract data based on the roles of the user logged in in OTBI Dashboard — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to restrict the PPM contract data based on the roles of the user logged in in OTBI Dashboard

Accepted answer
1
Views
4
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!