Oracle Communities

Oracle Analytics and AI

Child Item

How to default a Prompt's selection as user's login name

Hi Experts,

Would like to reach out to you on how to set the default value of a Prompt with user's login name.

Please refer to below screenshot that I have an Analysis created with subject area of "Receiving - Purchase Receipts Real Time", and a Prompt is using the column of "- Purchase Receipt Header Details > Created By".

We want the Receive By default selecting user's login user name: the idea is each end user is mainly retrieving those receiving and returned data handled by themselves. There is a option for end users to retrieve other team members' receiving data (which whether they can literally get the data is depending on Data Access of their user account ultimately).

May I ask how to achieve it?

Thank you very much.

Liwen

Find more posts tagged with

Prompt

OTBI

Fusion SCM Analytics

Accepted answers

All comments

Sumanth V -Oracle

@Liwen Chiu - Please try using the session variable :

VALUEOF(NQ_SESSION.USER)

Example:

Go to Catalog > Dashboard Prompts > New Prompt.

Select the Subject Area related to your dashboard.

Add a Variable Prompt:
- Choose Set Variable > Session Variable
- Specify the session variable name as USER.

Hope this helps.

Additionally, this community is dedicated to FDI/FAW queries. I noticed that you have tagged OTBI as well. For future reference, please use the dedicated community forum for OTBI:

https://community.oracle.com/products/oracleanalytics/categories/otbi

Liwen Chiu

Hi @Sumanth V -Oracle,

Thanks much on your prompt reply.

I tried but not really able to get the "Session Variable" as you mentioned.

Please refer to below screenshot, should I choose "Presentation Variable"?
And which option I should go for the "Default selection" type?

I put the options in the screenshot as well, please kindly advise, thank you very much.

Liwen

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62731#Comment_62731

You can use SQL results and write a simple custom SQL to give you the desired results based on user. Check a similar example on below thread:

OTBI Dashboard prompt default — Cloud Customer Connect

Thanks.

Liwen Chiu

Hi @MandeepGupta,

Thank you for your reply.

I saw that post you provided, but it seems that we are not using the Workforce Management module, so when I tried with a Data Model to execute the SQL, there is nothing returned/available.

I am thus need to look for other advice to achieve it, looking forward to your further guidance, thank you very much.

Liwen.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62739#Comment_62739

Hi @Raghavendra Raghunath-Oracle ,

can you please advise here?

Thanks.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/62739#Comment_62739

Hi Liwen,

I was trying to replicate your issue and it seems working fine for me. Please find below screenshots.

Can you please check if the OTBI report (with exact conditions) is bringing data for you or not?

BIP:

Cheers,

Liwen Chiu

Hi @Bhaskar Konar, @MandeepGupta,

Thank you for your assistance, this is what I got:

Thank you.

Liwen

Raghavendra Raghunath-Oracle

@Liwen Chiu @MandeepGupta @Bhaskar Konar FYI

can you try this

select username from per_users where user_guid = fnd_global.user_guid

Raghu

Liwen Chiu

Hi @Raghavendra Raghunath-Oracle,

Welcome to this scenario! Thank you for joining us.

I tried with the SQL and configure like this below, but it seems that it's still selecting all the users in the list, instead of only having my account selected as default.

Is there anything else I should configure together with your solution of the SQL?

Thank you very much:

Liwen

Raghavendra Raghunath-Oracle

Hi Liwen @Liwen Chiu try this

select username from per_users where person_id = NVL(HRC_SESSION_UTIL.GET_USER_PERSONID, - 1)

Raghu