Hyperion Essbase Spreadsheet Add-in and Visual Explorer 7X Self-Study Course

Discover how Hyperion Essbase Spreadsheet Add-in and Hyperion Visual Explorer can turn your familiar spreadsheet application into an integrated online analytical processing (OLAP) client for Hyperion Essbase that enables you to transform data into insightful information. This self-paced, self-study course will teach you how to query and analyze data, create spreadsheet reports, and design advanced queries to address all your reporting needs. You will learn how to load and recalculate data to investigate what-if scenarios and extract valuable information that will help you make better and more informed business decisions.
Audience

• Business Analysts

Course Topics Describing Hyperion Essbase

• Basic Multidimensional Database Terminology
• Describing the Client-Server Environment
• Identifying the Users of Essbase

Introduction to Essbase Spreadsheet Add-in

• Components of Essbase Spreadsheet Add-in
• Connecting and Disconnecting from Essbase
• Accessing the Online Help

Retrieving and Manipulating Data

• Retrieving Data
• Changing the Report View
• Drilling In and Out of Data
• Focusing on Specific Data

Retrieving Data Based on Attribute Dimensions

• Querying Data Using Attribute Dimensions
• Drilling into Attribute Dimensions
• Creating Calculations with Attribute Dimensions

Creating Advanced Member Selections

• Selecting Members
• Defining Subset Selections

Creating Reports

• Formatting Data
• Creating Report Templates
• Creating Cascaded Reports

Creating Advanced Reports

• Preserving Spreadsheet Formulas
• Using Substitution Variables

Loading and Calculating Data

• Loading Data into the Essbase Server
• Calculating Data

Creating and Modifying Queries

• Creating Queries
• Opening and Modifying Saved Queries
• Preserving Spreadsheet Styles

Refining Queries

• Filtering Data
• Sorting Data
• Ranking Data

Creating Crosstab Reports

• Connecting to Data Sources
• Creating a Summary Table View of Data
• Filtering Dimension Members and Data Values

Presenting Data Graphically

• Creating Graphical Views of Data
• Creating Advanced Analysis Reports

Managing and Publishing Reports

• Creating and Saving a Workbook
• Creating Bookmarks for Reports
• Publishing and Sharing Reports

Course Objectives

• Retrieve and navigate through data
• Design queries and reports
• Add data analysis to reports and load data
• Create data visualizations and explore the interrelationships of data using Hyperion Visual Explorer