BISP 

60% Complete Courses » Essbase with Data Management on cloud
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


Essbase with Data Management on cloud

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

Data Management On Cloud
1) Data Management on Cloud Overview
2) Processing Data Overview
3) Navigating in Data Management
4) Preparing Data Management for Integrations
  • Integration Setup Overview
  • Defining Profiles
  • Registering Target Applications
  • Setting Up Import Formats for File Systems
5) Import Formats Overview
6) Creating Import Formats
7) Loading Data to PBCS
8) Loading Data to EPBCS
9) Loading Data to FCCS

Course Id:
HYP018 
Course Fees:
301 USD