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

Introduction

In this article we would try to create a very simple OTBI Analysis and make use of LEGEND view feature. But before we proceed further let-us try to understand what is meant by a LEGEND.

The literal meaning of LEGEND stands as:

Concise explanation of the symbols used in a chart, diagram, drawing, map, table, etc.”

So now I hope you guys could make out what is meant by a Legend. Not yet

Ok let me try to explain. In a typical image/chart or diagram we often use texts which explains the data elements displayed in the analysis.

We would try to understand the same better in the example below.

Worked Out Example

In order to incorporate a LEGEND view or for that matter any other view (Graph, Gauge, Tunnel , Map, Narrative, Static Text… etc) we would need to build a simple analysis.

For this example we would create an analysis which would display the Business Unit wise absence count for the year 2016 and 2017.

We would make use of “Workforce Management – Absence Real Time” subject area and choose Business Unit Name and “# of Absences” (fact dimension) for this purpose and also apply a filter criteria on Calendar Year to ensure it only fetches data for the current year (2017) and previous year (2016).

On top of this analysis we would also apply Conditional Formatting feature on “# of Absences” such that

  1. If the Absence Count is <= 150 then the background colour would be Green

  2. If the Absence Count is between 151 and 300 then the background colour would be Yellow

  3. If the Absence Count is greater than 300 then the background colour would be Red

From an end user perspective, the coloring denotes that those Business Units which are having the Absence Counts less than 150 are under acceptable range, ones between 151 to 300 needs to be closely monitored while the ones with Absence Count greater than 300 are unacceptable and an immediate action is required.

Once we put all the things in perspective the OTBI Analysis would appear as below:

 

Adding a Legend View

In order to Add a Legend View we would have to go to the Views Section (Bottom left hand side on the Results page) and follow below navigation:

Views -> New View -> Other Views -> Legend

 

Once added we need to define the Caption and Text for each entry. For this example, we populate the same with below details (visible on screenshot below)

 

Once we add the same and rearrange the analysis the final output would appear as below:

 

Summary

I hope you guys learned how to add Legend View to an OTBI Analysis from the above example and would be able to create your own new analysis and make a simple yet self-explanatory report which could be readily used by end user. Do try it out at your end and feel free to revert in case you face any challenges.

That’s all from my side. Thanks for your time , Have a nice day.


Ashish Harbhajanka

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

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner