Book Image

Oracle Essbase 9 Implementation Guide

Book Image

Oracle Essbase 9 Implementation Guide

Overview of this book

The hot new data analysis trends involve business intelligence and analytics. The technology that supports business intelligence and analytics better than anything else is today's multidimensional OLAP technology ñ and there is none better than Oracle Essbase! Although storing data in a cube and developing analytical applications leaves many people grasping for understanding, especially if their experience is with relational databases, embracing OLAP technology will pay big dividends in the long run. It's easy to develop multidimensional analytic OLAP solutions when you have got this Oracle Essbase book to hand. It is a step-by-step guide to timeless Essbase fundamentals, which takes you from a basic software installation through to launching a fully functioning Essbase database cube. This book will guide you through every stage of installing Oracle's Essbase software on your analytic server, the Essbase Administration Services client, and the client software itself. You will learn, in easy-to-understand language, the concepts of multidimensional database technology as you are taken step by step through building an actual Essbase application complete with database, database calculation scripts, and database report scripts. Once you have your system built and functional, the next course of instruction covers the available automation features included in your Essbase software package and how to use them. These chapters alone are worth the price of admission! As an IT professional you quite rightly have a desire to understand multidimensional OLAP ñ this book gives you that understanding. Should you wish to embark on an exciting career as an Essbase developer/administrator, this book provides a fantastic foundation from which to grow. Best of all, this book is filled with the tips and tricks that you can only get from many years and countless hours spent playing with Essbase. You get them all in just the time it takes you to complete this book.
Table of Contents (18 chapters)
Oracle Essbase 9 Implementation Guide
Credits
About the Authors
About the Reviewer
Acknowledgements
Preface

Installing the Essbase Add-in for Microsoft Excel


We have installed Essbase analytic server and EAS and we are left only with the reporting tool. It's well known that most financial analysts are also Microsoft Excel experts (or believe they are). When you tell them the reporting tool they will be using is Microsoft Excel-based, you are almost certain to get your budget approved.

  1. 1. To get started, double-click on the Essbase client executable file supplied by Oracle. Huh? This screen looks familiar from the previous component installations. You know which language to select. Click OK when you are ready.

  2. 2. This step welcomes you to the installation of the Essbase client software, also known as the Essbase add-in. As usual, there are some recommendations and warnings, please click Next after you finish reading it.

  3. 3. In this step, as we have suggested before, please select the same country that you have chosen in the Essbase analytics server and EAS installations. In case you have forgotten, keeping the country variable consistent across all installed components will make your life easier. Once done, please click Next.

  4. 4. This step asks to read and agree to the EULA. Read it carefully, and if you agree and wish to continue, click Next.

  5. 5. This step has already detected the Hyperion home directory from a previous installation. If your home directory is different, select your home directory and then click Next.

  6. 6. In this step, you are creating a directory for the Essbase client installation. Please choose c:\Hyperion and click Next when you are done.

  1. 7. We recommend that you select Typical and click Next. As stated earlier, the Typical installation gives you all of the tools included with the software. Choosing Custom will really only provide more choices for samples.

  2. 8. This step requires you to select ESSLANG. The ESSLANG variable defines the locale of the computer. Just like before, please feel free to select English.

  3. 9. This step summarizes all of the components required for the client installation as well as the path. Please look them over carefully. Most importantly, verify the path and that it is correct with consideration to the other components installed on this machine. Click Next when you are satisfied that everything is correct.

  4. 10. This steps shows that the Essbase client installation is in progress and we recommend you not to take any more coffee breaks since you have already taken a lot of breaks in the previous installations.

    Note

    STATUTORY WARNING:

    Too much coffee drinking is injurious to health!

    When the installation wizard finishes installing the software, the Next button will be enabled. Please click Next to continue.

  5. 11. This step tells you that the Essbase client installation is completed. Click Next when you are ready.

  6. 12. Now, open Microsoft Excel. As it loads you should briefly see a HYPERION ESSBASE SPREADSHEET ADD-IN splash screen (shown below). Once Microsoft Excel has finished loading, you should see a brand new menu pick named Essbase that is usually located between the Window pick and the Help pick. This tells you that the Essbase client is successfully installed.