Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
IBM Cognos 8 Planning

You're reading from  IBM Cognos 8 Planning

Product type Book
Published in Jul 2009
Publisher Packt
ISBN-13 9781847196842
Pages 424 pages
Edition 1st Edition
Languages

Table of Contents (23) Chapters

IBM Cognos 8 Planning
Credits
About the Authors
1. Acknowledgment
About the Reviewers
2. Preface
1. Planning with IBM Cognos 2. Getting to know IBM Cognos Tools 3. Understanding the Model Development Process 4. Understanding the Analyst Environment 5. Defining Data Structures: D-List 6. Storing Planning Data: D-Cube 7. Moving Planning Data: D-Links 8. Understanding the Contributor Environment 9. Building, Configuring, and Updating the Contributor Application 10. Securing and Controlling Contributor Web Client Template/Application 11. Importing Data into a Contributor Application 12. Working with the Contributor Web Client 13. Reporting Planning Data—Publish and BI Integration 14. Maintaining Analyst Models 15. Maintaining Contributor Applications 16. Maintaining Security 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...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}