#### 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
Drill-through
Virtual and Lookup Cubes
Time Considerations
Data Presentation and Reporting

## Aggregations

One of the key things to understand is that TM1 will quickly and efficiently aggregate numeric element values for your reporting.

For example, consider a simple calculation such as aggregating (or rollup) the values of a group of accounts into one amount. This is accomplished through aggregation. Aggregation is automatically applied in TM1 while building a dimension using something called hierarchies.

A hierarchy is a way to organize data at different levels of aggregation.

It is important to understand that aggregation calculations will be based upon each element's "weight". IBM refers to this as the element's weight fa﻿ctor. Weight factors determine the contribution of an element to a consolidation.

The default element weight is one.

Just about any weight factor can be assigned to an element and it is not uncommon for an element to have a negative weight factor, causing it to be subtracted from the total aggregation amount. Therefore, to show a negative value, a developer can...