Friday, 10 May 2013

Hyperion-planning-training-hyderabad





Hyperion Planning Course Content:


Oracle Hyperion Planning 11.1.2:
Introduction to Planning
  • Planning Overview
  • Planning Architecture Overview
  • Planning Business Process Overview
  • Planning Business Scenario
Navigating Workspace
  • Workspace Overview
  • Launching Workspace
  • Opening Applications
  • Navigating in Planning
Dimensions Overview
  • Plan Types
  • Planning Dimensions
  • Data Block Creation Process
  • Aggregation, Storage, and Calculation Options
Creating and Managing Dimensions in Performance Management Architect
  • Navigating Performance Management Architect
  • Managing Dimensions
  • Creating Members in Dimension Library
  • Managing Members
  • Creating Associations Between Dimensions
  • Organizing Shared Library
  • Working with Grid Editor
Importing Metadata
  • Metadata Load Options
  • Formatting Metadata Load Files
  • Creating Import Profiles
  • Staging Metadata with Interface Tables
  • ERP Integrator Metadata Load Process
  • Importing Metadata with Lifecycle Management
Creating Applications
  • Methods for Creating Appliations
  • Application Creation Process
  • Application Criteria
  • Creating Appliations with Application Creation Wizard
  • Adding Dimensions from Shared Library
Setting Up Alias, Period, Year, Scenario, Version, and Currency Dimensions
  • Creating Aliases
  • Customizing Time Periods
  • Creating Scenarios
  • Defining Versions
  • Adding Currencies
Setting Up Entity and Account Dimensions
  • Entities Overview
  • Adding and Modifying Entities
  • Accounts Overview
  • Account Types
  • Saved Assumptions
  • Data Types and Exchange Rates
  • Creating Account Hierarchies
  • Consolidation Order
Creating User-Defined Elements
  • User-Defined Dimensions
  • Adding Attributes
  • Creating Member Formulas
  • Adding User-Defined Attributes
  • Working with Smart Lists
Deploying Applications
  • Deployment Process
  • Preparing Applications for Deployment
  • Validating Applications
  • Deploying Applications to a Planning Server
  • Redeploying Applications
  • Setting Planning Properties
Setting Up Exchange Rates
  • Currencies and Exchange Rates
  • Creating Exchange Rate Tables
  • Generating Currency Conversion Calculation Scripts
Loading and Calculating Data
  • Data Load Options
  • Staging Data with Interface Tables
  • ETL Data Load Tools
  • Data Calculations
Provisioning Users and Groups for Planning
  • Planning Security Overview
  • User and Group Provisioning Overview
  • Provisioning Users and Groups
  • Generating Provisioning Reports
Setting Up Access Permissions to Planning Applications
  • Assigning Access Permissions
  • Importing Access Permissions
  • Creating Security Filters
Creating Data Forms
  • Data Forms Overview
  • Creating Simple Data Forms
  • Creating Composite Data Forms
Customizing Data Forms
  • Data Form Customization
  • Exporting and Importing Data Forms
  • Creating Menus
  • Creating Formula Rows and COlumns
  • Building Validation Rules
  • Setting Up Custom Messaging
  • Specifying Advanced Settings
  • Setting Up User Preferences
Entering Data in Planning
  • Navigating Data Forms
  • Submitting Data in Data Forms
  • Spreading Data
  • Adjusting Plan Data
  • Adding Annotations to Plan Data
  • Performing Ad Hoc Actions on Data Forms
  • Calculating Data in Data Forms
Creating and Managing Business Rules
  • Business Rules Overview
  • Assigning Business Rule Security
  • Launching Calculation Manager
  • Setting Up Business Rules
  • Validating and Deploying Business Rules
  • Launching Business Rules
  • Creating, Validating, and Deploying Rulesets
  • Creating Business Rule Variables and Formulas
Setting Up the Approval Process
  • Approval Process Overview
  • Creating Planning Unit Hierarchies
  • Setting the Potential Promotional Path
  • Assigning Scenario and Version Combinations
  • Synchronzing Planning Unit Hierarchies
  • Exporting and Importing Planning Unit Hierarchies
  • Viewing and Resolving Validation Errors
Managing the Approval Process
  • Planning Unit Process States
  • Reviewer Actions
  • Impact of Entity Hierarchy on the Approval Process
  • Managing the Review Cycle
  • Copying Data Between Versions
  • Copying Relational Data for Dimensional Intersections
  • Clearing Cell Details
Creating Task Lists
  • Task Lists Overview
  • Navigating Task Lists in Basic Mode
  • Navigating Task Lists in Advanced Mode
  • Task List Creation Process
  • Printing Task List Reports
Setting Up Classic Applications
  • Classic Planning Application Set Up Process
  • Building Dimension Hierarchies
  • Setting Up Attributes
  • Creating Alias Tables
  • Smart List Creation Process
  • Setting Up UDAs
  • Loading Metadata and Data into Classic Applications
  • Exporting and Importing Data Forms

Hyperion-essbase-training-hyderabad





 
Hyperion essbase course content
Oracle Essbase 11.1.2.2

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 Processes

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

Partitioning Overview
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

Aggregate Storage Overview

  • Aggregate storage key characteristics and design considerations
  • Understanding the aggregate storage production cycle
  • Creating aggregate storage outline hierarchies

Loading Data

  • Understanding the aggregate storage data loading process
  • Using data load buffers
  • Loading data incrementally

Aggregating Data

  • Understanding the data aggregation process
  • Optimizing aggregations



Managing Aggregate Storage Databases

  • Managing table spaces
  • Exporting aggregate storage data
  • Optimizing data compression
  • Managing storage caches
  • Optimizing outline paging
  • Understanding disk space management options
  • Backing up aggregate storage applications
  • Viewing database statistics

Creating Basic MDX Queries

  • MDX Overview
  • MDX Queries
  • MDX Query Structure
  • MDX Comments
  • Selecting Multiple Members