Every organization is aiming a Business Intelligence solution to help grow their business and to take mission critical decisions. This in-demand program helps you in pursuing career as Business Intelligence Professional with an overall view on organization’s standing, answering all vital questions about financial gains and losses, areas for improvement and product performance.
Students will learn Oracle Hyperion Suite of products like:
- Hyperion Essbase
- Hyperion Planning and Oracle Data Integrator
Prerequisites:
Familiarity in using Windows OS and MS Office and Good to have accounting knowledge.
Course Content:
Hyperion Essbase
- 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
- Outline Calculations
- Designing Accounts Dimensions
- Testing Outline Calculations
- Optimizing Data Descriptor Dimensions
- Creating Member Aliases
- Dimension Types
- Creating Period-to- Date Totals
- Dynamic Calc Members
- Enhancing Accounts Dimensions
- Optimizing Data Storage
- Developing Dimension Designs
- Business View Dimensions Overview
- Attributes in Database Design
- Combining Business Views
- Developing Label Outlines
- 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
- Top-Down Calculation
- Focusing Calculations with FIX Statements
- Calculating Conditionally with IF Statements
- Performance Considerations
- Referencing Members in Calculations
- Referencing Members Explicitly
- Referencing Members Dynamically
- Creating Calculation Variables
- Developing and Testing Complex Calculation Scripts
- Implementing a Script Development Process
- Upper-Level Data Loads
- Intelligent Calculation
- Normalizing Data
- Allocating Data
- Planning Data Normalization
- Normalizing Rates and Drivers
- Copying and Clearing Data
- 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
- 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
Hyperion Planning
