OBIEE Server Administration and Repository Management

Deliver meaningful real-time metrics, measurements and facts to your business users when you master the components in Oracle's Business Intelligence Enterprise Edition (OBIEE). Our instructor-led courses cover the key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. This Administration course teaches the attendee how to set up and administer the three layers of an Oracle BI Repository - the Physical layer, the Business layer, and the Presentation layer. Attendees will learn to import schemas, design and build logical business models, and expose business models to users in Oracle BI Answers. Business users, data architects and developers— every member of your team will contribute to the success of your next BI project.

In this class, students will learn how to use physical database objects as data sources; how to expose the business model to the user community; how to implement a security model, learn about cashing for enhanced performance, and how to use the advanced features of the tool.

Here are the course topics for this 4 day class:

• Physical Repository Design
• Metadata Layer Design
• Building Presentation Layer
• Dimensions, Facts and Measures
• Using Aggregates and the Aggregate Persistence Wizard
• Using Alias Tables and dynamic Physical Tables
• Mapping to Star and Snowflake Schemas
• Session Variables and Repository Variables
• Time Series Data
• Dimension Hierarchies and Level Based Measures
• Calculations on Fact Tables
• Exploring Logical Join Types
• Security Concepts and Setup
• Caching
• Catalog Setup
• Creating Repository Documentation
• Configuring of BI Delivers
• Configuration of the Oracle BI Server Environment

Audience: Database and Data Warehouse Administratior; BI Developers and Power Users
Prerequisites: OBIEE Dashboards, Answers, and Delivers