#### 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
Credits
About the Author
About the Reviewer
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 the basics of Cognos TM1 virtual and lookup cubes focusing on what you will need to know and be comfortable with before taking the current IBM Cognos TM1 Developer (Test COG-310) certification exam. We have also looked at some practical examples.

In Chapter 8, Time Considerations, we will discuss the importance and use of the time dimension in Cognos TM1.

### Two minute drill

There are some important points about virtual and lookup cubes:

• There are four types of cubes in Cognos TM1. They are as follows:

• Standard cubes

• Control cubes

• Virtual cubes

• Lookup cubes

• A standard Cognos TM1 cube is referred to as a hard cube or a cube where data is actually loaded and resides.

• TM1 control cubes by definition, are hard cubes that hold data.

• All control cubes are named with a first character of` }` and are by default not-visible within TM1 Server Explorer.

• A virtual cube is a TM1 cube which is referred to as a soft cube where no data actually is loaded to or resides in, but references...