Essbase OLAP Access Pack Tutorial Guide

Online analytical processing (OLAP) describes a software technology extracts and presents multidimensional data from different points of view. The Essbase OLAP Access Pack is a tool that lets BusinessObjects users retrieve data from Hyperion Essbase multidimensional servers. An Essbase OLAP server is a data manipulation engine that supports and operates on multidimensional data structures. These data structures are represented by objects that you manipulate with the Essbase OLAP Access Pack.This guide describes the ESSBASE OLAP ACCESS PACK, a data provider that lets BUSINESSOBJECTS users access Essbase multidimensional servers.

Contents of this Essbase OLAP Access Pack Tutorial Guide
Chapter 1 Introducing the Essbase OLAP Access Pack 15
What You Can Do with the Essbase OLAP Access Pack . . . . . . 17
How BusinessObjects Integrates with the Essbase OLAP Access Pack . . . 18
The BusinessObjects Environment for the Essbase OLAP Access Pack . . 22
Chapter 2 OLAP Concepts 29
Accounts . . . 31
Aggregation . 31
Ancestor . . . . 32
Cell 32
Child . . . . . . . 32
Database Outline . . . . . 32
Descendant . 33
Dimension . . 33
Drill Down/Up 33
Generation, Hierarchical . . . . . . . 34
Hierarchy . . . 34
Level, Hierarchical . . . . 35
Measure . . . . 35
Member, Dimension . . . 35
Nesting . . . . . 36
OLAP (Online Analytical Processing) . . . . . 36
Parent . . . . . 37
Sibling . . . . . 37
Slice and Dice . . . . . . . 37
Chapter 3 Getting Started 39
The Document Creation Process 41
Step 1: Selecting a Report Layout and Connecting to an Essbase
OLAP Server 42
Step 2: Selecting Your Initial Data 45
Step 3: Fine-Tuning your Initial Data . . . . . . 50
Step 4: Selecting a Level of Detail . . . . . . . 54
Step 5: Selecting Report Options 59
Step 6: Generating the BusinessObjects Report . . . . . 65
Step 7: Refreshing and Editing Documents 67
Chapter 4 Advanced Techniques 69
Power Users and Basic Users . . . 71
Modifying Restricted Data in a Document . . 72
Creating an Interactive Document 75
Working with Differences between Data Models . . . . . 79
Advanced Techniques for the Generated Report . . . . 88
Index 89

View the original article here