Szkolenia Oracle

Cel szkolenia

kod: D95501GC10 | wersja: 12c

This Oracle BI: Build Repositories training is designed for Oracle Business Intelligence implementation team members who need to define and build dimensional models for business intelligence processing. Learn how to build an Oracle Business Intelligence repository and perform administrative tasks.

Learn To:

  • Construct the repository.
  • Import schemas.
  • Design and build logical business models.
  • Expose business models to users in the Oracle BI user interface.
  • Build physical and logical joins, simple measures, and calculation measures.
  • Validate your work by creating and running analyses.
  • Verify query results using the query log.
  • Implement Oracle BI Server security.
  • Manage the Oracle BI Server cache.
  • Set up a multi-user development environment.

Benefits to You:

  • By taking this course, you'll walk away with the ability to extend the initial repository and model more complex business requirements, including: logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. You will have developed the experience to use Administration Tool wizards and utilities to manage, maintain, and enhance repositories. Finally, you'll be exposed to more advanced topics, like implicit fact columns, bridge tables, usage tracking, patch merge, and managing service instances.


  • Administrator
  • Analyst
  • Architect
  • Developer
  • Implementer

Course objectives:

  • Model partitions and fragments to improve application performance and usability
  • Use variables to streamline administrative tasks and modify metadata content dynamically
  • Use time series functions to support historical time comparison analyses
  • Set up security to authenticate users and assign appropriate permissions and privileges
  • Apply cache management techniques to maintain and enhance query performance
  • Set up query logging for testing and debugging
  • Set up a multiuser development environment
  • Use the Administration Tool wizards and utilities to manage, maintain, and enchance repositories
  • Enable usage tracking to track queries and database usage, and improve query performance
  • Perform a patch merge in a development-to-production scenario
  • Use Business Application Archive (BAR) files to move Oracle BI between environments
  • Build the Physical, Business Model and Mapping, and Presentation layers of a repository
  • Build and run analyses to test and validate a repository
  • Build simple and calculated measures for a fact table
  • Create logical dimension hierarchies and level-based measures
  • Check the model and then model aggregate tables to speed query processing

Plan szkolenia Rozwiń listę

  1. Repository Basics
  2. Building the Physical Layer of a Repository
  3. Building the Business Model and Mapping Layer of a Repository
  4. Building the Presentation Layer of a Repository
  5. Testing and Validating a Repository
  6. Managing Logical Table Sources
  7. Adding Calculations to a Fact
  8. Working with Logical Dimensions
  9. Enabling Usage Tracking
  10. Using Model Checker and Aggregates
  11. Using Partitions and Fragments
  12. Using Repository Variables
  13. Modeling Time Series Data
  14. Modeling Many-to-Many Relationships
  15. Setting an Implicit Fact Column
  16. Importing Metadata from Multidimensional Data Sources
  17. Security
  18. Cache Management
  19. Managing Metadata and Working with Service Instances
  20. Using Administration Tool Utilities
  21. Multiuser Development
  22. Performing a Patch Merge
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Poziom trudności
Czas trwania 5 dni

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.


Autoryzowany wykładowca Oracle.

Wszystkie szkolenia Oracle
Szkolenia powiązane tematycznie

Analiza danych

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.


Najbliższe szkolenia Oracle

Harmonogram szkoleń Oracle