Hyperion Reporting & Analysis 11.1.1 Administration

In this course, you learn the architecture and tasks required to administer, install, and configure Reporting and Analysis. You learn how to manage users and content, configure system features, trouble-shoot and maintain systems, plan installations, and install Reporting and Analysis by product and by tier. Exercises help you practice the skills taught.

Learn To:

• Explain the Reporting and Analysis architecture
• Administer repository content
• Configure system features
• Administer user security
• Install and configure Reporting and Analysis
• Maintain Reporting and Analysis

Audience

• Administrator
• Security Administrators
• Support Engineer
• Technical Administrator
• Technical Consultant

Course Topics Product Orientation

• Oracle’s Enterprise Performance Management System
• Oracle Business Intelligence Suite Enterprise Edition Plus
• Oracle BI EE Plus Tiers
• Hyperion Reporting and Analysis Product Components

Exploring the Reporting and Analysis Architecture

• Reporting and Analysis Architecture Benefits
• Reporting and Analysis Architecture Tiers
• Content Generation in Workspace
• Communication Between Web and Services Components
• Foundation Services Components
• Configuration Tools
• Viewing System Information
• Starting, Stopping, and Pinging Services

Working with Installation and Configuration Tools

• Installation and Configuration Tools
• EPM System Installer
• EPM System Configurator
• EPM System Diagnostics
• EPM System Uninstaller

Installing and Configuring Shared Services

• Pre-Installation Tasks
• Installing Shared Services Components
• Configuring Shared Services
• Backing Up the OpenLDAP Directory
• Testing the Shared Services Installation and Configuration

Installing and Configuring Workspace

• Pre-Installation Tasks
• Installing Workspace Components
• Configuring Workspace Components
• Testing the Workspace Installation and Configuration

Provisioning Users

• Provisioning Concepts
• Creating Application Groups
• Creating Native Users and Groups
• Deactivating and Deleting Users
• Assigning Roles to Users and Groups
• Creating Provisioning Reports
• Setting Permissions on Items
• Best Practices

Implementing Essbase

• Essbase Architecture
• Essbase Components
• Installing Essbase Components
• Configuring Essbase Components
• Working with Administration Services Console
• Managing Essbase Security
• Working with Sample Applications

Implementing Interactive Reporting

• Interactive Reporting Architecture
• Installing and Configuring Interactive Reporting Components
• Creating Interactive Reporting Documents
• Setting Up Connectivity in Workspace
• Importing Interactive Reporting Documents into Workspace
• Best Practices for Report Developers
• Best Practices for Administrators

Implementing Web Analysis

• Web Analysis Architecture
• Installing and Configuring Web Analysis Components
• Creating Web Analysis Documents
• Creating Data Source Connections
• Exporting and Importing Documents and Presentations

Implementing Financial Reporting

• Financial Reporting Architecture
• Installing Financial Reporting Components
• Configuring Financial Reporting Components
• Creating Financial Reporting Database Connections in Workspace
• Creating Financial Reporting Reports
• Exporting and Importing Financial Reporting Reports
• Best Practices

Implementing SQR Production Reporting

• SQR Production Reporting Architecture
• Installing SQR Production Reporting Components
• Configuring SQR Production Reporting Components
• Creating Simple SQR Production Reporting Jobs
• Importing SQR Production Reporting Jobs into Workspace
• Running SQR Production Reporting Jobs in Workspace
• Best Practices

Scheduling Jobs and Batches

• About Scheduling
• Scheduling Interactive Reporting Jobs
• Creating Calendars
• Configuring Directories and Printers for Job Output
• Scheduling SQR Production Reporting Jobs
• Creating and Scheduling Financial Reporting Batches
• Managing Schedules in the Schedule Module
• Best Practices

Configuring Workspace Features

• Enabling Subscriptions for Users
• Enabling Priority Rating
• Configuring MIME Types
• Configuring User and Group Lists for Permissions
• Configuring Generic Jobs
• System Folders in Workspace
• Enabling Usage Tracking

Managing Change with Interactive Reporting Documents

• About Impact Manager
• Harvesting Metadata
• Updating Data Models
• Updating JavaScript
• Managing Impact Manager Tasks
• Viewing Impact Reports

Implementing Row-Level Security

• About Row-Level Security
• Enabling Row-Level Security
• About the Row-Level Security Tool
• Creating Row-Level Security Tables
• Creating Users and Groups
• Creating Rules

Configuring External Security Sources

• About External Directories
• Assessing User Directories for Reporting and Analysis
• Configuring External Users and Groups (MSAD Example)
• Configuring Single Sign-on from External Systems
• Best Practices for Ensuring Good Login Performance
• Best Practices for Configuring User Directories

Configuring System Logging

• System Logging Benefits
• Log4J Framework
• Logging Service
• Locations for Reporting and Analysis Logs
• Log File Name Formats
• Log Levels
• Log Message Format and Log Rotation Cycle
• Setting Log Levels and Analyzing Logs

Migrating Reporting and Analysis Content

• About Lifecycle Management
• Viewing Artifacts
• Completing Premigration Tasks
• Migrating Reporting and Analysis Artifacts
• Completing Postmigration Tasks

Clustering Reporting and Analysis Components

• About Clusters
• Clustering Support for Reporting and Analysis
• Replicating Services
• Installing the Same Services on Multiple Hosts

Course Objectives

• Explain the Reporting and Analysis architecture
• Install and configure Reporting and Analysis
• Administer user security
• Administer repository content
• Maintain Reporting and Analysis