Oracle

shinelogics-obi

Oracle OBI


Week Topics
1
    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 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 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
2
    Testing and Validating a Repository
  • Checking repository consistency
  • Turning on logging
  • Defining a repository in the initialization file
  • Executing analyses to test a repository
  • Adding Calculations to a Fact
  • 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 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
  • Using calculated members
3
    Using Aggregates
  • Modeling aggregate tables to improve query performance
  • Setting the number of elements in a hierarchy
  • Testing aggregate navigation
  • View the columns and contents of a table
  • Create indexes, views and sequences
  • Explain the use of temporary tables
  • Use the Data Dictionary
  • Manage data through SQL
  • Monitor and resolve locking conflicts
  • Using Repository Variables
  • Creating session variables
  • Creating repository variables
  • Creating initialization blocks
  • Using the Variable Manager
  • Using dynamic repository variables as filters
  • Importing Metadata from Multidimensional Data Sources
  • Importing a multidimensional data source into a repository
  • Incorporating horizontal 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
4
    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
  • Purging cache entries
  • Multiuser Development
  • Setting up a multiuser development environment
  • Developing a repository using multiple developers
  • Tracking development project history
5
    ANALYSIS,ANSWERS & DASHBOARD’S:
  • Working with Oracle Business Intelligence Analyses
  • Introduction to Oracle BI Analysis Editor
  • Oracle BI column types
  • Working with analyses in Oracle BI
  • Using advanced formatting
  • Administering the Presentation Catalog
  • Maintaining the Oracle BI Presentation Catalog in the Catalog page
  • Oracle BI and catalog security overview
  • Managing security using roles
  • Understanding security inheritance
  • Setting object permissions
  • Setting system privileges
  • Archiving catalog items
  • Introduction to filters and selections
  • Adding prompts to analyses
  • Dynamic filtering
  • Working with Views and Graphs in Analyses
  • Introduction to views, graphs, and editors
  • Working with views in Compound Layouts
  • Creating and editing graphs
  • Linking master-detail views
  • Performing common view tasks
  • Visualizing Data: Gauges, Maps, and Mobile
  • Introduction to Gauge views
  • Working with Gauge views
  • Introduction to Map views and their components
  • Creating and editing Map views
  • Introduction to Oracle Business Intelligence Mobile
  • Measuring Results with Key Performance Indicators
  • Introduction to KPIs
  • Showing Results With Pivot Tables
  • Introduction to pivot tables
  • Creating, arranging, and formatting a pivot table
  • Showing Results With Pivot Tables
  • Showing an item’s relative value
  • Introduction to dashboards and dashboard pages

Trainer Information

Trainer Name Experience Working In
Thiyagu 10 years MNC