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

Does anyone know how to restrict data in BIP report based on user who will run it?

Received Response
21
Views
4
Comments

Summary:

How to restrict data in BIP report based on user who will run it?

Content (required):

Hello I am running report in BIP regarding no performance goal plan. Can you please provide SQL on how to restrict data in BIP report based on user who will run it?

Below is the SQL that I built

WITH

PersonName as

(

SELECT person_id, full_name, last_name, first_name

FROM PER_PERSON_NAMES_F

WHERE trunc(SYSDATE) between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE

and NAME_TYPE = 'GLOBAL'

),


PersonNumber as

(

SELECT PAPF.PERSON_NUMBER, PAPF.PERSON_ID

FROM PER_ALL_PEOPLE_F PAPF

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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