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

Chapter 7. Virtual and Lookup Cubes

In this chapter, we will learn the definition and purpose of both virtual and lookup cubes in Cognos TM1 with regards to the current IBM Cognos TM1 Developer (Test COG-310) certification exam.

The current certification exam assigns a weightage of 10 percent to this topic.

TM1 cube types

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

  • Standard cubes

  • Control cubes

  • Virtual cubes

  • Lookup cubes

  • Virtual: This term has been defined in philosophy as that which is not real but may display the salient qualities of the real—Wikipedia.

  • Lookup: This term usually refers to searching a data structure for an item that satisfies some specified property—Wikipedia.

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

In Chapter 2, Dimensions and Cubes we talked about the standard Cognos TM1 cube as well as dimension objects. You will remember following points:

  • Cubes are to TM1 what tables are...