Hyperion Essbase Database Administrator's Guide
Release 6.1

Contents

Introduction

Designing Hyperion Essbase Applications

Introduction to Hyperion Essbase

Steps for Implementing Hyperion Essbase

Multidimensional Concepts

Basic Architectural Elements

Designing a Single-Server Application

Designing Partitioned Applications

Building Hyperion Essbase Applications

Creating Applications and Databases

Creating and Changing Database Outlines

Setting Dimension and Member Properties

Working with Attributes

Creating and Managing Aliases

Linking Objects to Hyperion Essbase Data

Introducing Dynamic Dimension Building

Building Dimensions Using a Rules File

Estimating Disk and Memory
Requirements for a Database

Building and Maintaining Partitions

Designing and Building a Security System

Managing Security at Global and User Levels

Controlling Access to Database Cells

Security Examples

Loading Data

Introducing Data Loading

Setting up a Rules File to Manipulate Records

Manipulating Fields Using a Rules File

Performing a Data Load

Debugging and Optimizing Data Loads

Calculating Data

Introduction to Database Calculations

Developing Formulas

Examples of Formulas

Defining the Calculation Order

Dynamically Calculating Data Values

Calculating Time Series Data

Developing Calc Scripts

Examples of Calc Scripts

Developing Custom-Defined Calculation Macros

Developing Custom-Defined
Calculation Functions

Optimizing Calculations

Using Intelligent Calculation to Optimize Calculation

Reporting on Data

Quick Start to Report Scripts

Developing Report Scripts

Examples of Report Scripts

Optimizing Your Reports

Copying Data Subsets and
Exporting Data to Other Programs

Managing Multidimensional
Hyperion Essbase Data Storage

Introducing the Hyperion Essbase Kernel

Specifying Hyperion Essbase Kernel Settings

Ensuring Data Integrity

Designing and Building Currency Applications

Designing and Building
Currency Conversion Applications

Maintaining Hyperion Essbase Applications

Performing Interactive and
Batch Operations Using ESSCMD

Running Hyperion Essbase,
Applications, and Databases

Using Diagnostics to Monitor Performance

Working with Hyperion Essbase Files and
Cross-Platform Environments

Backing Up Data and Recovering Databases

Performance-Related Settings

Glossary

Index