Hyperion(r) SQL Interface Guide | Information Map | ||
Show | Previous | Next |
Hyperion(r) SQL Interface Guide | Information Map | ||
Hide | Previous | Next |
Hyperion(r) SQL Interface Guide | Information Map |
Show | Previous | Next |
Hyperion(r) SQL Interface Guide | Information Map |
Hide | Previous | Next |
This preface provides information about Hyperion® and this document:
Use this guide to help you load data from SQL, relational, and flat-file data sources into an Essbase® database. This guide explains the SQL Interface features and options, and contains the concepts, processes, procedures, formats, tasks, and examples that you need to use the software.
This guide is primarily for database administrators who install SQL Interface, configure Open Database Connectivity (ODBC) drivers, and load relational data into Essbase databases.
To use the information in this book, you need an understanding of relational databases and ODBC drivers, and knowledge of Essbase database outlines.
This guide provides examples based on an application called Sample, which is provided with Essbase, and a dBASE file called budget.dbf, which is provided with the SQL Interface software in the /app/SQL_Samp directory of your Essbase installation.
The individual who installs the server is responsible for making Sample available to end users. Sample contains three databases: Basic, Interntl, and Xchgrate. Contact your Essbase system administrator if any of the following problems occur when you connect to OLAP Server:
You can review a brief introduction to the Sample application in the Essbase Installation Guide, and a longer discussion in the Essbase Database Administrator's Guide, Volume I.
Use this table to understand the conventions used in this guide:
If you do not find what you need in this book, refer to the Essbase Information Map to locate other documents provided with Essbase. The Essbase Information Map is in the root directory of your installation CD or in the \docs directory of your Essbase installation. The file is essdocs.htm .
For answers or comments on technical documentation, contact Hyperion Essbase Technical Publications:
Clients in Europe, Asia, or other areas should call their local support number.
If Hyperion Software is not your software provider, contact your software provider's Technical Support hotline.
If you have a current maintenance contract with Hyperion Software, you can gain access to Hyperion's programs, Tech Tips, on the World Wide Web. Using Tech Tips, you can get answer to frequently asked questions, optimization, and platform issues using your browser. Contact your Hyperion Essbase system administrator for your company's access code to Tech Tips.
You can also visit these Hyperion Solutions sites for more information:
To access the documentation from the Hyperion Solutions Web site:
Tip: Enter your user name and password, and click Login. If you do not have a user name and password, click New User Registration on the left side of the login page to request them.
To install the entire documentation suite unrelated to a product installation from the Download Center or www.essbase.com:
To order printed documentation:
In addition to providing the documentation and online help, Hyperion offers the following support for product information:
For more information on how to order printed documentation, contact your local consulting services office, call Hyperion Solutions Customer Support at 877-901-4975, or visit the Hyperion site: http://www.hyperion.com.
Hyperion offers a variety of training options, including instructor-led training, custom training, and eTraining. This education covers all Hyperion applications and technologies and is geared to administrators, end users, and information systems (IS) professionals.
Instructor-led training is delivered in formats and in locations suited to Hyperion's diverse, global customers. Hyperion Authorized Training Centers are certified to deliver courses developed by Hyperion. Custom Education Services-training on the configured and tailored applications that employees use on the job-is another option to enhance user productivity and to ensure smooth day-to-day operations. A service called eTraining-including computer-based training, Web-based training, and interactive Virtual Classroom training-provides a cost-effective means of giving users a hands-on introduction to product features and functions. Computer-based training (CBT) and Web-based training (WBT) provide high-quality, self-paced training at the user's convenience, regardless of location.
For more information about training, contact your Regional Education Manager or visit the Hyperion Solutions Web site at http://www.hyperion.com to see a list of all training classes.
Hyperion Consulting Services assists customers in maximizing the use of, and the return on investment in, Hyperion products. Experienced Hyperion consultants and Hyperion Alliance Partners assist organizations in tailoring solutions to their particular requirements, such as reporting, analysis, modeling, and planning. Specific services include implementation consulting, custom business solutions, data integration, and technical consulting. Additionally, Hyperion offers a variety of Services Packages and Reviews.
For more information about Consulting Services, Services Packages and Reviews, as well as the services offered by Alliance Partners, contact your local consulting services representative, or visit the Hyperion Solutions Web site at http://www.hyperion.com to see a list of all Hyperion Alliance Partners.
Hyperion provides Web-based and telephone support to ensure that clients resolve product issues quickly and accurately. This support is available for all Hyperion products at no additional cost to clients with a current maintenance agreement.
![]() Copyright © 2002 Hyperion Solutions Corporation. All rights reserved. http://www.hyperion.com |