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

ntroduction

Most of us must have read SET Theory and its concepts during our high-school days, while some of us have a good time with the topic some of us must have struggled. For those who understood the concept well might wonder how the same is applied and used while creating an OTBI Analysis, for those who were not able to understand the same then I hope they would understand the same this time.

We must have seen the use of SET operators like UNION, MINUS in SQL query but it is interesting to know that they can be used in an OTBI Analysis too.

This kind of Analysis is most commonly used when we want to combine the results of One or More Result Sets. The result sets could be from the Same Subject Area or from a different subject area but as long the number of columns and the column data-type are same.

Some classic use case examples of SET operations in OTBI Analysis are:

  1. Tracking Individuals who have not created A Performance Document

The system tracks the Performance Document which are created in the system but there is no way to track the non-creation of the same. In this case if we create an Analysis for all individuals who are eligible for Creating a Performance Document (say ‘Individuals Eligible to Create a Performance Document’) and another analysis for those who have actually created a Performance Document (say ‘Individuals Who Created Performance Documents) then by excluding the Result Set (‘Individuals Who Created Performance Documents’) from the Result Set (‘Individuals Eligible to Create a Performance Document’ we would get the final results ( say ‘Individuals who have not created a Performance Document’)

  1. Identifying Employees who are not enrolled in any Benefit Plans

Similarly, there could be a scenario where only certain employees (based on specific assignment terms/ contracts) would be eligible for Benefits. If we make an Analysis on Benefit Subject Area we can easily fetch all employees who are enrolled in one or another benefits, But if we need a list of all such individuals who are there not enrolled in any benefits plan again the SET operation comes to rescue. In this case if we take the ‘List of All Employees’ as first Result Set and ‘List of All Employees Enrolled in Benefit Plans’ as second Result Set and perform a MINUS operation on the second set from the first set then we will get ‘All Employees who are not enrolled in Any Benefit Plans’

  1. Employees who have neither created a Performance Document nor are enrolled in Benefit Plan

Say suppose we have already created the above two analysis (a and b ) we can use the INTERSECT Set Operator to find all Employees who have neither created a Performance Document nor are enrolled in Benefit Plan.

A tabular representation is as follows:

Operation / Action

Result

Individuals Eligible to Create a Performance Document

MINUS

Individuals who created Performance Document

Individuals who have not created Performance Document

List of All Employees

MINUS

All Employees who are enrolled in Benefit Plan

Employees who are not enrolled in any Benefit Plan

Individuals who have not created Performance Document

INTERSECT

Employees who are not enrolled in any Benefit Plan

Employees who have neither created a Performance Document nor are enrolled in any Benefit Plan

Similarly we can have varied scenarios where we can use different SET Operators on various Result Sets and get desired results , but for now let-us  try to create a simple OTBI analysis and understand how to use the same (SET Operators) in Oracle Fusion Application.

Worked Example

As a first step we would have to login to the application with an User who has major roles related with HCM Application ( For this example we will use ROBERT.JACKMAN)

Next click on the Navigator icon ( on top left hand side of page) and select the ‘Reports and Analytics’ link under ‘Tools

 

Once you click on the page this would take you to ‘Reports and Analytics’ page. Click on the ‘Book’ icon which resembles the BI Catalog

This would take us to the next screen

 

Next select the ‘New’ option

 

And then choose the ‘Analysis’ option from the drop down list

 

As a part of this example we would use the ‘Workforce Management – Worker Assignment Real Time’ subject area

Once we click the subject area the following screen will appear

In this example we will fetch the following columns:

Columns in OTBI Analysis

Folder Name

Attribute Name

Location

Country

Worker

COUNT (DISTINCT “Worker”.”Person Number”

The Analysis would look as:

We could notice that the analysis displays that Total Number of Employees who have a work Location Country as Algeria is 9.

Now lets say we want to use a MINUS SET Operator such that it should not display any data for Algeria.

For this we need to go back to the ‘Criteria’ tab and use the SET (icon) on the right hand side

 

 

Once we click on the icon this would open up a list of Subject Areas which we may choose

 

For this example we would use ‘Workforce Management – Worker Assignment Real Time’ and once done the criteria screen would appear:

 

Now we need to put a filter criteria on the second instance of the Subject Area such that it would only include records for ‘Algeria’

Filter Criteria

Attribute Name

Attribute Value

Column

Country

Operator

Is equal to / is in

Value

Algeria

 

Once we click Ok , we could see that the filter criteria is added to the second subject area. Also, we would notice that we need to select the fields from the second subject area

Next we would add the ‘Location’ and the ‘Person Number’ attribute columns and then using the Edit Formula option change the ‘Person Number’ field to COUNT (DISTINCT ‘Worker’. ‘Person Number’)

 

Next we need to select the MINUS Set Operators but before makes sense to find out all the available set operators

List of Available SET Operators in OTBI Analysis

Operation Name

Symbolic Representation

UNION

UNION ALL

INTERSECT

MINUS

                                      

For selecting the MINUS Operator please click on the select icon ( as shown) and choose Minus from the available options:

Once done we should click on the results and hopefully we would not see any record for Algeria

 

We can see that there is no data returned for ‘Algeria’ as a MINUS set Operation has been performed on the first analysis.

You may even try other operations like UNION, UNION ALL and INTERSECT and check the behavior of the same too.

We would now conclude this article with the hope that it was useful and gave you all an idea about how to use SET Operators while creating OTBI Analysis.

Thanks for your time and have a good day!!


Ashish Harbhajanka

Comments   

0 #1 MENANGBARENG 2021-07-28 11:08
Hey, I think your site might be having browser compatibility issues.
When I look at your blog site in Firefox, it looks fine but when opening in Internet Explorer, it has some overlapping.
I just wanted to give you a quick heads up! Other then that, fantastic blog!


Feel free to surf to my website: MENANGBARENG: https://Ggasoftware.com/
Quote
0 #2 정보이용료현금화 2021-08-01 01:52
Hello friends, its enormous piece of writing on the topic of cultureand entirely defined, keep it up
all the time.
Quote
0 #3 업소알바 2021-08-04 07:13
magnificent points altogether, you just received a new reader.
What might you recommend about your put up that you just made some days ago?
Any certain?
Quote
0 #4 해외안전놀이터 2021-08-04 13:30
As the admin of this website is working, no uncertainty very rapidly it will be famous, due to
its quality contents.
Quote
0 #5 click here 2021-08-05 04:47
This can take a while, but it is one thing that only has to be done when.
Quote
0 #6 업소알바 2021-08-05 10:04
It is in point of fact a great and useful piece of information.
I'm happy that you shared this helpful information with us.

Please keep us up to date like this. Thanks for sharing.
Quote
0 #7 여성알바사이트 2021-08-05 16:09
Hey just wanted to give you a brief heads up and let you know a
few of the pictures aren't loading correctly. I'm not sure why but I think its a linking issue.
I've tried it in two different browsers and both show the same results.
Quote
0 #8 click here 2021-08-05 23:30
This percentage is calculated by dividing the quantity of zeroes on the wheel by the total quantity of slots.
Quote
0 #9 여성알바사이트 2021-08-05 23:37
Hey there! Someone in my Myspace group shared this
website with us so I came to take a look. I'm definitely enjoying the information. I'm book-marking and
will be tweeting this to my followers! Excellent blog and wonderful
design.
Quote
0 #10 노래방알바 2021-08-06 00:39
Its like you read my mind! You appear to know
a lot about this, like you wrote the book in it or something.
I think that you could do with a few pics to drive the message home a bit, but other than that, this is
great blog. An excellent read. I'll certainly
be back.
Quote
0 #11 website 2021-08-06 08:47
No action can also be ruled when a golfer withdraws from a tournament.
Quote
0 #12 maç izle 2021-08-06 14:17
I could not resist commenting. Well written!
Quote
0 #13 안전놀이터주소 2021-08-06 20:58
Hi my family member! I wish to say that this article is amazing, nice written and include approximately all significant infos.
I would like to see more posts like this .
Quote
0 #14 유흥알바사이트 2021-08-07 12:43
Hi mates, how is everything, and what you would like to say regarding this post, in my view its really awesome
in support of me.
Quote
0 #15 업소알바 2021-08-07 14:36
Remarkable! Its truly amazing post, I have got much clear idea regarding from this article.
Quote
0 #16 bahigo giris 2021-08-07 22:20
Hello, its fastidious post about media print, we all be aware of media is
a impressive source of facts.
Quote
0 #17 online casino 2021-08-08 05:35
Its such as you learn my thoughts! You seem to know
a lot approximately this, like you wrote the book in it or something.
I feel that you simply can do with some % to force the
message house a little bit, however other than that, that is magnificent blog.

A great read. I'll definitely be back.
Quote
0 #18 discuss 2021-08-09 08:25
Thanks , I have recently been looking for information approximately this subject for a while
and yours is the best I have came upon so far.
However, what in regards to the bottom line? Are you sure about the source?
Quote
0 #19 discuss 2021-08-09 08:26
Thanks , I have recently been looking for information approximately this subject for a while
and yours is the best I have came upon so far.
However, what in regards to the bottom line? Are you sure about the source?
Quote
0 #20 supertotobet 2021-08-09 09:00
Now I am ready to do my breakfast, later than having my breakfast coming over again to read additional news.
Quote
0 #21 tipobet365 2021-08-10 00:41
I really like looking through a post that will make men and women think.
Also, thank you for permitting me to comment!
Quote
0 #22 Dai Software 2021-10-04 10:50
very interesting, good job and thanks for sharing such a good information.
meal kit delivery business
Quote
0 #23 donate for ukraine 2022-06-08 07:18
Your means of explaining the whole thing in this article is in fact nice, every one can without difficulty understand it, Thanks a lot.

donate for ukraine: https://www.aid4ue.org/about/
Quote
0 #24 imqa.us 2022-06-17 19:01
Jolly factor of message. I simply stumbled upon your place and in rise to power capital to take that I
learn actually enjoyed chronicle your web log posts.
Quote
0 #25 www.prav-news.ru 2022-06-18 02:03
Pretty constituent of mental object. I plainly stumbled upon your situation and in entree
capital letter to exact that I learn really enjoyed business relationship your
web log posts.
Quote
0 #26 www.dalsaram.com 2022-06-18 06:48
You could unquestionably hear your exuberance inside
the make for you write.
Quote
0 #27 다시보기 주소 2022-06-18 09:46
You could by all odds watch your enthusiasm inside the body of work you pen.
Quote
0 #28 www.optiua.info 2022-06-18 10:38
My coder is nerve-racking to convert me to motion to
.meshwork from PHP. I give always disliked the estimation because of the costs.
Quote
0 #29 www.aiwanba.net 2022-06-18 11:59
It’s identical slow to discovery come out whatsoever weigh on web as
compared to books, as I plant this tack of written material at
this net Page.
Quote
0 #30 www.423down.com 2022-06-18 17:25
What emcee are you exploitation? Hindquarters I get under
one's skin your affiliate link up to your Host?
Quote
0 #31 http://urlky.com 2022-06-18 18:22
This is really interesting, You’re a selfsame skilled blogger.
Quote
0 #32 aid ukraine 2022-07-03 03:59
I'm gone to tell my little brother, that he should also
pay a visit this webpage on regular basis to take updated from latest news update.
aid ukraine: https://www.aid4ue.org/about/
Quote
0 #33 donate for ukraine 2022-07-03 04:52
Hey there just wanted to give you a quick heads up and let you
know a few of the images aren't loading properly.

I'm not sure why but I think its a linking issue.
I've tried it in two different web browsers
and both show the same outcome. donate for ukraine: https://www.aid4ue.org/about/
Quote
0 #34 wordpress themes 2022-09-18 13:27
Hi there, i read your blog from time to time and i own a similar one and
i was just wondering if you get a lot of spam feedback?
If so how do you protect against it, any plugin or
anything you can recommend? I get so much lately it's driving me crazy so any assistance is very much appreciated.


wp plugins: http://pump-life.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress themes: http://centerpointenergyarkansas.biz/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #35 wordpress themes 2022-09-18 22:49
It's a pity you don't have a donate button! I'd certainly
donate to this outstanding blog! I guess for now i'll settle for bookmarking and adding your
RSS feed to my Google account. I look forward to fresh updates and will talk about this website with my Facebook group.
Talk soon!

wordpress themes: http://wwwsextantio.it/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress
themes: http://coatescaribbean.biz/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #36 wp themes 2022-09-18 23:38
What's up to every , for the reason that
I am truly eager of reading this web site's post
to be updated on a regular basis. It carries good
information.

wordpress themes: http://dpstraining.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress plugins: http://yodhaba.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #37 Lacy 2022-09-28 08:56
This is why you obtaain a range of depoaits and withdrawals at BetMGM.


Feel ffree tto surf to my web blog - mgm online casino - Lacy: https://www.google.al/url?q=https://zemaox.webbuzzfeed.com/16481753/betmgm-ohio-bonus-code-bookies-2022-assessment-launch,
Quote
0 #38 Niki 2022-09-30 19:19
@USEmbassyPH hi can we inquire my daughter 15 years
old will travel to US and applying for tourist visa. Shes with my mother in law not with
her parents. What are the requirements for her and step by step procedure

my web blog :: EB2 NIW business plan company (Niki: https://local.enquira.co.uk/suggest-listing.php?id=465&ref=https://www.immigrationbusiness-plans.com/eb2-niw-business-plan-company-alaska/)
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

<<  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