Hyperion Classroom Training in Hyderabad

Hyperion Classroom Training in Hyderabad:

Essbase Overview

  • Multidimensional Analysis
  • Oracle’s Enterprise Performance Management System
  • Oracle BI Foundation Suite
  • Essbase
  • Production Environment Components

Designing Applications And Databases

  • Essbase Implementation Process
  • Analyzing and Planning Implementations
  • Creating Applications and Databases
  • Creating Outlines

Designing Data Descriptor Dimensions

  • Data Descriptor Dimensions Overview
  • Designing Time Dimensions
  • Designing Scenario Dimensions
  • Designing Accounts Dimensions

Optimizing Data Descriptor Dimensions

  • Creating Member Aliases
  • Dimension Types
  • Creating Period-to-Date Totals
  • Dynamic Calc Members
  • Enhancing Accounts Dimensions

Creating Basic Dimension Build Rules Files

  • Rules Files Overview
  • Creating Dimension Build Rules Files
  • Configuring Dimension Maintenance Settings

Creating Advanced Dimension Build Rules Files

  • Advanced Dimension Build Rules Files Overview
  • Creating Shared Members
  • Manipulating Fields
  • Creating User-Defined Attributes
  • Creating Attribute Dimensions with Rules Files

Loading Data

  • Data Load Overview
  • Creating Data Load Rules Files
  • Selecting and Rejecting Records
  • Capturing New Members

Getting Started With Smart View

  • Navigating Smart View
  • Connecting to Data Sources
  • Creating Ad Hoc Grids
  • Setting the Point of View
  • Associating Data Sources with Worksheets
  • Creating Free-Form Grids

Creating Reports With Smart View

  • Updating Essbase Data
  • Integrating Essbase Data with Microsoft Office
  • Creating Shared Database Perspectives
  • Creating Custom Reports

Data Storage And Calculation

  • Calculation Overview
  • Database Calculation Order
  • Data Block Fundamentals
  • Data Blocks and the Index System
  • Interpreting Database Statistics
  • Data Block Creation
  • Database Calculation Process

Creating Calculation Scripts

  • Calculation Script Organization
  • Returning Correct Calculation Results
  • Troubleshooting CALC DIM Proces

Controlling The Calculation Process

  • Focusing Calculations with FIX Statements
  • Calculating Conditionally with IF Statements

Copying And Clearing Data

  • Copying Data
  • Clearing Data with CLEARDATA
  • Clearing Data with CLEARBLOCK

Referencing Members In Calculations

  • Referencing Members Explicitly
  • Referencing Members Dynamically
  • Creating Calculation Variables

Creating Attribute Dimensions

  • Attribute Dimensions Overview
  • Adding Attribute Dimensions to Outlines
  • Design Considerations

Analyzing Varying Attributes

  • Varying Attributes Overview
  • Creating Varying Attributes
  • Viewing Varying Attribute Data

Analyzing Text And Dates

  • Typed Measures Overview
  • Enabling Typed Measures
  • Creating Text Measures
  • Creating Date Measures
  • Viewing Typed Measures
  • Calculations Based on Typed Measures

Analyzing Varying Attributes
Creating Database Partitions

  • Designing partitions
  • Creating partitions
  • Evaluating partition designs

Essbase Security Overview

  • Essbase Native Security
  • Global Access Security Layer
  • User and Group Security Layer
  • Application Access Type Security
  • The Essbase Security File

Creating Essbase Security Filters

  • The Essbase Security Filter Layer
  • Creating Security Filters
  • Filter Behavior
  • Resolving Security Conflicts

Securing The Essbase Environment In Shared Services

  • Shared Services Security
  • Converting Essbase Users to Shared Services Security
  • Provisioning Users in Shared Services
  • External Authentication and Single Sign-on

Optimizing Block Storage Caches

  • Optimizing the Database
  • Optimizing Caches
  • Setting RAM Caches
  • Cache Hit Ratios

Managing Fragmentation

  • Measuring Database Fragmentation
  • Preventing and Reducing Database Fragmentation
  • Removing Security File Fragmentation

Backing Up, Restoring, And Recovering Essbase Databases

  • About Backup, Restore, and Recovery
  • Manual Backup and Restore
  • Automated Backup and Restore
  • Manual Recovery
  • Automated Recovery
  • Recovering from a Server Interruption
  • Recovering Corrupted Essbase Databases

Task Automation

  • Automating Tasks Using MaxL
  • The MaxL Command Shell
  • MaxL Statements and Syntax
share this
Top ↑