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

Essbase and PBCS training

Oracle Essbase and Planning and Budgeting Cloud Service Training

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

Get started using Oracle Planning and Budgeting Cloud

  • Use Oracle Planning and Budgeting Cloud to complete the business budgeting and forecasting process
  • Configure, test and maintain the components of a Planning application
  • Set up the Planning application with dimensions, aliases, currencies and time periods
  • Set up Planning and Budgeting scenarios and versions
  • Load metadata and data
  • Implement security and manage users
  • Implement business rules and processes
  • Manage the approval process, which includes moving a plan through the budget review-and-approval process
  • Create and enhance forms for user input
Course Id:
Course Fees:
301 USD