Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
@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:
1 -
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
0 -
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.
1 -
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.
0 -
0
-
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,
1 -
0
-
@Liwen Chiu @MandeepGupta @Bhaskar Konar FYI
can you try this
select username from per_users where user_guid = fnd_global.user_guid
Raghu
2 -
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
1 -
Hi Liwen @Liwen Chiu try this
select username from per_users where person_id = NVL(HRC_SESSION_UTIL.GET_USER_PERSONID, - 1)
Raghu
1
