Home
All courses
Dashboarding/BI
Hyperion Essbase ($/Rs: Call us)

Instructor

OhioComputer Academy

Category

Dashboarding/BI

Hyperion Essbase ($/Rs: Call us)

10 Weeks

All levels

93 lessons

0 quizzes

20 students

Overview
Curriculum
Instructor

*signup for a free demo session. Contact us for fee details.

Curriculum

20 Sections
93 Lessons
10 Weeks

Expand all sectionsCollapse all sections

Essbase Overview
4
- 1.1
  Multidimensional Analysis
  30 Minutes
- 1.2
  Oracle’s Enterprise Performance Management System
- 1.3
  Oracle BI Suite Enterprise Edition Plus
  20 Minutes
- 1.4
  Production Environment Components
  15 Minutes
Designing Applications and Databases
5
- 2.1
  Block Storage Implementation Process
- 2.2
  Analyzing and Planning Implementations
  30 Minutes
- 2.3
  Creating Applications and Databases
  45 Minutes
- 2.4
  Creating Outline Structures
- 2.5
  Modifying Member Properties
Designing Data Descriptor Dimensions
6
- 3.1
  Data Descriptor Dimensions Overview
- 3.2
  Designing Time Dimensions
- 3.3
  Designing Scenario Dimensions
- 3.4
  Outline Calculations
- 3.5
  Designing Accounts Dimensions
- 3.6
  Testing Outline Calculations
Optimizing Data Descriptor Dimensions
6
- 4.1
  Creating Member Aliases
- 4.2
  Dimension Types
- 4.3
  Creating Period-to-Date Totals
- 4.4
  Dynamic Calc Members
- 4.5
  Enhancing Accounts Dimensions
- 4.6
  Optimizing Data Storage
Planning Dimension Designs
3
- 5.1
  Business View Dimensions Overview
- 5.2
  Combining Business Views
- 5.3
  Planning Dimensions with Label Outlines
Creating Basic Dimension Build Rules Files
3
- 6.1
  Rules Files Overview
- 6.2
  Creating Dimension Build Rules Files
- 6.3
  Configuring Dimension Maintenance Settings
Creating Advanced Dimension Build Rules Files
4
- 7.1
  Advanced Dimension Build Rules Files Overview
- 7.2
  Creating Shared Members
- 7.3
  Manipulating Fields
- 7.4
  Creating User-Defined Attributes
Loading Data
4
- 8.1
  Data Load Overview
- 8.2
  Creating Data Load Rules Files
- 8.3
  Selecting and Rejecting Records
- 8.4
  Capturing New Members
Getting Started with Smart View
4
- 9.1
  Smart View Overview
- 9.2
  Configuring Data Sources
- 9.3
  Creating Ad Hoc Reports
- 9.4
  Setting the Point of View
Creating Reports with Smart View
4
- 10.1
  Manipulating Multidimensional Data
- 10.2
  Updating Essbase Data
- 10.3
  Integrating Essbase Data with Microsoft Office
- 10.4
  Customizing the User Experience
Data Storage and Calculation
7
- 11.1
  Calculation Overview
- 11.2
  Database Calculation Order
- 11.3
  Data Block Fundamentals
- 11.4
  Data Blocks and the Index System
- 11.5
  Database Statistics
- 11.6
  Data Block Creation
- 11.7
  Database Calculation Process
Creating Calculation Scripts
3
- 12.1
  Calculation Script Organization
- 12.2
  Returning Correct Calculation Results
- 12.3
  Troubleshooting CALC DIM Processes
Controlling the Calculation Process
4
- 13.1
  Top-Down Calculation
- 13.2
  Focusing Calculations with FIX Statements
- 13.3
  Calculating Conditionally with IF Statements
- 13.4
  Comparing FIX and IF Calculation Processes
Analyzing Member Attributes
4
- 14.1
  Attribute Dimensions Overview
- 14.2
  Adding Attribute Dimensions to Outlines
- 14.3
  Design Considerations
- 14.4
  Creating Attributes with Rules Files
Analyzing Varying Attributes
3
- 15.1
  Varying Attributes Overview
- 15.2
  Creating Varying Attributes Overview
- 15.3
  Viewing Varying Attribute Data
Analyzing Text and Dates
5
- 16.1
  Typed Measures Overview
- 16.2
  Enabling Typed Measures
- 16.3
  Creating Typed Measures
- 16.4
  Viewing Typed Measures
- 16.5
  Calculations Based on Typed Measures
Online Analytical Processing Overview
6
- 17.1
  Data Transformation
- 17.2
  Multidimensional View of Information
- 17.3
  Dimensional Modeling
- 17.4
  Data Cubes
- 17.5
  Dimension Hierarchies
- 17.6
  OLAP Solutions
Essbase architecture, components, and production cycle
6
- 18.1
  Outlines
- 18.2
  Load Rules
- 18.3
  Calculation Scripts
- 18.4
  Aggregations
- 18.5
  Essbase Spreadsheet Add-in
- 18.6
  Smart View
Block Storage Data Structure
4
- 19.1
  Data Blocks and the Index System
- 19.2
  Block Storage Database Statistics
- 19.3
  Data Block Creation
- 19.4
  Database Calculation Process
Backing Up and Recovering Essbase Databases
8
- 20.1
  About Backup and Recovery
- 20.2
  Backup Options
- 20.3
  Export Considerations
- 20.4
  Subset Data Export Capability
- 20.5
  Database Recovery
- 20.6
  Task Automation
- 20.7
  Automating Tasks Using MaxL
- 20.8
  MaxL Statements and Syntax

OhioComputer Academy

Leave A Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact 1-614-927-0647(USA)

+91-979-118-6364(India)

hello@ohiocomputeracademy.com