Online Oracle Hyperion Essbase and SmartView Boot camp Training Classes And Courses  BISP 

60% Complete Courses » Oracle Hyperion Essbase and SmartView Boot camp Training
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


An Introduction to Multi-Dimensional Database
  • Understating Multi Dimensional Database concepts
  • Dimensional Modeling Concepts
  • Dimension and Fact
  • Dimension Hierarchy
  • Confirm Dimension
  • Full and Semi additive Measure
  • Star Schema, Snowflake schema and galaxy model
  • Operation on Multidimensional database
Essbase Overview
  • Essbase
  • Production Environment Components
Designing Applications and Databases
  • Essbase Implementation Process
  • Analyzing and Planning Implementations
  • Creating Applications and Databases
Creating Outlines
  • Data Descriptor Dimensions Overview
  • Designing Time Dimensions
  • Designing Scenario Dimensions
  • Outline Calculations
  • Designing Accounts Dimensions
  • Testing Outline Calculations
  • Creating Member Aliases
  • Dimension Types
  • Creating Period-to-Date Totals
  • Dynamic Calc Members
  • Enhancing Accounts Dimensions
  • Optimizing Data Storage
  • Attribute Dimensions Overview
  • Adding Attribute Dimensions to Outlines
  • Design Considerations
Creating Basic & Advance Dimension Build Rules Files
  • Rules Files Overview
  • Creating Dimension Build Rules Files
  • Configuring Dimension Maintenance Settings
  • 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
  • Free form Data Loading
  • Data Loading using Rule file
  • Creating Data Load Rules Files
  • Selecting and Rejecting Records
  • Capturing New Members
Working with Essbase Integration Service
  • Creating OLAP Model and Meta-outline
  • Loading Metadata and Data using Oracle Database
  • Working with Drill through reports
Working with Essbase Studio.
  • Essbase Studio Deployment Architecture
  • Data Source Connections
  • Metadata Elements and Alias Sets
  • Working with Minischemas
  • Hierarchies
  • Cube Schemas
  • Essbase Models
Working with Essbase Spreadsheet client
  • Configuring Essbase Spread sheet client
  • Understanding various Essbase Client Options
  • Writing Queries, Member selections, Drill Down, Drill Up, Keep only remover only etc
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
  • Top-Down Calculation
  • Focusing Calculations with FIX Statements
  • Calculating Conditionally with IF Statements
  • Performance Considerations
  • Referencing Members Dynamically
  • Creating Calculation Variables
  • Developing and Testing Complex Calculation Scripts
  • Implementing a Script Development Process
  • Upper-Level Data Loads
  • Intelligent Calculation
Essbase Security Overview
  • Essbase Native Security
  • Global Access Security Layer
  • User and Group Security Layer
  • Application Access Type Security
  • The Essbase Security File
Optimizing Block Storage Caches
  • Optimizing the Database
  • Optimizing Caches
  • Setting RAM Caches
  • Cache Hit Ratios
Essbase Automation using MaxL
  • Understand MaxL script structure.
  • Automate Metadata, Data Load Process
  • Automate Calculation and consolidation process
  • Automate Data Export Using Report Script and Data Export Command
Essbase Optimization and Memory management
  • Optimizing the Database
  • Optimizing Caches
  • Setting RAM Caches
  • Cache Hit Ratios
Analyzing Text and Dates
  • Typed Measures Overview
  • Enabling Typed Measures
  • Creating Text Measures
  • Creating Date Measures
  • Viewing Typed Measures
  • Calculations Based on Typed Measures

Hyperion Planning

  • Hyperion Planning Overview
  • Creating Hyperion Planning Classic Application and EPMA Application Part I
  • Creating Hyperion Planning Classic Application and EPMA Application Part II
  • Dimension Overview and their properties
  • Loading Data and Calculate the Database
  • Setting up Security
  • Desigining Data Form
  • Entering Data in Data Form
  • Migrating Planning using LCM Ulitility[Setting Up Application Setting]
  • Creating Planning Task List
  • Planning Process Management
  • Working with Business Rule
Aggregate Storage Overview
  • Aggregate storage key characteristics and design considerations
  • Key differences between ASO and BSO design
  • Understanding the aggregate storage production cycle
  • Creating aggregate storage outline hierarchies
  • Loading Data
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
Course Id:
HYP001 
Course Fees:
301 USD