Course : TRN 203 : Oracle BI EE Advanced Administration

Overview : Following on from the Oracle BI EE 10g Basic Administration course, this course teaches delegates about more advanced BI EE concepts such as aggregates, caching, variables, cross-database joins and writeback. It examines advanced security aspects such as Microsoft Active Directory integration and the use of custom authenticators, and takes delegates through the process of migrating projects through different environments and with multiple developers.

In addition to advanced development concepts, this course teaches Oracle BI EE troubleshooting and fault resolution, monitoring and performance optimization. Aimed at delegates who have either completed the Basic Administration course or who have some experience with Oracle BI EE, this course completes the skills required by an Oracle BI EE developer so that they can successfully deliver an end-to-end system.

Duration : 2 Days

Course Delivery : Instructor-led with labs, on-site at customer location

Who Should Attend : Developers, consultants, managers, technical leads, DBAs

Prerequisites : 202 Oracle BI EE 10g Basic Administration

Detailed Course Agenda :

Day 1

1. Advanced BI Server Administration

  • Basic Caching
  • Programmatic Flushing of Cache
  • Aggregates & Aggregate Persistence Wizard
  • Modeling flat structures (files, single tables)
  • Multiuser Development
  • Initial Migration from Development to Production
  • Subsequent Migrations from Development to Production
  • Content Accelerator Framework
  • Variables
  • Writeback
  • Source control using Subversion

Day 2

2. Oracle BI Advanced Security

  • Setting up LTS filters
  • Active Directory integration
  • Custom Authenticators
  • Hyperion Shared Services Integration

3. OBIEE Performance Optimization

  • Usage Tracking
  • The Query Log and Logging Levels
  • Aggregate Persistence Wizard
  • Cross-Database Joins and Driving Tables
  • Use of Database Indexes and Materialized Views
  • Database Tuning Tools
  • Performance Optimization Steps

4. OBIEE Troubleshooting

  • Logs & Monitoring Tools Overview
  • Resolving connectivity and server uptime issues
  • Diagnosing crashes
  • Raising SRs with Oracle Support

To book this course for your organization, to customize this course or for more information, contact training@rittmanmead.com for more details.

Website Design & Build: tymedia.co.uk