Hyperion Essbase 9.3 Fundamentals

Course Overview

In this course, you become familiar with Analytic Services technologies, which enable quick and easy implementation of analytical solutions and transform data into actionable information. You learn how to set up the Analytic Services environment, build a multidimensional database, and load and retrieve data. You also learn how Analytic Services integrates with other BI+ modules to manage business functions. Exercises provide hands-on practice.

Audience

Business Analysts

Prerequisites

• Basic knowledge of Microsoft Windows and Excel
• Basic accounting concepts

Skills Gained

Completion of this course will give delegates the skills to:

• Describe Online Analytical Processing and the multidimensional data model
• Describe the Analytic Services environment and architecture
• Create a multidimensional database using Analytic Administration Services
• Explain Analytic Services data storage options
• Integrate Analytic Services with Microsoft Office using Smart View
• Extend analytic and reporting capabilities by integrating Analytic Services with BI+ reporting tools

Course Outline

• 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
• 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

Follow On Courses

• Hyperion Essbase Analytics 9.3 Bootcamp
• Hyperion Essbase 9.3 for System Administrators
• Hyperion Essbase Analytics 9.3: Calculate Databases
• Hyperion Integration Services 9.0: Create & Manage Data Structures

Hyperion Essbase 9.3 Fundamentals / D50715GC10