Oracle Business Intelligence OBIEE

Repository Basics

  • Oracle BI architecture components
  • Repository structure, features, and functions
  • Using the OracleBI Administration Tool
  • Creating a repository
  • Loading a repository into Oracle BI Server memory

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 and select tables

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

Building the Presentation Layer of a Repository

  • Exploring Presentation layer objects
  • Creating Presentation layer objects
  • Modifying Presentation layer objects
  • Examining Presentation layer object properties

Testing and Validating a Repository

  • Checking repository consistency
  • Turning on logging
  • Defining a repository in the initialization file
  • Testing a repository using Oracle BI Answers
  • Inspecting the query log

Adding Multiple Logical Table Sources

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

Adding Calculations to a Fact Table

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

Creating Dimension Hierarchies and Level-Based Measures

  • Creating dimension hierarchies
  • Creating level-based measures
  • Creating share measures
  • Creating rank measures

Using Aggregates

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation
  • Using the Aggregate Persistence Wizard

Using Partitions and Fragments

  • Purpose for segmenting data into partitions and fragments
  • Partition types
  • Modeling partitions in an Oracle BI repository

Using Repository Variables

  • Session variables
  • Repository variables
  • 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
  • Using helper tables to model many-to-many relationships for team-based hierarchies in a dimension

Setting an Implicit Fact Column

  • Adding fact columns automatically to dimension-only queries
  • Ensuring the expected results for dimension-only queries
  • Selecting a predetermined fact table source
  • Specifying a default join path between dimension tables
  • Integrating Third-Party Reporting Tools with Oracle BI Server Creating Repositories Using Multidimensional Data Sources
  • Adding a multidimensional data source an Oracle BI repository
  • Displaying data from multidimensional sources in Oracle BI Answers requests and Oracle BI Interactive Dashboards Security
  • Creating users and groups
  • Setting permissions for users and groups
  • Authenticating using a external database
  • Authenticating using database authentication
  • Setting query limits and timing restrictions
  • Setting filters to personalize information

Cache Management

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

Setting Up and Administering Usage Tracking

  • Tracking and storing Oracle BI Server usage at the detailed query level
  • Using usage tracking statistics to optimize query performance and aggregation strategies
  • Analyzing usage results using Oracle BI Answers and other reporting tools

Multi-user Development

  • Setting up a multi-user development environment
  • Developing a repository using multiple developers
  • Tracking development project history

Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories

  • Employing techniques to optimize Oracle BI query performance
  • Applying Oracle BI repository design principles

Working with Oracle Business Intelligence Answers

  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers
  • Using advanced formatting

Filtering Requests in Oracle Business Intelligence Answers

  • Introduction to filters in Answers
  • Adding filter prompts to requests
  • Using saved requests as filters

Oracle Business Intelligence Answers: Advanced Features

  • Combining request criteria using set operations
  • Executing direct database requests
  • Editing logical SQL generated by a request

Building Views and Charts in Requests

  • Introduction to Answers views and charts
  • Creating and editing charts
  • Performing common view tasks

Showing Results with Gauge Views

  • Introduction to Gauge views
  • Working with Gauge views

Showing Results with Pivot Tables

  • Introduction to pivot tables
  • Formatting pivot tables
  • Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

  • Introduction to Interactive Dashboards and pages
  • Dashboard Editor UI elements
  • Composing dashboard elements

Configuring Oracle Business Intelligence Interactive Dashboards

  • Types of dashboard content
  • Embedding content in Interactive Dashboards
  • Using bookmark links to distribute and save Interactive Dashboards

Customizing the Oracle Business Intelligence User Interface

  • Modifying cascading style sheets
  • Modifying XML message files
  • Making configuration changes using the instanceconfig file

Configuring Guided Navigation Links

  • Building guided navigation with static links
  • Building guided navigation with conditional links and sections

Administering the Oracle Business Intelligence Presentation Catalog

  • Maintaining the Oracle BI Presentation Catalog
  • Managing security
  • Understanding security inheritance
  • Describing the Presentation Catalog structure
  • Permission types
  • Setting permissions using the Manage Catalog screen

Using Oracle Business Intelligence Delivers

  • Introduction to Oracle BI Delivers
  • Configuring delivery devices
  • Adding delivery profiles
  • Building alerts
  • Introduction to Oracle BI Scheduler
  • Scripted jobs

Using Oracle Business Intelligence Briefing Books

  • Introduction to Oracle BI Briefing Books
  • Creating an Oracle BI Briefing Book
  • Adding Content to Briefing Books
  • Editing a Briefing Book
  • Downloading and viewing a Briefing Book
  • Adding a list of Briefing Books to a Dashboard
  • Using Briefing Books with Oracle BI Delivers

Using Oracle BI for Microsoft Office

  • Introduction to Oracle BI for Microsoft Office
  • Working with Oracle BI content in Microsoft Office applications

Using Oracle Business Intelligence Publisher

  • Introduction to Oracle BI Publisher
  • Creating a BI Publisher report from an Answers request
  • Creating a BI Publisher report from the BI Server
  • Integrating Discoverer worksheet content in a BI Publisher report

Reviewing Interactive Dashboard Design Principles and Best Practices

  • Understanding dashboard design principles
  • Conceptualizing dashboards
  • Dashboard fundamentals

 
Student Community Apply online FAQ Course Calendar
  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...


+971 4 396 44 55