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 Active Form

As specified in the TM1 Users Guide:

Active Forms let you view and update live TM1 cube data directly in Excel whenever you are connected to the TM1 server on which the cube data resides. Active Forms retain the ability to expand and collapse row dimension consolidations in a TM1 view while allowing you to use native Excel features and functions to create complex reports.

Another place where drill-through works—other than the TM1 Cube Viewer and a sliced worksheet—is an Active Form. You can create your Active Form, using either of the following methods:

  • From the TM1 Cube Viewer File menu, click on Active Form Slice.

  • From the TM1 Cube Viewer toolbar, click on the Active Form button.

The Active Form is created in a new empty Excel worksheet and of course, right-clicking on your drill rule area definition will result in TM1 drilling the related data into a new worksheet within your workbook.