Audience :

  • Database Administrators
  • Data Warehouse Administrators
  • BI Developer
  • BI Power Users
  • Business Analysts
  • Data Modelers

Topics :

  • Table of Contents
    • Product and Course Overview
    • Introduction to Oracle BI Enterprise Edition
    • Class Objectives
    • Scenario
    • Connecting to a Virtual Machine via Remote Desktop Connection
    • Exploring Oracle BI Analytics (Optional Exercise)
  • Creating a Metadata Repository
  • Importing and Joining Tables in the Physical Layer
    • Importing Tables from a Relational Database
    • Creating Alias Tables
    • Creating Physical Joins
    • Disabling Fact Table Caching
  • Creating the Business Model and Mapping Layer
    • Creating the Business Model and Mapping Tables
    • Exploring Logical Joins
    • Building Dimensions and Hierarchies
    • Using the Rename Wizard
  • Creating the Presentation Layer
    • Copying from the Business Model Layer
    • Making Changes to the Presentation Layer
    • Validating the Repository
  • Understanding OBIEE Components and Services
    • Exploring Oracle BIEE Components
    • Exploring Oracle BIEE Services
  • Activating and Testing the Repository
    • Activating the New Repository
    • Opening a Repository in Online Mode
    • Enabling Query Logging
    • Testing the New Repository
    • Using the Query Log to Verify Queries
  • Creating Simple Fact Columns
    • Creating Logical Facts from Physical Tables
    • Creating Derived Fact Columns in Answers
    • Creating Fact Columns using Logical Columns
    • Creating Fact Columns using Physical Columns
    • Creating Level-based Facts
    • Using the Calculation Wizard
  • Organizing Repository Objects
    • Organizing the Business Model Layer
    • Organizing Presentation Columns in Hierarchical Order
    • Nesting and Organizing Presentation Layer Folders
  • Creating Time Series Facts
    • Creating a Time dimension
    • Creating Year Ago Facts
    • Creating Year-to-Date Facts
    • Creating Rolling Period Facts
    • Setting Data Display Formats
  • Advanced Calculation Functions
    • Using the Filter function
    • Using the Rank function
    • Using the Percentile and NTile functions
    • Using the Calendar Date/Time Functions
    • Using the Cast function
    • Using the Case statement
  • Creating Repository Documentation
    • Creating CSV File Documentation
    • Creating HTML Documentation
  • System Operation and Performance
    • Examining Query Caching
    • Log Files
  • Security Overview
  • Authentication and Authorization
    • Creating Users Directly in WLS LDAP
    • Information About Alternative Authentication Methods
    • Integrating a Third-Party LDAP (Microsoft Active Directory)
    • Using a Database Table for Groups and Group Membership
      • Creating the GROUPS table
      • Creating the GroupMembers table
      • Creating the GroupMembers_VW view
      • Installing and Configuring the BISQLGroupProvider
      • Configuring the Virtualized Identity Store Adapter
      • Confirm the Addition of Table-Based Groups
    • Creating Roles in Fusion Middleware
  • Applying Role-Based Data Security
    • Configuring Access to Subject Areas
    • Creating Role-Based Row-Level Security Rules in the Repository
    • Creating Role-Based Column-Level Security Rules in the Repository
    • Imposing Role-Based Run-Time Restrictions
      • Creating Data Security Permissions by Time of Day
      • Creating Data Security Permissions by Query Maximums
      • Understanding Data Security Precedence
    • Implementing Parameter-Driven Security using Variables
      • Creating a Connection Pool for Initialization Blocks
      • Creating Repository Variables
      • Exposing Variables to Users
      • Configuring Leaf-Level Parameter-Driven Security
      • Configuring Summary-Level Parameter-Driven Security
      • Using Dynamic Table Names
    • Managing Web Catalog Privileges and Permissions
      • Assigning Functional Privileges
      • Administering the Presentation Catalog
    • Using Aggregate Data Sources
      • Defining and Mapping Aggregate Tables
      • Populating # of Elements for Dimension Levels
    • Aggregating Based on Dimensions
      • Creating OBIEE Physical Tables as Views
      • Aggregating Based on Dimensions
    • Advanced Topics
      • Incorporating Fragmented Data
      • Using Duplicate Alias Tables
      • Table Join Types in the Business Model
      • Using the Evaluate Function
      • Modeling Double-Columns
      • Using Lookup Tables
      • Modeling normalized (3NF) data sources
    • Multi-User Development
      • Multi-User Development
      • Migrating Repository Changes into QA
      • Performing a Three-Way Repository Merge
    • Exploring Database Options
    • Adding More Sources and Targets
      • Creating and Mapping New Sources and Targets
    • Appendices
      • Appendix A Query Logging Level Descriptions
      • Appendix B Importing using ODBC
      • Appendix C Publishing Variable Names
      • Appendix D System Session Variables
      • Appendix E Using the Aggregate Persistence Wizard
      • Appendix F Creating Logical Display Folders
      • Appendix G New WLS Users Cannot Log In