#### 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
IBM Cognos TM1 Developer's Certification Guide
Credits
www.PacktPub.com
Preface
Free Chapter
The Components of TM1
Dimensions and Cubes
TurboIntegrator (TI)
Rules
Advanced Techniques for TI Scripting
Drill-through
Virtual and Lookup Cubes
Time Considerations
Data Presentation and Reporting

## Summary

In this chapter, we have discussed all of the background information pertaining to Cognos TM1 Rules that you need to know to prepare for the current IBM Cognos TM1 Developer (Test COG-310) certification exam.

### Two minute drill

• One of the powers of TM1 is its native ability to quickly consolidate values defined within a dimension. You can use TM1 Rules to perform simple to complicated calculations.

• Using TM1 Rules, you can perform the multiplication of cells to calculate totals based upon business rules.

• Using TM1 Rules, you can override automatic TM1 consolidations when needed.

• Using TM1 Rules, you can use data in one cube to perform calculations in another cube, or share data between cubes.

• Using TM1 Rules, you can assign the same values to multiple cells.

• Each and every TM1 rule is associated with an individual cube.

• To create a TM1 rule you can use the TM1 Rules Editor.

• The Rules Editor is a very simple text editor.

• Cognos TM1 Rules Editor is a .NET component and therefore, to run it on...