OBIEE 11g Administration Course – OBI500
The 4-day OBIEE 11G Administration course teaches you how to manage the Oracle BI System. During this OBIEE course you’ll learn about the EM Fusion Middleware Control, WebLogic Administration Console, as well as the Windows-based BI Admin Tool. You’ll learn how to administer the repository, manage variables, the catalog, and security on several levels.
You will configure the Analysis and Dashboards settings through special configuration files, as well as configuring the presentation services initialization file. You will manage the mail and agent setting to properly configure report delivery. As logging is very important to understanding your BI Server, we will discuss how to read logs, diagnose problems, and fix them. Finally, we will cover OBIEE backup and recovery techniques to protect your system against failure.
OBIEE 11g Administration Training – OBI500 – 4 Days Request a Class Date
The 4-day OBIEE 11G Administration course teaches you how to manage the Oracle BI System.
Multi-Enrollment Discounts Available at Check-Out
- Instructor
- Julie Johnson
OBIEE Administration Training Course Outline
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 OPMN Tool
- The WLST Tool
- WLST – Connecting and Disconnecting
- Enabling the SSL Port
- WLST Scripts
- The BI Admin Tool
- The Job Manager
- Configuration Files
- The MBean Browser
- Viewing Log Files
- Hands-on Lab Exercises
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
- Catalog Files and Attributes
- Hashing Home Directories
- 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
- Updating GUIDs
- Performing Validation
- Validation Elements and Options
- Setting Object Permissions through Catalog Manager
- Managing Catalog Groups
- Setting Object Properties
- Copying and Pasting Objects
- Paste Preferences
- Renaming Objects
- Searching for Catalog Objects
- Enabling Full Text Search
- 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
- Configuring the GMail SMTP Server
- Testing the Email Settings
- Configuring the Scheduler Database
- Managing New Device Types
- Configuring Devices
- Configuring Delivery Profiles
- Setting Presentation Defaults
- More Presentation Settings – Related to Agents
- General Scheduler Settings
- Agent Scheduler Settings
- Monitoring Active Agent Sessions
- The Agent Editor
- Agent Editor Overview – General Properties
- The Agent Editor – Schedule
- Agent Editor Overview – Conditions
- The Agent Editor – Delivery Content
- Agent Editor Overview – Recipients
- The Agent Editor – Suscriptions
- Viewing Subscriptions
- Viewing Subscribers
- The Agent Editor – Destinations
- Agent Editor Overview – Actions
- Actions – Web Services
- Saving Agents
- What are Alerts?
- Hands-on Lab Exercises
Configuring Writeback
- Overview of Writeback
- Configuring Write-Back
- Sample Write-Back Template
- The LightWriteback XML Element
- Lab Exercises
Managing Maps, Time Zones, and Currencies
- OBIEE Map Requirements
- MapViewer
- The Configuration File
- The mapviewconfigxml File
- Managing Map Tile Layers
- Map Management Interface
- Importing Background Maps
- Creating a Map Tile Layer
- Associating Layers with Maps
- Setting the Zoom Level for Layers
- Zoom Ordering
- Overview of Time Zones
- Working with Currencies
- Setting the Default Currency
- User-Preferred Currency Options
- Hands-on, Lab Exercises
Query Caching and Performance Tuning
- 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
- Recording Environment Information
- Recovery Basics
- Hands-on Lab Exercises
Appendix A
- NQSConfigINI Reference
- Overview of NQSConfigINI File
- Repository
- Query Result Cache
- General
- Security
- Server
- High Availability
- Dynamic Library
- Usage Tracking
- Query Optimization
- MDX Member Name Cache
- Aggregate Persistence
- Java Host
- Datamart Automation
- Lab Solutions