OTBI Session Variable

Sean-B-01

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

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

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

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

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

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

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

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

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/64662#Comment_64662

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

Thank you.

Bhaskar Konar

PFB the screenshot.