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

OTBI Session Variable

Sean-B-01

Mar 5, 2025

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

Hi @Sean-B-01,

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

Pmt-SV.catalog

Uploaded Mar 5, 20251.02 KB

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

Sean-B-01

Mar 5, 2025

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

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

Bhaskar Konar · Mar 5, 2025 7:24PM

Hi @Sean-B-01,

Yes, you are correct.

Ideally it needs to be equated with username most of the cases it is Email Address.

Thank You!

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

Hi @Bhaskar Konar

Just to confirm, the SELECT statement should be for the display name and the WHERE should be equated to a username or email address?

Thank you

Bhaskar Konar · Mar 5, 2025 7:27PM

Hi @Sean-B-01,

Is the prompt working for you?

You can print the Session Variable in a report to see how it is coming.

Thank you.

Bhaskar Konar · Mar 5, 2025 7:28PM

Sean-B-01

Mar 5, 2025

Hi @Bhaskar Konar
Just to confirm, the SELECT statement should be for the display name and the WHERE should be equated to a username or email address?
Thank you

Yes, you are correct @Sean-B-01.

Thank you.

Bhaskar Konar · Mar 5, 2025 7:30PM

PFB the screenshot.

Oracle Transactional Business Intelligence

Welcome!

Quick Links

Categories

OTBI Session Variable

Welcome!

Best Answer

Answers

OTBI Session Variable

Welcome!