Nowoczesna Firma
English website
UK English version

Oracle BI 11g R1: Build Repositories (D63514GC20)

Tablet Lenovo (7"/8GB/WiFi/Android) gratis*!

Do szkoleń autoryzowanych Oracle 3, 4 lub 5 dniowych w formacie ILT, zamówionych w Database Consulting.
*Promocja ważna do wyczerpania zapasów lub do odwołania i nie łączy się z innymi promocjami ani zniżkami


Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia


Dla kogo

Czas trwania

5 dni

Cena bazowa


  • 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
  • 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
  • Build the Physical
  • Business Model and Mapping
  • and Presentation layers of a repository
  • 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 enhance repositories
  • Enable usage tracking to track queries and database usage
  • and improve query performance
  • Perform a patch merge in a development-to-production scenario


Knowledge on Dimensional modeling


  1. Repository Basics
    • Exploring Oracle BI architecture components
    • Exploring a repository's structure, features, and functions
    • Using the Oracle BI Administration Tool
    • Creating a repository
    • Loading a repository into Oracle BI Server
    • Installing the BI Client software
    • Overview of Exalytics Machine
  2. Building the Physical Layer of a Repository
    • Importing data sources
    • Setting up Connection Pool properties
    • Defining keys and joins
    • Examining physical layer object properties
    • Creating alias tables
    • Printing the physical layer diagram
  3. Building the Business Model and Mapping Layer of a Repository
    • Building a business model
    • Building logical tables, columns, and sources
    • Defining logical joins
    • Building measures
    • Examining business model object properties
    • Printing the business model and mapping layer diagram
  4. Building the Presentation Layer of a Repository
    • Exploring presentation layer objects
    • Creating presentation layer objects
    • Modifying presentation layer objects
    • Examining presentation layer object properties
    • Nesting presentation tables
    • Controlling presentation layer object visibility
  5. Testing and Validating a Repository
    • Checking repository consistency
    • Turning on logging
    • Uploading the repository through Enterprise Manager
    • Executing analyses to test the repository
    • Inspecting the query log
  6. Managing Logical Table Sources
    • Adding multiple logical table sources to a logical table
    • Specifying logical content
  7. Adding Calculations to a Fact
    • Creating new calculation measures based on logical columns
    • Creating new calculation measures based on physical columns
    • Creating new calculation measures using the Calculation Wizard
    • Creating measures using functions
  8. Enabling Usage Tracking
    • Creating the usage tracking tables
    • Setting up the sample usage tracking repository
    • Tracking and storing Oracle BI Server usage at the detailed query level
    • Using usage tracking statistics to optimize query performance and aggregation strategies
  9. Using Model Checker and Aggregates
    • Using Model Check Manager
    • Modeling aggregate tables to improve query performance
    • Using the Aggregate Persistence Wizard
    • Testing aggregate navigation
    • Setting the number of elements in a hierarchy
  10. Using Partitions and Fragments
    • Exploring partition types
    • Modeling partitions in an Oracle BI repository
  11. Modeling Time Series Data
    • Using time comparisons in business analysis
    • Using Oracle BI time series functions to model time series data
  12. Modeling Many-to-Many Relationships
    • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
  13. Setting an Implicit Fact Column
    • Ensuring the correct results for dimension-only queries
    • Selecting a predetermined fact table source
    • Specifying a default join path between dimension tables
  14. Importing Metadata from Multidimensional Data Sources
    • Importing a multidimensional data source into a repository
    • Incorporating horizintal federation into a business model
    • Incorporating vertical federation into a business model
    • Adding Essbase measures to a relational model
    • Displaying data from multidimensional sources in Oracle BI analyses and dashboards
  15. Security
    • Exploring Oracle BI default security settings
    • Creating users and groups
    • Creating application roles
    • Setting up object permissions
    • Setting row-level security (data filters)
    • Setting query limits and timing restrictions
  16. Cache Management
    • Restricting tables as non-cacheable
    • Using Cache Manager
    • Inspecting cache reports
    • Purging cache entries
    • Modifying cache parameters and options
    • Seeding the cache
  17. Exploring the Summary Advisor Tool
    • Setting up Summary Advisor
    • Running the Summary Advisor wizard to create the aggregate script
    • Running the aggregate script to create the aggregates
  18. Using Administration Tool Utilities
    • Using the various Administration Tool utilities
    • Using BI Server XML API to create XML representation of repository metadata
  19. Multiuser Development
    • Setting up a multiuser development environment
    • Developing a repository using multiple developers
    • Tracking development project history
  20. Performing a Patch Merge
    • Comparing repositories
    • Equalizing objects
    • Creating a patch
    • Applying a patch
    • Making merge decisions


    • Knowledge on Dimensional modeling
    • Knowledge on Basic SQL
    • Knowledge on Data warehouse design

Zgłaszanie uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o kontakt telefoniczny pod numerem (22) 398 47 81

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.