Description

Type

Training
Level

Intermediate
Methodology

Online
Duration

1 Month
Start date

Different dates available

Online campus

Yes
Delivery of study materials

Yes
Support service

Yes
Virtual classes

Yes

The course on Oracle BI 12c: Build Repositories helps you understand how to build and verify the three layers of an Oracle Business Intelligence (BI) repository.

Facilities

Online

Start date

Different dates availableEnrolment now open

About this course

Course objectives

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

Presentation
Server
Business model
BI Server
Oracle BI Server
Structure
Features
BI architecture
Architecture components
BI Administration Tool
Oracle BI

Course programme

COURSE DETAILS & CURRICULUM

Repository Basics

Loading a repository into Oracle BI Server
Exploring a repository's structure, features, and functions
Exploring Oracle BI architecture components
Using the Oracle BI Administration Tool
Creating a repository
Installing the BI Client software

Building the Physical Layer of a Repository

Examining physical layer object properties
Importing data sources
Setting up Connection Pool properties
Creating alias tables
Printing the physical layer diagram
Defining keys and joins

Building the Business Model and Mapping Layer of a Repository

Building logical tables, columns, and sources
Building a business model
Building measures
Examining business model object properties
Defining logical joins
Printing the business model and mapping layer diagram

Building the Presentation Layer of a Repository

Exploring presentation layer objects
Nesting presentation tables
Modifying presentation layer objects
Examining presentation layer object properties
Controlling presentation layer object visibility
Creating presentation layer objects

Testing and Validating a Repository

Executing analyses to test the repository
Uploading the repository through Enterprise Manager
Inspecting the query log
Checking repository consistency
Turning on logging

Managing Logical Table Sources

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

Adding Calculations to a Fact

Creating new calculation measures based on physical columns
Creating measures using functions
Creating new calculation measures using the Calculation Wizard
Creating new calculation measures based on logical columns

Working with Logical Dimensions

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

Enabling Usage Tracking

Tracking and storing Oracle BI Server usage at the detailed query level
Creating the usage tracking tables
Setting up the sample usage tracking repository
Using usage tracking statistics to optimize query performance and aggregation strategies

Using Model Checker and Aggregates

Setting the number of elements in a hierarchy
Using the Aggregate Persistence Wizard
Testing aggregate navigation
Using Model Check Manager
Modeling aggregate tables to improve query performance

Using Partitions and Fragments

Exploring partition types
Modeling partitions in an Oracle BI repository

Using Repository Variables

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

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

Incorporating horizintal federation into a business model
Importing a multidimensional data source into a repository
Displaying data from multidimensional sources in Oracle BI analyses and dashboards
Adding Essbase measures to a relational model
Incorporating vertical federation into a business model

Security

Setting up object permissions
Creating users and groups
Exploring Oracle BI default security settings
Setting query limits and timing restrictions
Creating application roles
Setting row-level security (data filters)

Cache Management

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

Managing Metadata and Working with Service Instances

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

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
Tracking development project history
Developing a repository using multiple developers

Performing a Patch Merge

Creating a patch
Equalizing objects
Making merge decisions
Comparing repositories
Applying a patch

See related categories

Contact us

ORACLE BI 12C: BUILD REPOSITORIES

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

ORACLE BI 12C: BUILD REPOSITORIES

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.