Book Image

IBM Cognos 8 Planning

Book Image

IBM Cognos 8 Planning

Overview of this book

Business planning is no longer just about defining goals, identifying critical issues, and then mapping out strategies. In today's dynamic and highly competitive business environment, companies with complex business models want their abstract strategies turned into discrete, executable plans. They want information from the field to reach decision makers in real-time so that they can fine-tune their plans as events unfold. IBM Cognos 8 Planning offers just that. This book provides you with everything you need to know for building planning models using IBM Cognos 8 Planning. After reading this book, you can begin your journey into model building bringing with you a perspective that comes from three of the most seasoned IBM Cognos Planning consultants in the business. In this book, you will learn how to build planning models using IBM Cognos Planning's modeling tool, Analyst. We introduce you to key objects in Analyst that let you define, store, and move data. Then we show how you can deploy the model to hundreds or thousands of users using IBM Cognos Planning's web-based tool, Contributor. We demonstrate some of the things you can do as an administrator and as a user. Finally, we show the automation tools that you can use to maintain and support your models. As we go through this, we will share with you tips and tricks and insights from our experience with real implementations.
Table of Contents (23 chapters)
IBM Cognos 8 Planning
Credits
About the Authors
Acknowledgment
About the Reviewers
Preface
5
Defining Data Structures: D-List
Index

Designing the model template in Analyst


A planning model is a set of Analyst objects whose purpose is to generate specific plans using a variety of data inputs, assumptions, and calculations. We will discuss the Analyst objects in greater detail in Chapters 4 through 7. In practice, a model is named after the output it produces. An output can be a specific budget for product lines or it can be a category of expenses consisting of several general ledger accounts, such as payroll.

Once you have identified the model output, break it down into its inputs, assumptions, and calculations. For example, a salary plan may be the outcome of the inputs of employees and positions, their current salary, earned merit increases, and bonuses. The salary for newly-hired staff may be assumed based on their position. To produce the salary plan, the model would calculate the merit increases and bonuses for each employee by multiplying the salary by the merit and bonus percentages and then by adding the results...