This guide provides you with all the information that you need toimplement, design, and maintain an optimized Essbase 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.
Audience
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 14 contain 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 34 contain information on building dimensions and loading data, calculating data, and retrieving data.
Chapters 35 through 56 contain 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 (Volume IV) contain information on aggregate storage databases.
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.
In the Login ID and Password text boxes, enter your assigned login ID name and password. Then click Login.
If you are a member on multiple Hyperion Download Center accounts, select the account that you want to use for the current session.
Follow the on-screen instructions.
Perform one of the following actions:
To access documentation online, from the Product List, select the appropriate product and follow the on-screen instructions.
To order printed documentation, from the Information section in the left frame, select Order Printed Documentation, then follow the on-screen instructions
To order printed documentation if you do not have access to the Hyperion Download Center:
In the United States, call Hyperion Solutions Customer Support at 877-901-4975.
From outside the United States, including Canada, call Hyperion Solutions Customer Support at 203-703-3600. Clients who are not serviced by support from North America should call their local support centers.
Conventions
The following table shows the conventions that are used in this document:
Table i: Conventions Used in This Document
Item
Meaning
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
Bold in procedural steps highlights major interface elements.
CAPITAL LETTERS
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.
Exampletext
Courier font indicates that the example text is code or syntax.
Courieritalics
Courier italic text indicates a variable field in command syntax. Substitute a value in place of the variable shown in Courier italics.
ARBORPATH
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 an alphabet. 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 on the Hyperion Web site at http://www.hyperion.com.
Education Services
Hyperion offers instructor-led training, custom training, and eTraining covering all Hyperion applications and technologies. Training is geared to administrators, end users, and information systems (IS) 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. We value your opinions on this documentation and want to hear from you. Send us your comments by clicking the link for the Documentation Survey, which is located on the Information Map for your product.