Oracle BI 12c: Build Repositories

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Dec 12, 202209:0005:00ESTToronto - In Class or by Video Conference5$5,000 USDPurchase
Feb 6, 202309:0005:00ESTToronto - In Class or by Video Conference5$5,000 USDPurchase
Apr 10, 202309:0005:00EDTToronto - In Class or by Video Conference5$5,000 USDPurchase
Jun 5, 202309:0005:00EDTToronto - In Class or by Video Conference5$5,000 USDPurchase
Aug 14, 202309:0005:00EDTToronto - In Class or by Video Conference5$5,000 USDPurchase
Oct 2, 202311:0007:00EDTToronto - In Class or by Video Conference5$5,000 USDPurchase
Dec 4, 202309:0005:00ESTToronto - In Class or by Video Conference5$5,000 USDPurchase


O12CBI: BLDREP

Oracle BI 12c: Build Repositories

This Oracle BI 12c: Build Repositories training teaches you how to build and verify the three layers of an Oracle Business Intelligence (BI) repository, step-by-step. Learn how to use the Oracle BI Administration Tool to construct a simple repository.

Duration: 5 Days

Audience

  • Application Developers
  • Business Analysts
  • Business Intelligence Developers
  • Data Modelers
  • Data Warehouse Administrators
  • Data Warehouse Developers
  • Reports Developers
  • Technical Consultants

Learning 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 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
  • 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

Topics

  • Repository Basics
  • Building the Physical Layer of a Repository
  • Building the Business Model and Mapping Layer of a Repository
  • Building the Presentation Layer of a Repository
  • Testing and Validating a Repository
  • Managing Logical Table Sources
  • Adding Calculations to a Fact
  • Working with Logical Dimensions
  • Enabling Usage Tracking
  • Using Model Checker and Aggregates
  • Using Partitions and Fragments
  • Using Repository Variables
  • Modeling Time Series Data
  • Modeling Many-to-Many Relationships
  • Setting an Implicit Fact Column
  • Importing Metadata from Multidimensional Data Sources
  • Security
  • Cache Management
  • Managing Metadata and Working with Service Instances
  • Using Administration Tool Utilities
  • Multiuser Development
  • Performing a Patch Merge
Right Menu IconMENU