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

Drill rules

A drill assignment rule or drill rule is a rule that links cube cell areas with related or detailed data to be drilled-through to (the drill-to detailed or related data can reside in any existing TM1 cube on the same TM1 Server instance or reside in any ODBC accessible data, or really any data accessible through a TM1 TurboIntegrator process as discussed earlier).

Drill rules will launch (execute) the TI process that you specify for a specific cube cell area.


Unlike other TM1 rules, drill-rules do not require the addition of any supporting feeders specifically to make the drill work.

Area definition

As a quick review from an earlier chapter of this book (Chapter 4, Rules), each rule must have an area definition to define for Cognos TM1 which cell values to calculate with a rule. Using areas you can specify which calculations apply to different parts of a cube.

For example, specific calculations may vary from region to region. So, you may need to apply different rules based...