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

Dimension load


In this section, we'll go by one by one dimension and understand the metadata load process of all dimensions. To start with, we'll pick the Accounts dimension.

Account Dimension

We had already gone through individual field/ setting of account dimension member in the previous Chapter 6, Settings, to name few of the fields, they are Alias, Data Storage, Data Type, and so on. Here, in this section, we are loading metadata that is, members of account dimension members through a flat file with the help of the utility. The flat file should also have the information of member properties such as Alias, Data storage, Data type, and so on. Hence, we not only load members of a dimension. But also load their properties

Before we can create a flat file, we should be able to understand parent-child relationship. As we know, everything in our hierarchies is going to be in relationships. As smart consulting team, we generally make a parent-child relationship before we create a flat file to load...