Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Aug 22, 2022 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
Oct 3, 2022 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
Dec 5, 2022 | 11:00 | 07:00 | EST | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
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