Hyperion Essbase Online Training Course
Online Analytical Processing Overview
● Data Transformation● Multidimensional View of Information
● Multidimensional Data Model
● OLAP Solutions
Analytic Services Overview
● Business Performance Management● Hyperion System 9 Overview
● Hyperion Analytic Solution
● Analytic Services
● Analytic Administration Services
Creating Multidimensional Databases
● Life Cycle of the Essbase Analytics Database Design● Creating Essbase Analytics Applications and Databases
● Creating and Managing Database Outlines
● Creating Time, Accounts, and Scenario Dimensions
Enhancing Database Outlines
● Creating Business-view Dimensions● Specifying Consolidation Operators and Defining Calculations
● Setting Time Balance Properties
● Creating Label-Only and Shared Members
● Defining Duplicate Member Names and Member Aliases
● Creating Attribute Dimensions
Loading Data
● Data Load Options● Loading Data from Flat Files
● Performing Free-Form Data Loads
● Loading Data with Rules Files
● Loading Data from SQL Data Sources
Calculating the Essbase Analytics Database
● Outline Calculations● Calculation Scripts
● Two-Pass Calculations
● Dynamic Calculations
● Dynamic Time Series
Retrieving Data
● Smart View Overview● Connecting to the Analytic Server
● Retrieving Multidimensional Data into Two-dimensional Spreadsheet Reports
● Navigating Through Spreadsheet Reports
● Manipulating Multidimensional Data
● Installing the Web Server
● Smart View Options
Advanced Spreadsheet Reporting
● Updating Data on the Analytic Server● Creating Free-Form Reports
● Selecting Members
● Creating Reusable Queries
● Extending the Spreadsheet Environment with Visual Explorer
Storing Analytic Data
● Data Storage Options● Block Storage
● Block Storage
● Aggregate Storage
Integration with BI+ Reporting Tools
● BI+ Architecture● Workspace Overview and User Interface
● Browsing the Repository
● Working with BI+ Content
● Previewing Financial Reports
● Grouping Financial Reports into Books
Extending Analytic Reporting Using Web Analysis
● Web Analysis Overview● Viewing Web Analysis Documents in Workspace
● Analyzing Query Results in Workspace
● Creating Web Analysis Documents
