Introduction
As most of you must know by now that OTBI is one of the most simple yet one of the most effective reporting tool in Oracle HCM Cloud Application. Apart from being a self-service tool which allows drag and drop feature to create your analysis it also takes care of security features. What this means essentially is that individuals running the report would only have access to records that they are entitled to view (based on the roles assigned to the user). Exactly for this reason at times it becomes necessary to display the current logged in username in the Report.
In this article, we would try to add the Logged in Username field for an OTBI Report.
Prerequisite
We would need to have a pre-existing report (say Person Basic Details for this example). The report contains Person Number and Person Name
Displaying Current Logged In User
Now for this report, we would like to display the Current Logged in User as a header. To accommodate this change we would need to make following changes:
-
Include a Session Variable which will hold the current session user detail in the OTBI Analysis
-
Make changes in the associated data model to include this change
-
Edit the RTF Template to map the new field in the layout
Adding Session Variable to the OTBI Analysis
We need to open the Analysis and under criteria add the session variable
Once we add the field, we should ‘Save’ the Analysis.
Adding the User Field on the Data Model
Before we add the field to the data model it would appear as shown below:
We need to click on the ‘Edit Data Set’ option and point to the OTBI Analysis
Once done the Data Model would appear (Notice the new column ‘Column2’ is visible now)
Once done we need to save the Data Model.
Adding the New Field in the RTF Layout
As a last step, we would need to add the new field in the RTF Layout. We would need to add the below fields in the Layout
Item Type |
Item Value |
Text Item |
CURRENT LOGGED IN USER |
Data Field |
VALUEOF (NQ_SESSION.”USER”) |
We need to save this template.
Running the Report
We would now try to run the Report and confirm whether the changes are as expected. We would need to click on the “View Report” Button
And this brings up the below screen
Which now has the Current Logged in User Details displayed?
With this, we have come to the end of the article. Thank You! For your time and have a nice day ahead.
Comments
once again since I book marked it. Money and freedom iss the grearest way to change, may you
be rich and continue to help others.
Technology news homepage: http://americawithlove.com/community/profile/marciathornhill/ technology
news
I'm trying to figure out if its a problem on my end or if it's the blog.
Any feedback would be greatly appreciated.
Here is my blog post - 2022 pdf calendar: http://gamerforever.winepricexchange.com/__media__/js/netsoltrademark.php?d=organicgirl.com%2F__media__%2Fjs%2Fnetsoltrademark.php%3Fd%3Dwww.pinterest.com%252F7calendar%252F
thanks.
I love all the points you've made.
website, thanks admin of this site.
download it from somewhere? A design like yours with a few simple adjustements
would really make my blog jump out. Please let me know where you got your theme.
Many thanks
Review my blog :: 7
week calendar: http://www.mercatalaplanxa.com/__media__/js/netsoltrademark.php?d=stats.freelancerserver.de%2Fredirect.php%3Furl%3Dhttps%3A%2F%2Fwww.pinterest.com%2F7calendar%2F
at thіѕ web site, and piece ߋf writing іs truly fruitful fоr me, kеep սp
posting ѕuch posts.
Ꮇy page ... Calendar: https://alimero.ru/redirect/aHR0cDovL3dpa2kueG4tLTgwYWhscmpxbTZhemMueG4tLXAxYWkvaW5kZXgucGhwL1VzZXI6VHJhY2kwOUc3NTcy
Feel free to visit my web site ... 2022 monthly planner: http://americancapitaldiesel.org/__media__/js/netsoltrademark.php?d=olbaid.ru%2Fgo%3Fhttps%3A%2F%2Fwww.pinterest.com%2F7calendar%2F
I mean,what you say is important and all. But think of if you added some
great photos or viideos to give your posts more, "pop"!
Your content is excellent but with imagges
and vvideo clips, this websit could certainly
be one of the very best in its niche. Great blog!
my page - Nose job price: http://Sergiubaluta.com/site/redirect.php?url=https://people.sap.com/corrilcxzu
write. The sector hopes for even more passionate writers such as you who aren't afraid to say how they believe.
At all times go after your heart.
There's a lot of people that I think would really enjoy your content.
Please let me know. Cheers
Reading through this post reminds mе of my old гoom mate!
He always kеpt talking abоut thiѕ. І will forward this post to him.
Pretty sure he wiⅼl have a good reaɗ. Many tһanks for
sharing!
Here is my blog post - printable calendar: http://www.paletservice.com/component/k2/item/4-excepteur-sint-occaecat-cup
afterward i suggest him/her to visit this web site, Keep up the nice job.
checkbox and now each time a comment is added I get four emails with the same comment.
Is there any way you can remove me from that service? Appreciate it!
Here is my web page ... march calendar: https://linktr.ee/7.calendar
views of all mates about this piece of writing,
while I am also eager of getting knowledge.
long as I provide credit and sources back to your website?
My blog is in the exact same niche as yours and my visitors would definitely benefit from a lot of the information you present here.
Please let me know if this okay with you. Many thanks!
Visit my website; january calendar: https://linktr.ee/7.calendar
It waѕ helpful. Keep on pⲟsting!
Here is myy web ѕite; calendário de abril: http://schoolemployeediscounts.com/__media__/js/netsoltrademark.php?d=sagiptahanan.org%2Findex.php%3Faction%3Dprofile%3Bu%3D29522
to your won ѡebpage.
Here is my homepage cɑlendário 2023: http://www.saveourearthnow.net/__media__/js/netsoltrademark.php?d=edelstahlrohrtechnik.de%2Findex.php%2Fcomponent%2Fk2%2Fitem%2F11-dance-till-your-feet-stick-on-the-air
Fusion E-Learning
Also vіsit myy blog; modelo de calendário: http://southernbushmotorsports.com/__media__/js/netsoltrademark.php?d=edim-doma24.ru%2Fuser%2FElidaMcCarthy4%2F
I have a blog based on the same information you discuss andd would
love to have you share some stories/informa tion. I know my readers would value your work.
If you are even remotely interested, feel free to shoot me an email.
Feel free tto visit my blog; kamagra acquisto: https://kamagra22it.quest/
Im really impressed by it.
Hey there, You've performed a fantastic job.
I will certainly digg it and individually recommend to my friends.
I'm confident they'll be benefited from this web site.
Feel free to surf to my web blog :: p3747070: https://www.tapatalk.com/groups/renotalkfr/viewtopic.php?p=3747070
Look into my page: January calendar: https://www.goalplannerplus.com/
soon it will be famous, due to its quality contents.
My web page :: монтаж кухни: https://vc.ru/claim/313477-hoff-poteryal-kuhnyu?comment=3454517
and I'm impressed! Very useful information specifically the last part :
) I care for such information a lot. I was looking for this certain info for a very long time.
Thank you and good luck.
Visit my webpage - free
pdf calendar: https://www.fitday.com/fitness/forums/members/7-calendar.html
Look adѵanced to more added agreeable from you!
By thе way, how could ᴡe communicаte?
Also visit my site; yearly ϲalendar free: https://pbase.com/7calendar/2022_calendar
didn't know who to ask.
Here is my web blog ... Printable Monthly calendar (Www.ceqoya.Com: https://www.ceqoya.com/websites-printable_calendars_7calendar.html)
blogging. You have touched some good things here. Any way
keep up wrinting.
web page conations really pleasant funny material too.
My web blog ... january
calendar: https://Tenniscenter.by/forums/users/makayladonald0/
zynga group? There's a lot of folks that I think would really enjoy your content.
Please let me know. Cheers
Im really impressed by your site.
Hello there, You have done an excellent job.
I will certainly digg it and in my view suggest to my friends.
I'm sure they'll be benefited from this web site.
RSS feed for comments to this post