Book Image

Getting Started with Oracle Hyperion Planning 11

By : Enti Sandeep Reddy
Book Image

Getting Started with Oracle Hyperion Planning 11

By: Enti Sandeep Reddy

Overview of this book

<p>Oracle Hyperion Planning is one of the many products in the Oracle Enterprise Performance Management software suite, an industry-leading Business Intelligence software package. The primary focus of the Hyperion Planning product is to provide a planning, budgeting, and forecasting solution that helps you manage and coordinate all your business planning and budgeting needs.</p> <p>This book is a practical guide to implementing a Hyperion Planning solution in your organization, which addresses all your planning, budgeting, and forecasting needs.</p> <p>You will begin with the installation of Hyperion Planning and then design Planning applications as per some example user requirements. You will then learn to create the planning objects. The book moves on to explaining important concepts within Hyperion Planning such as data forms, task lists, business rules, validation rules, and workflows, with the help of many real-world examples to maximize your learning. Towards the end of the book, you will cover user provisioning and access rights and budget process management.</p>
Table of Contents (23 chapters)
Getting Started with Oracle Hyperion Planning 11
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Configuration


In this section, we will learn the following:

  • Database preparation

  • Configuring Oracle EPM in a single machine

  • Configuring of Oracle EPM

  • Configuration of Oracle EPM in a multi-machine distributed environment

Database preparation

We shall discuss the following:

  • Oracle database creation

  • Oracle database schema creation

Before we start configuring Oracle EPM products, we need to install an RDBMS. The popular RDBMS vendors such as Oracle Database, Microsoft SQL Server, and IBM DB2 are all supported RDBMS.

For more information of the version and compatibility of the RDBMS, refer to the System Requirement section. In our case, assume that we have installed Oracle database.

Each Oracle EPM System product would require to be configured with database. We can use one single database for all the products to configure at a time or we can use different databases for each product. In our case, we will create an Oracle database and multiple schemas for each product of Oracle EPM System.

We will create...