Oracle Fusion Transaction Business Intelligence (OTBI) in Fusion HCM- Part 1 


Oracle Fusion Transaction Business Intelligence (OTBI) is a real-time, self-service reporting tool available to all Oracle Fusion application users with the appropriate roles, allowing them to create ad hoc analyses to assist in daily decision-making.

  • Oracle Transactional Business Intelligence (OTBI) is seamlessly integrated with Fusion HCM, requiring no additional system or security configuration. OTBI is ready to use as soon as Fusion HCM is provisioned and data is available for reporting. OTBI inherits user roles and security profiles from Fusion HCM. The subject areas you can access to create analyses are determined by your Fusion user role. When you run an OTBI analysis, the data you can see is automatically filtered based on your security profile.   
  • Fusion HCM utilizes trees to manage employee and organizational structures. These trees are flattened and integrated into Oracle Transactional Business Intelligence (OTBI) as reporting hierarchies, allowing for easy data analysis by rolling up or drilling down through various hierarchies such as supervisor, department, position hierarchy, etc.  
  • Oracle Transactional Business Intelligence (OTBI) Supports multiple languages. The reporting interface and metadata can be switched to the user’s preferred local language. Reports or dashboards created in English can be used globally by non-English speaking users.  
  • You can easily integrate an Oracle Transactional Business Intelligence (OTBI) report or dashboard into a Fusion page using Personalization.  

Level up your expertise with our FREE Oracle HCM Technical Training

In upcoming blogs, we will explore the key features of OTBI, the terminologies used, the options available for creating reports, how to embed OTBI reports into Fusion Applications, how to create dashboards using OTBI, and the features of dashboard prompts.  

The Oracle business intelligence semantic layer is constructed using OBIEE and consists of multiple layers. The foundational layer is the Oracle Transactional Database, which is the transactional database. Above this is the Physical Layer, which captures information from the Oracle Transaction Database. The highest layer is the Presentation Layer.  

In a standard Oracle Cloud implementation, customization of the Presentation Layer is impossible. The Presentation Layer contains subject areas, but users cannot customise them. However, in an on-premise implementation, there is a significant possibility for customization, as the BI administration tool can be used to modify the Presentation Layer.  

In Oracle Fusion HCM (V8), there are 39 Subject Areas, each labelled with “Real Time”. Each subject area includes one Fact Folder and several Dimension Folders. Fusion HCM features 181 unique folders, with some folders appearing in multiple subject areas. All subject areas are protected by Fusion Application Security due to their integration with Fusion Applications.  

Fact folders typically appear at the bottom of the folder list and contain measurable attributes such as headcount, salary, and FTE. Each Dimension Folder is linked to the Fact Folder within a Subject Area. 

Stay tuned for Part 2 in our
Oracle Fusion Transaction Business Intelligence in Fusion HCM blog series,
where we’ll delve deeper into preparing you to create reports using OTBI.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *