Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

We can use images/logos/static-text/header/footer etc in an RTF Template which is attached to a BI Data Model and that gives a professional look to our reports. But you would be delighted that most of these features can be applied to an OTBI Analysis too.

Recently I was trying to build a Birthday Alerts Notification Mailer using OTBI and I did use a Logo and Static Text to give the email a pleasant look.

 

Lets see how I accomplished the same.

 

Creating the OTBI Analysis

I created a simple Analysis using “Workforce Management - Worker Assignment Real Time” Subject Area and chose the Worker Folder to fetch the data attributes required.

The data attribute details are as follows:

         Attribute Name

Data Source

Person Number

"Worker"."Person Number"

Display Name

"Worker"."Employee Display Name"

BirthDay

CONCAT(CONCAT(CAST(DAYOFMONTH("Worker"."Employee Date Of Birth") AS CHAR(2)),'-'),

CASE CAST(MONTHNAME("Worker"."Employee Date Of Birth") AS CHAR)

WHEN '01' THEN 'Jan'

WHEN '02' THEN 'Feb'

WHEN '03' THEN 'Mar'

WHEN '04' THEN 'Apr'

WHEN '05' THEN 'May'

WHEN '06' THEN 'Jun'

WHEN '07' THEN 'Jul'

WHEN '08' THEN 'Aug'

WHEN '09' THEN 'Sep'

WHEN '10' THEN 'Oct'

WHEN '11' THEN 'Nov'

ELSE 'Dec' END

)

Adding an Image

 

Next we need to ensure that we add a Image. For this we would need to click on the “Edit” option (Pencil Icon) on the title page and it would take us to the following screen

 

 

Notice that we have selected the Logo checkbox and then it gives an option of uploading an image. I already had an image saved into my local machine and I have uploaded the same here (Please ensure the file size is less than 50 KB). Once done we can save the analysis and revert to the layout section.

 

Adding Static Text

 

In order to add Static Text to an Analysis one would need to create a new View of “Static Text” type and add to the layout.The static text details are populated and the screen would appear as below:

Viewing the Analysis

 

Once both the Logo Image and the Static Text section has been added , we can save the analysis and try to open the same.The OTBI analysis appears as below:


Ashish Harbhajanka

Comments   

0 #1 maps.google.sk 2022-04-25 15:37
I ɗefinitely ԝanted to write down a quick comment to apρreciate you
fⲟr all the remarkable solutions ʏou are shоwing ɑt this site.
My pаrticularly lօng internet investigation hаѕ finalⅼy been rewarded with reliable details to ԝrite about ԝith my
grеat friends. I would suppose tһat moѕt of us website
visitors aϲtually aгe undoubtedⅼy lucky to exist in а verʏ gߋod place with very many lovely individuals ѡith good plans.
I feel rather grateful to have used yоur website and lߋoк forward
tⲟ ѕօ many moгe cool moments reading һere.
Thanks a lot once again fߋr evеrything.
Quote
0 #2 Betsy 2022-07-23 19:55
Very descriptive article, I liked that bit. Will there be a part 2?


My webpage; star cruise virgo singapore casino (Betsy: http://jinsanbag.com/bbs/board.php?bo_table=free&wr_id=5781)
Quote

Add comment


Security code
Refresh

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

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner