Categories
- All Categories
- 1 Oracle Analytics Lounge
- 13 Oracle Analytics Technical
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI Session Variable
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
Best Answer
-
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"))0
Answers
-
Hi @Sean-B-01,
Can you please try the attached Prompt to see if it is near to your requirement?
Hope this help.
Thank you.
0 -
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
0 -
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.
0 -
"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
0 -
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!
0 -
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
0 -
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.
0 -
Yes, you are correct @Sean-B-01.
Thank you.
0 -
PFB the screenshot.
0