Oracle BI 12c: Build Repositories

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Aug 22, 202209:0005:00EDTToronto - In Class or by Video Conference5$5,000 USDPurchase
Oct 3, 202209:0005:00EDTToronto - In Class or by Video Conference5$5,000 USDPurchase
Dec 5, 202211:0007:00ESTToronto - In Class or by Video Conference5$5,000 USDPurchase


Oracle BI 12c: Build Repositories

Description: 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. Expert Oracle University instructors will begin by teaching you how to use the Oracle BI Administration Tool to construct a simple repository.

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

Duration: 5 Days

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

Audience:

  • Application Developers
  • Business Analysts
  • Business Intelligence Developer
  • Data Modelers
  • Data Warehouse Administrator
  • Data Warehouse Developer
  • Reports Developer
  • Technical Consultant

Prerequisites:

Topics:

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

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

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

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

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

Managing Logical Table Sources

  • Adding multiple logical table sources to a logical table
  • Specifying logical content

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

Working with Logical Dimensions

  • Creating logical dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating dimension-specific aggregation rules
  • Creating presentation hierarchies
  • Creating parent-child hierarchies
  • Creating ragged and skipped-level hierarchies

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

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

Using Partitions and Fragments

  • Exploring partition types
  • Modeling partitions in an Oracle BI repository

Using Repository Variables

  • Creating session variables
  • Creating repository variables
  • Creating initialization blocks
  • Using the Variable Manager
  • Using dynamic repository variables as filters

Modeling Time Series Data

  • Using time comparisons in business analysis
  • Using Oracle BI time series functions to model time series data

Modeling Many-to-Many Relationships

  • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables

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

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

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

Cache Management

  • Restricting tables as non-cacheable
  • Using Cache Manager
  • Inspecting cache reports
  • Purging cache entries
  • Modifying cache parameters and options
  • Seeding the cache

Managing Metadata and Working with Service Instances

  • Using BI Application Archive (BAR) files to export and import service instances
  • Managing BAR files using WebLogic Scripting Tool (WLST) commands
  • Managing service instances using WLST commands

Using Administration Tool Utilities

  • Using the various Administration Tool utilities
  • Using BI Server XML API to create XML representation of repository metadata

Multiuser Development

  • Setting up a multiuser development environment
  • Developing a repository using multiple developers
  • Tracking development project history

Performing a Patch Merge

  • Comparing repositories
  • Equalizing objects
  • Creating a patch
  • Applying a patch
  • Making merge decisions
Right Menu IconMENU