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

Importing data from external files/databases


The Contributor import feature is the primary method of loading data into the Contributor database from external sources. The Contributor database is created when you create an application. This database contains many tables which support the application, including an import table for each cube.

Understanding the import process—concepts

In this section, we will explain how Contributor imports data from external sources. You can find step-by-step instructions of data import in the next section.

Contributor transfers data from external sources to the Contributor database, or the Contributor Web Client, using a four-step process:

  • Copy: In this step, Contributor copies the data file from a local PC to the Contributor Administration Server.

  • Load: Contributor loads the data file from the Contributor Administration Server to the application's import tables (im_table) using the database bulk load utility program.

  • Prepare: The Contributor Calculation Engine...