OTBI Session Variable

Sean-B-01 · Mar 5, 2025 6:11PM

Hello,

I have a dashboard where I'm trying to create an instance of it for when an end user opens it the name column auto populates with their name and only their name so that they can't try and search for someone else. I know the other option would be apply the session variable to the reports within the dashboard.

This is all within PPM, what would the session variable be to just grab the user's name so that it fills in for a prompt such as project manager or where it can be applied to reports so it's only limited to that PM's data?

Thank you,

Sean

Bhaskar Konar · Mar 5, 2025 7:30PM

If you look at the Prompt I used the following:

Values:

SELECT    "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Display Name" s_1 FROM "Workforce Management - Worker Assignment Real Time" WHERE ("Worker"."User Name" =  VALUEOF(NQ_SESSION."USER"))

Default:

SELECT

   "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Display Name" s_1

FROM "Workforce Management - Worker Assignment Real Time"

WHERE

("Worker"."User Name" =  VALUEOF(NQ_SESSION."USER"))

Bhaskar Konar · Mar 5, 2025 7:01PM

https://community.oracle.com/products/oracleanalytics/discussion/24808/otbi-session-variable

Hi @Sean-B-01,

Can you please try the attached Prompt to see if it is near to your requirement?

Pmt-SV.catalog

Hope this help.

Thank you.

Sean-B-01 · Mar 5, 2025 7:10PM

Hey @Bhaskar Konar

Thank you for that! I'm about to Test it out and for projects and wanting to be the only the project manager when they open it, I have it written as:

SELECT "Projects - Cross Subject Area Analysis - Real Time"."Project"."Current Project Manager" s_1
FROM "Projects - Cross Subject Area Analysis - Real Time"
WHERE ("Projects - Cross Subject Area Analysis - Real Time"."Project"."Current Project Manager" = VALUEOF(NQ_SESSION."USER"))

Does this seem correct to you?

Thank you,

Sean

Bhaskar Konar · Mar 5, 2025 7:19PM

https://community.oracle.com/products/oracleanalytics/discussion/comment/64657#Comment_64657

Hi @Sean-B-01,

What value "Projects - Cross Subject Area Analysis - Real Time"."Project"."Current Project Manager" returns? Is it Display Name or Email Address?

Thank you.

Sean-B-01 · Mar 5, 2025 7:22PM

Hi @Bhaskar Konar

"Projects - Cross Subject Area Analysis - Real Time"."Project"."Current Project Manager" returns a display name. Would the SELECT or WHERE need to be altered to be a column that returns a system username or email address?

Thank you