Book Image

IBM Cognos TM1 Developer's Certification guide

By : James D. Miller
Book Image

IBM Cognos TM1 Developer's Certification guide

By: James D. Miller

Overview of this book

IBM Cognos TM1 is enterprise planning software that provides a complete, dynamic environment for developing timely, reliable and personalized forecasts and budgets. It is a real time, in memory tool that helps any sized business perform planning, budgeting and forecasting as well as other financial exercises. This book prepares you to master COG-310 certification using an example-driven method that is easy to understand. The IBM Cognos TM1 Developer's Certification guide provides key technical details and background to clear the current IBM Cognos TM1 Developer (test COG-310) certification exam. This certification book covers all the modules of the certification clearly and in depth. The initial chapters cover in detail the components that make up Cognos TM1 and designing and creating dimensions and cubes. The book then dives deep into basic and advanced scripting using TurboIntegrator and then we learn to understand and write basic Rules. We then learn about the drill-through functionality of TM1, virtual and lookup cubes and lastly Time, and presenting and reporting data
Table of Contents (15 chapters)
IBM Cognos TM1 Developer's Certification Guide
About the Author
About the Reviewer
Free Chapter
The Components of TM1

Data sources available with TurboIntegrator

Using TurboIntegrator, you can import data from the following data sources:

  • Industry standard comma-delimited (CSV) text files including ASCII files

  • Information stored in relational databases (accessible through an ODBC data source)

  • Other OLAP cubes, including Cognos TM1 cubes and views.

  • Microsoft Analysis Services

  • SAP via RFC, creating TI processes

TI's basic object is the process, which can be created by an administrator. Multiple processes can be linked together as chore objects, which allow the processes to be executed in sequence as well as to schedule processes to run for a specific time and/or interval. More recent versions of TM1 also allow processes to be called from other processes, allowing a non-sequential execution path.

To create a new TI script you can use TM1 Server Explorer. You have to just right-click on Processes and then select Create New Process. TM1 then opens the TurboIntegrator dialog showing a new, blank process ready for...