Create an Oracle Transactional Business Intelligence Analysis

Oracle Transactional Business Intelligence (OTBI) helps you query your business data and create analyses to answer your business questions.

Here’s how you can create an analysis to find details of an employee:

1. Sign in to OTBI.
2. Under Create, click Analysis.
3. Select a subject area.

   Here are some subject areas that you can use:

   • Compensation - Workforce Compensation Real Time: Provides compensation data.
   • Workforce Management - Areas of Responsibility: Provides the responsibilities of a person.
   • Workforce Management - Person Seniority Real Time: Provides information on person-level seniority dates.
   • Workforce Management – Worker Assignment Real Time: Provides current assignment information for an employee.
   • Workforce Performance - Performance Rating Real Time: Provides information on an employee's performance ratings in a performance document.
   • Workforce Profiles - Person Profile Real Time: Provides person profile details related to educational degrees, competencies, career preferences, membership, certifications, languages, potential, and risk of loss.
4. Add the columns that you want to include in the analysis. Remember to add a column with the Person ID attribute in the analysis.
5. Add the Person ID attribute as a filter of type is prompted.
6. Click the Results tab to see the results of the analysis.
7. Save the analysis in a shared custom folder, for example /shared/Custom/Human Capital Management/TRSM/ folder.