60% Complete Courses » OBIEE 12c Repository Reporting Dashboard BI Publisher Reports
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register

Repository Building

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

• 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

Creating Answer Request

Introduction to Oracle Business Intelligence Enterprise Edition
• Introduction to Oracle BI EE
• Oracle BI 12c Architecture
• Oracle BI 12c Highlights

Working with Oracle Business Intelligence Analyses
• Introduction to Oracle BI Analysis Editor
• Oracle BI column types
• Working with analyses in Oracle BI
• Adding basic formatting
• Setting analysis properties
• Using advanced formatting

Filtering Data for Analyses
• Introduction to filters and selections
• Creating, editing, and grouping filters
• Adding prompts to analyses
• Dynamic filtering
• Using saved analyses as filters

Selecting and Grouping Data for Analysis
• Creating selection steps
• Creating groups
• Creating calculated items
• Creating direct database analysis requests
• Including advanced SQL clauses in your analysis

Advance Visualization in Analysis
• Introduction to views, graphs, and editors
• Working with views in Compound Layouts
• Creating and editing graphs
• Performing common view tasks

Showing Results with Pivot Tables
• Creating, arranging, and formatting a pivot table
• Using hierarchical columns
• Sorting in pivot tables
• Setting aggregation and using totals
• Showing an item's relative value
• Building calculations and displaying running sums

Working with Additional Views in Analyses
• Creating simple and advanced trellis views
• Creating performance tile views
• Working other view types like Treemap and Heat Matrix
• Linking master-detail views

Visualizing Data on Maps

• Oracle spatial components
• Managing map data
• Creating and editing Map views
• Interacting with map views
• Other applications and points of integration for map views

Creating Oracle Business Intelligence Dashboards
• Creating and editing dashboards
• Using the Dashboard Builder
• Exploring dashboard object properties and options
• Publishing dashboard pages
• Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards
• Exploring types of dashboard content
• Embedding content in dashboards

Creating Dashboard Prompts and Variables
• Understanding variables
• Adding a named dashboard prompt to a dashboard
• Adding a hidden named dashboard prompt to a dashboard
• Creating additional prompt page and setting page preferences
• Adding variable prompts to a dashboard

Scorecards and Key Performance Indicators
• Objects and components of Oracle Scorecard and Strategy Management
• Key Performance Indicator (KPI) overview
• Scorecard document types
• Creating scorecards and KPIs
• Creating scorecard documents
• Editing scorecards and KPIs

Visual Analyzer, BI Ask, and Data Mashup
• Creating Visual Analyzer Projects
• Adding and rearranging the Visualizations
• BI Ask
• Data Mashups

Working with BI Content in Smart View
• Working with Views in Smart View Clients
• Customizing BI data in MS Office
• Copying and pasting views between Smart View clients
• Inserting BI views in to Smart View clients
• Creating and publishing views using the View Designer
• Federating data from multiple data sources

Oracle Business Intelligence Mobile
• Downloading and using the Oracle BI mobile application
• Navigating the Oracle BI mobile application
• Working with favorites and local content
• Working with BI content
• Oracle BI Mobile Security Toolkit

Administering the Presentation Catalog

• Oracle BI and catalog security overview
• Managing security using roles
• Understanding security inheritance
• Setting object permissions
• Setting system privileges
• Archiving catalog items
• Working with Oracle BI Briefing Books

Direct Database Analysis
• Direct Database Analysis Overview
• Changing Direct Database Analysis Privileges
• Creating and Executing a Direct Database Analysis

Working with Oracle BI Publisher [XML Publisher]

Introduction to BI Publisher

o Oracle BI Publisher: Business Document Requirements
o Functions of Reporting Systems
o Oracle BI Publisher Paradigm
o End-to-End View and Salient Features of BI Publisher

Getting Started with BI Publisher: Creating a Simple Report

o Opening and viewing a Predefined Report
o Creating a BI Publisher Report Based on Oracle Database
o Editing the Properties of a Report

Oracle BI Publisher: Technology and Architecture

o Describe the components of Oracle BI Publisher
o Describe the architecture of Oracle BI Publisher
o Describe the Oracle BI Publisher Underlying Technology

Course Id:
Course Fees:
301 USD