Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

  • Register

Search Courses

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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 as shown below:

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:

  1. Include a Session Variable which will hold the current session user detail in the OTBI Analysis

  2. Make changes in the associated data model to include this change

  3. 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 as shown:

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 is would appear as shown below:

We need to click on the ‘Edit Data Set’ option and point to the OTBI Analysis as shown:

Once done the Data Model would appear as below (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”)

The Modified template would look as:

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.


Ashish Harbhajanka

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

More articles from this author

Overall Rating (0)

0 out of 5 stars
  • No comments found

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2017  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  9101112
    

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner