What you will learn
This course is designed to teach you the administrative requirements of Hyperion System 9 BI+ Analytic
Services. You learn how to configure the block storage and aggregate storage kernels; design and manage
security; optimize system caches; and perform backup, recovery, application migration, and task automation.
Exercises and a case study provide hands-on practice.
|
Audience
Database Administrators
Database Designers
Developer
Technical Administrator
|
Prerequisites
Basic system administration experience
Hyperion Essbase Analytics 9.3 Bootcamp
|
Course Objectives
Describe the components of the Hyperion
Describe aggregate and block storage data
Configure the Analytic Services environment
Set up user, group, and application access
Modify Analytic Services cache settings
Perform database maintenance, backup and recovery, application migration, and task automation
|
Course Topics
Analytic Services Overview
Online Analytical Processing
Hyperion Business Performance Management
Hyperion Analytic Solution
Administration Services Console
Analytic Services Production Cycle
Essbase Analytics Data Storage
Enterprise Analytics Data Storage
Configuring the Analytic Services Environment
eLicensing Overview
Setting Connection Options and Disk
Configuring Analytic Services to Run as a
Transaction and Locking Behavior
Gathering System Information Through Logs
Configuring Block Storage Applications
Configuring Aggregate Storage Applications and Analytic Server
Configuring Smart View for Office
Securing Analytic Services in Native Mode
Analytic Services Native Security
Managing Users in Native Security
Security Layers
Security Roles and Permissions
Creating User and Group Profiles
Application Access Type Security
Creating and Testing Security Filters
Resolving Security Conflicts and Permission Overlap
Securing Analytic Services in Shared Services Mode
Shared Services Security
Converting Analytic Services to Shared Services Security
Managing Users in Shared Services
User Provisioning in Shared Services
Assigning Database Calculation and Filter Access
External Authentication
Single Sign-on
Optimizing the Analytic Services Environment
Analytic Services Optimization Tools
Setting Analytic Services Caches
Specifying Retrieval Buffers and Data Compression
Analytic Services Data Compression Methods
Removing Database Fragmentation
Restructuring Databases
Removing Security File Fragmentation
Maintaining the Analytic Services Environment
Managing Object Locks and User Sessions
Backing Up and Recovering Block Storage Databases
Migrating Applications and Databases
Porting Applications Across Platforms
Automating Database Processes with MaxL
|
Related Courses
Hyperion Essbase Analytics 9.3 Bootcamp
Hyperion Essbase 9.3 Fundamentals
|