Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Session Variable

Accepted answer
22
Views
10
Comments
Rank 4 - Community Specialist

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • Rank 8 - Analytics Strategist
    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"))

Answers

  • Rank 8 - Analytics Strategist

    OTBI Session Variable

    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.

  • Rank 4 - Community Specialist

    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

  • Rank 8 - Analytics Strategist

    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.

  • Rank 4 - Community Specialist

    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

  • Rank 8 - Analytics Strategist

    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!

  • Rank 4 - Community Specialist

    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

  • Rank 8 - Analytics Strategist

    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.

  • Rank 8 - Analytics Strategist

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

    Thank you.

  • Rank 8 - Analytics Strategist

    PFB the screenshot.

Welcome!

It looks like you're new here. Sign in or register to get started.