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

Drilling from an Excel Slice

As specified in the TM1 Users Guide:

The Slice option, available from the Cube Viewer and In-Spreadsheet Browser, lets you save a cube view as a standard worksheet. When you create a slice, TM1 generates a worksheet populated with functions. These functions display the current database values in the worksheet.

As we mentioned earlier in this chapter, it is possible to drill-through to related data from a Microsoft Excel worksheet (rather than the TM1 Cube Viewer).

We can follow these steps to slice the current cube view into a worksheet:

  1. 1. Open (or create a new) view in the Cognos TM1 Cube Viewer.

  2. 2. From the Cube Viewer, click on File.

  3. 3. Click on Slice. Then, TM1 slices the view into a new Excel worksheet.

At this point you should have your view sliced into a Microsoft Excel worksheet. Now, if you right-click on a cell in the worksheet (that corresponds to the area definition in your drill rule), TM1 will respond by drilling the data which is related to that...