What are the components of OBIEE?

What are the components of OBIEE?

OBIEE Components :

• Oracle BI Server.
• Oracle Presentation Server.
• Application Server.
• Scheduler.
• Cluster Controller.

What is OBIEE system?

OBIEE (Oracle Business Intelligence Enterprise Edition) is a BI tool by Oracle Corporation to gather, store, and analyse the data for enterprise reports, dashboards, scorecards and ad hoc analysis. OBIEE BI tool also provides a rich end-user experience.

What is Obi reporting tool?

Oracle Business Intelligence (OBI) is a suite of reporting and analysis tools in an easy to use interface. It is the most commonly used reporting tool at Stanford, enabling high quality business decisions through an integrated set of reporting and analysis capabilities.

What is aggregate table in OBIEE 11g?

Aggregate fact tables contain foreign keys to shrunken conformed dimensions, as well as aggregated facts created by summing measures from more atomic fact tables.

What is repository in OBIEE?

OBIEE repository contains all metadata of the BI Server and is managed through the administration tool. It is used to store information about the application environment such as − Data Modeling. Aggregate Navigation.

What is ODI tool?

Oracle Data Integrator (ODI) is an Extract, load and transform (ELT) (in contrast with the ETL common approach) tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.

What is ETL tool in Oracle?

Overview. ETL stands for Extract, Transform and Load. ETL involves the movement and transformation of data from your sources to your targets. In the tutorial “Setting up the Oracle Warehouse Builder Project”, you learned how to define Warehouse Builder modules that connect to your source and target schemas.

What are aggregate tables in Obiee?

OBIEE – Aggregates Aggregations are used to implement query performance optimization while running the reports. This eliminates the time taken by query to run the calculations and delivers the results at fast speed. Aggregate tables has less number of rows as compared to a normal table.

How do you make an aggregate table?

To build the aggregate table and metadata script, perform the following steps:

1. Select File > Open > Online.
2. Select Tools > Utilities.
3. In the wizard’s “Select file location” window, click Browse to specify the location and the name of the script you are creating.