Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Oracle Fusion HCM
  • 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

Oracle Fusion Transaction Business intelligence (OTBI) is a real time, self-service reporting solution offered to all Oracle Fusion application users with valid roles to create ad hoc analysis and analysis to help them make their decisions on a daily basis. 

2015-05-09 23-37-25

  • Oracle Transactional Business Intelligence (OTBI) is fully integrated with Fusion HCM and requires no additional system or security configuration. Oracle Transactional Business Intelligence (OTBI) is ready for use once Fusion HCM is provisioned and data is available for reporting. Oracle Transactional Business Intelligence (OTBI) inherits Fusion HCM user roles and security profiles. What OTBI subject areas you can access to create analyses is determined by your Fusion user role. When you run an OTBI analysis, what data you can see is automatically filtered based on your security profile. 
  • Fusion HCM uses trees to manage employee and organizational structure. Trees are flattened and propagated to Oracle Transactional Business Intelligence (OTBI) as reporting hierarchies so you can easily analyze data by rolling up or drilling the various hierarchies i.e. supervisor, department or position hierarchy, etc.
  • Oracle Transactional Business Intelligence (OTBI) supports multi-language translation. The reporting user interface and metadata can switch to your chosen local language. The same report or dashboard built in English can be deployed globally to non-English users.
  • You can easily embed an Oracle Transactional Business Intelligence (OTBI) report or dashboard in a Fusion page through Personalization.

In the next few blogs, we will be looking into the key features associated with OTBI, the various terminologies that are used in OTBI, the various options that are involved in creation of Reports using OTBI, embedding OTBI reports into Fusion Applications, creating dashboards using OTBI and how to create dashboard prompts and the various features that the dashboard prompts.
Oracle business intelligence semantic layer that is built using OBIEE. It means that there are multiple layers to form it. The bottom-most layer would be the Oracle Transactional Database, which is the transactional database. On top of it the Physical Layer, captures information from the Oracle Transaction Database. On top of it is the final Layer call the Presentatiion Layer.
In a typical Oracle Cloud Implementation, no customization is possible on the Presentation Layer. Within the Presentation Layer, you have subject areas. There is no way that a user can go ahead and make customizations to the Presentation Layer. However, in an On-premise Implementation, there is a very high possibility and there is an option of having the BI administration tool which caters to the customization of Presentation Layer.
In Oracle Fusion HCM (V8), there are 39 Subject Areas. OTBI Subject Areas are always suffixed with "Real Time". Each subject area has one Fact Folder and a number of Dimension Folders. Fusion HCM has 181 distinct folders. Some folders appear in more than one subject area, All subject ares are secured by Fusion Application Security because it is integrated with Fusion Applications.
Fact folders are usually at the bottom of the list of folders. A fact folder contains attributes that can be measured, meaning that they are numeric values like headcount, salary, FTE. Each Dimension Folder is joined to the Fact Folder within a Subject Area. 

The next article will cover the demo on high level on  the topic - how to create reports using OTBI.. To learn more in depth on Business Intellegence, please click the following link

http://apps2fusion.com/oracle-training/101-fusion-middleware-training/719-oracle-business-intelligence-applications-obia-training 


.


Jayashree Prakash

Comments   

0 #1 เว็บวาไรตี้ 2022-02-10 14:23
I go to see every day some web pages and sites to read posts, however this web site gives feature based writing.


Also visit my web blog ... เว็บวาไรตี้: https://lazi.vn/user/auro.ealis
Quote
0 #2 ความรู้ 2022-02-11 12:28
I'm amazed, I have to admit. Rarely do I come across a blog that's equally educative and amusing,
and let me tell you, you have hit the nail on the head.
The problem is an issue that too few people are speaking intelligently about.
Now i'm very happy that I came across this in my hunt
for something concerning this.

Also visit my page; ความรู้: https://www.suanprung.go.th/sahakorn_board/index.php?action=profile;area=summary;u=1520
Quote
0 #3 appear power bank 2022-05-12 18:31
Hi, ɑfter reading this amazing post i аm
also glad to share my ҝnoᴡ-h᧐w hеre with mates.
Quote
0 #4 http://euroopera.org 2022-08-06 22:19
I really like reading an article that will make people think.
Also, many thanks for permitting me to comment!
Quote
0 #5 learn more 2022-08-15 16:34
Great beat ! I wish to apprentice while you amend
your web site, how could i subscribe for a blog website?

The account aided me a acceptable deal. I had been tiny bit acquainted of this
your broadcast offered bright clear idea
Quote

Add comment


Security code
Refresh

About the Author

Jayashree Prakash

Jayashree Prakash

Jayashree is a Oracle Fusion HCM certified consultant who has over fifteen years' experience with Oracle. She has worked as a consultant with several of Alberta's energy companies. She lives in Edmonton and her interests include staying active in the warmer months and vacationing in the Caribbean in the winter

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

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner