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

Virtual cubes

A virtual cube differs from a standard cube in Cognos TM1. It is a TM1 cube which is sometimes termed as a soft cube where no data is loaded to or resides in, but only references data points in other cubes.

Being a fully rules-calculated cube, virtual cubes have no data stored in them. They just have rules pulling data from other cubes and possibly performing additional calculations on that data.

To a TM1 user, a virtual cube may have the exact same appearance of a standard or hard cube. We will discuss the creation and use of a virtual cube in this chapter.

Virtual cube creation

To create a virtual cube, you would first design and create a cube using the methods already discussed for creating a standard cube, but no data would actually be loaded into the cube.

Standard TM1 cubes may have significant amounts of data pulled from or referenced from other cubes, but virtual cubes will have 100 percent of their data pulled from other cubes.

The steps to create a simple virtual cube...