Welcome to the Hyperion® System™ 9 BI+ Analytic Services Database Administrator's Guide. This preface discusses the following topics:



Document Structure

Where to Find Documentation


Additional Support

Documentation Feedback


This guide provides information that you need to implement, design, and maintain an optimized Analytic Services multidimensional database. It explains the Analytic Services features and options, and contains the concepts, processes, and examples that you need to use the software.


This guide is for database administrators or system administrators who are responsible for designing, creating, and maintaining applications, databases, and database objects (for example, data load rules, and calculation scripts).

Document Structure

This document contains the following information:

Chapters 1 through 14contain information on designing and creating Analytic Services databases, including information on converting currencies, partitioning applications, and accessing relational data using the hybrid analysis feature.

Chapters 15 through 34contain information on building dimensions and loading data, calculating data, and retrieving data.

Chapters 35 through 56contain information on designing and managing a security system, maintaining, backing up, and optimizing Analytic Services databases, and includes a glossary of key terms and their definitions.

Chapters 57 through 60 contain information on aggregate storage databases.

Limits describes size and quantity limits that you may encounter while working with Analytic Services.

Handling Errors and Troubleshooting Analytic Services describes tools that you can use to diagnose errors, and suggests methods for correcting some errors.

Estimating Disk and Memory Requirements helps you estimate disk and memory requirements for block storage databases.

Managing Shared Services Models explains Shared Services models as they are shared between multiple Hyperion products.

Using ESSCMD describes the ESSCMD command-line interface that is used to perform operations interactively or through batch or script files.

Glossary contains a list of key terms and their definitions.

Where to Find Documentation

All Analytic Services documentation is accessible from the following locations:

The HTML Information Map is located at installation_directory\docs\esb_infomap.htm, where installation_directory is the directory in which you have installed the Analytic Services documentation.

Online help is available from within Analytic Administration Services Console. After you log on to the console, you can access online help by clicking the Help button or selecting Help from the menu bar.

The Hyperion Solutions Web site is located at

The Hyperion Download Center can be accessed from or from


To access documentation from the Hyperion Download Center:


Go to the Hyperion Solutions Web site and navigate to Services > WorldWide Support > Download Center.

Note:   Your Login ID for the Hyperion Download Center is your e-mail address. The Login ID and Password required for the Hyperion Download Center are different from the Login ID and Password required for Hyperion Support Online through If you are not sure whether you have a Hyperion Download Center account, follow the on‑screen instructions.


In the Login ID and Password text boxes, enter your e-mail address and password.


In the Language list box, select the appropriate language and click Login.


If you are a member on multiple Hyperion Solutions Download Center accounts, select the account that you want to use for the current session.


To access documentation online, from the Product List, select the appropriate product and follow the on‑screen instructions.


The following table shows the conventions that are used in this document:

Conventions Used in This Document  
Arrows indicate the beginning of procedures consisting of sequential steps or one-step procedures.
Brackets []
In examples, brackets indicate that the enclosed elements are optional.
Bold in procedural steps highlights major interface elements.
Capital letters denote commands and various IDs. (Example: CLEARBLOCK command)
Ctrl + 0
Keystroke combinations shown with the plus sign (+) indicate that you should press the first key and hold it while you press the next key. Do not type the plus sign.
Ctrl+Q, Shift+Q
For consecutive keystroke combinations, a comma indicates that you press the combinations consecutively.
Example text
Courier font indicates that the example text is code or syntax.
Courier italics
Courier italic text indicates a variable field in command syntax. Substitute a value in place of the variable shown in Courier italics.
When you see the environment variable ARBORPATH in italics, substitute the value of ARBORPATH from your site.
n, x
Italic n stands for a variable number; italic x can stand for a variable number or a letter. These variables are sometimes found in formulas.
Ellipses (...)
Ellipsis points indicate that text has been omitted from an example.
Mouse orientation
This document provides examples and procedures using a right-handed mouse. If you use a left-handed mouse, adjust the procedures accordingly.
Menu options
Options in menus are shown in the following format. Substitute the appropriate option names in the placeholders, as indicated.
Menu name > Menu command > Extended menu command
For example: 1. Select File > Desktop > Accounts.

Additional Support

In addition to providing documentation and online help, Hyperion offers the following product information and support. For details on education, consulting, or support options, click the Services link at the Hyperion Solutions Web site.

Education Services

Hyperion offers instructor-led training, custom training, and e-Learning covering all Hyperion applications and technologies. Training is geared to administrators, end users, and information systems professionals.

Consulting Services

Experienced Hyperion consultants and partners implement software solutions tailored to clients' particular reporting, analysis, modeling, and planning requirements. Hyperion also offers specialized consulting packages, technical assessments, and integration solutions.

Technical Support

Hyperion provides enhanced electronic-based and telephone support to clients to resolve product issues quickly and accurately. This support is available for all Hyperion products at no additional cost to clients with current maintenance agreements.

Documentation Feedback

Hyperion strives to provide complete and accurate documentation. Your opinion on the documentation is of value, so please send your comments by going to