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

Overview of D-List


In the previous chapter, we defined D-List as a list of data attributes that define what data will be included in the model, how this data is displayed, what values it can take, and what operations can be performed on these values. Think of D-List as the items on the rows and columns of a spreadsheet, or the fields in a table. When you create the field, you start by defining its attributes. With the D-list, you do the same thing. You determine what data will be entered by the user, what will be pre-populated from other data sources, and what will be calculated.

The following is an example of a Profit and Loss D-List:

Creating the D-List

There are several ways in which you can create a D-List. You can create it manually by typing the D-List items or copying and pasting the items from another source such as Excel. Or you can import the items from a data source, such as a database, text file, D-Cube, or another D-List. You can connect to any ODBC data source and update the D...