In Oracle Fusion, BI (Business Intelligence) and OTBI (Oracle Transactional Business Intelligence) are tools and capabilities that allow users to create, customize, and run reports to gain insights from their business data. These tools are commonly used in Oracle Fusion Applications to analyze data, make informed decisions, and monitor the performance of various business processes.
Here's an overview of BI and OTBI reports in Oracle Fusion:
BI Reports
1. Oracle Business Intelligence (OBIEE)
Oracle Fusion typically uses Oracle Business Intelligence Enterprise Edition (OBIEE) as the foundation for creating and running BI reports. OBIEE provides a robust and flexible reporting environment.
2. Customization
Users can create custom BI reports by designing data models, creating dashboards, and defining reports to meet specific business needs.
3. Ad Hoc Reporting
BI allows for ad hoc reporting, where users can create their own reports and analyze data without needing IT assistance.
4. Integration
BI reports can integrate data from various sources within Oracle Fusion Applications, including data from Oracle Cloud applications and other data sources.
OTBI Reports
1. Transactional Data
OTBI reports focus on providing insights into transactional data, often related to Oracle Fusion applications such as Oracle HCM Cloud, Oracle Financials Cloud, and others.
2. Prebuilt Subject Areas
OTBI comes with prebuilt subject areas tailored to specific modules (e.g., HR, Finance, Procurement). These subject areas simplify report creation by exposing relevant data structures.
3. Ad Hoc Analysis
Similar to BI reports, OTBI supports ad hoc analysis, allowing users to create and modify reports to suit their needs.
4. Real-Time Data
OTBI reports are often based on real-time data, ensuring that users can access the most current information.
Creating and Running BI/OTBI Reports
To create and run BI/OTBI reports in Oracle Fusion, you typically follow these steps:
1. Access the Reporting Tools
Log in to your Oracle Fusion instance and navigate to the reporting tools, which may include Oracle Business Intelligence and Oracle Transactional Business Intelligence.
2. Select Data Source
Choose the data source or subject area that contains the data you want to analyze. For OTBI, you would typically select a subject area related to the specific module you are interested in.
3. Create or Customize Reports
Use the reporting interface to create new reports or customize existing ones. You can define report layouts, apply filters, add charts and graphs, and perform calculations.
4. Run and Share Reports
Once your report is ready, you can run it to generate the desired insights. You can also schedule reports to run at specific intervals and share them with other users or teams.
5. Export and Analyze
Reports can often be exported to various formats (e.g., PDF, Excel) for further analysis or sharing.
Keep in mind that the specific steps and features may vary depending on the version of Oracle Fusion Applications you are using and the modules you have implemented.
Need Help with BI/OTBI Reports?
Our expert consultants can help you create custom reports and dashboards for your Oracle Fusion applications.
Contact Us Today