OBIEE 11g Administration Online Training Course

OBIEE Administration Online Training Course Contents

Introduction to OBIEE 11g

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