Course code: O1142
Oracle BI Enterprise Edition 11g: Build Repositories training course is designed to give students a step-by-step procedure for building and verifying the three layers of an Oracle BI repository.
Developers Business Analysts DBA’s Data Warehouse AdministratorData Warehouse Analyst
Business Intelligence KnowledgeData Warehouse DesignBasic SQLDatabase DesignDimensional Modeling
iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835
iTrains OBIEE 11g Build Repositories course will use the Oracle BI Administration Tool to construct a simple repository. On completion of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures. Students will also learn how to validate their work by creating and running analyses, and verifying query results using the query log.
This hand on course will also demonstrate how to import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface.
Using the initial repository Students will learn how to model more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data.
This course also covers the Implementation of Oracle BI Server security, management of Oracle BI Server cache, the set up of a multi-user development environment, and the use Administration Tools wizards and utilities used to manage, maintain, and enhance repositories. More advanced topics, such as implicit fact columns, bridge tables, usage tracking, multilingual environments, write back, and patch merge will be discussed.
Physical Layer of a Repository
Business Model and Mapping
Testing and Validating
Logical Table Sources
Adding Calculations to a Fact
Using Partitions and Fragments
Using Repository Variables
Modeling Time Series Data
Modeling Many-to-Many Relationships
Oracle BI Metadata and Data
Setting an Implicit Fact Column
Importing Metadata from Multidimensional Data Sources
Configuring Write Back
Terms and Conditions
© 2019 iTrain. All rights reserved.