OBIEE Admin

• Introduction to OBIEE
• What is OBIEE?
• OBIEE Architecture
• OBIEE System Components, Logging, and Configuration
• BI Domain Architecture
• BI Integration with Other Products
• OBIEE Documentation
• The OBIEE Sample Application
• The Sample App – The Dashboard Pages
• The Sample App – The Simple Demo
• The Sample App – Reverse Engineering It
• The Sample App – Installed Users
• Starting and Stopping BI Services
• Logging in and out
• The BI Web Interface
• The Global Header
• Acting as Another User
• Setting Preferences
• The Catalog Menu
• Hands-on Lab Exercises
• OBIEE Management Tools

Overview of OBIEE Management Tools

• The Fusion Middleware Control
• The Fusion Middleware Control
• Fusion Middleware Control – The Core Application
• Uploading the Repository
• WebLogic Server Console
• WebLogic Server Administration Control
• Starting and Stopping the Weblogic Server
• The WLST Tool
• WLST – Connecting and Disconnecting
• Enabling the SSL Port
• WLST Scripts
• The BI Admin Tool
• The Job Manager
• Configuration Files
• Administering the Repository

The Administration Tool

• The OBI Data Layers
• Viewing Physical Tables
• Checking Data Consistency
• Viewing Logical Tables
• Viewing the Presentation Layer
• Uploading the Repository
• Repository Version Numbers
• Using the MBean Browser for Repository Configuration
• Hands-on Lab Exercises
• Managing Variables

Introduction to Variables

• Session Variables
• System Session Variable Reference
• Setting Non-System Session Variables
• Creating New Variables
• Initialization Blocks
• Associating Variables with Initialization Blocks
• Viewing Current Variable Values
• Testing Session Variables From Filters
• SQL-Based Non-System Session Variables
• Referencing the Session Variable
• Repository Variables
• Example – Dynamic Repository Variable
• Testing Repository Variables with Filters
• Presentation Variables
• Predefined Presentation Variables
• Referencing a Presentation Variable from a Title View
• Prompts and Presentation Variables
• Testing the Analysis Prompt
• Presentation Variables in Conditional Formatting
• Referencing a Variable with Conditional Formatting
• See it in Action!
• Column Prompts
• The Prompts Editor
• Column Prompts in Action
• Hands-on Lab Exercises
• Managing OBI Security

Authentication and Authorization Concepts

• Application Policies and Application Roles
• Users, Groups, and Roles
• The WebLogic Security Realm
• Creating Users
• Security Providers
• Changing the Security Provider
• Managing User Passwords
• Managing Password Lockout
• Adding Users to GroupsCreating Application Groups
• Application Roles
• Adding Users to Application Groups
• Creating a New Application Role
• Application Role Privileges
• Associating Application Groups with Roles
• Associating Users with Application Groups
• Testing Your New User
• Setting Object Permissions
• Setting up User Proxies
• Proxy Privilege (cont’d)
• Hands-on Lab Exercises
• Managing the Catalog

Catalog Overview

• The Catalog Location
• Creating a New Catalog
• Deploying a Catalog to Production
• The Catalog Manager
• Catalog Manager – Online vs Offline Mode
• Opening in Offline Mode
• Deploying Catalog Objects
• Updating Catalog Objects
• Catalog Validation
• Setting Object Permissions through Catalog Manager
• Managing Catalog Groups
• Setting Object Properties
• Copying and Pasting Objects
• Paste Preferences
• Renaming Objects
• Searching for Catalog Objects
• Hands-on Lab Exercises

Configuring Analyses and Dashboard Settings

• Setting Default Max Records
• Setting View Properties
• Data Attributes for Views
• Configuring Graphs and Gauges
• Setting Alternating Bar Colors
• View Interaction Settings
• Analysis
• Interaction Properties
• Interaction Property
• Add Remove Values true
• Configuring Prompts
• Presentation Defaults
• Customizing the Global Header Links
• Global Header Links – Elements and Attributes
• Enabling Custom Links
• Dashboard Page Links
• Setting Alternate Toolbar for BI Publisher Reports
• Setting Default Footers in New Analyses
• Auto-Preview Settings
• Setting Default Views with New Analyses
• Setting Dashboard Drilling Behavior
• Dashboard Headers, Footers, and Orientation
• Hands-on, Lab Exercises
• Agent and Mail Management

Introduction to Agents

• Agent Permission Requirements
• Configuring the Mail Server
• What are Alerts?
• Saving Agents
• Hands-on Lab Exercises
• Configuring Writeback

Overview of Writeback

• Configuring Write-Back
• Sample Write-Back Template
• The LightWriteback XML Element
• Lab Exercises

Viewing BI Metrics

• Monitoring WebLogic Java Components
• Query Performance Tuning
• Fusion Middleware Control Performance Parameters
• Viewing and Purging the Cache
• Hands-on Lab Exercises
• Diagnosing Problems

Auditing Tools

• Fusion Middleware Overview Page
• Fusion Middleware Diagfnostics
• Diagnostic Log Files
• Configuring Diagnostics Log Settings
• Configuring Log Output Type
• Configuring Log Writers
• Query Logging
• Query Log Levels
• The Log Viewer Utility
• Reading the Query Logs
• Hand-on Lab Exercises
• OBIEE Backup and Recovery

Backup Overview

• Files to Backup
• Backing Up MDS and BIPLATFORM Database Schemas
• Backing up the Homes
• Back Up Windows Registry Entries
• Recovery Basics
• Hands-on Lab Exercises
• Overview of NQSConfigINI File
• Repository
• Query Result Cache
• Usage Tracking
• Query Optimization
• Aggregate Persistence

Cache Management in OBIEE

• overview of cache architecture
• purging cache
• scheduling cache
• manual and automatic cache in obiee