Hyperion Essbase 9.3
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