Oracle - Course Details

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

Oracle Course Description:
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.
Oracle Course Duration:
Self Placed
Oracle Course Target Audience:
Business Analysts
Oracle Course Prerequisite:
NONE
Course Content:
  • 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