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
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Free Chapter
1
The Components of TM1

Basic data browsing in TM1


This section will discuss the methods for browsing data in TM1 cubes by using either Cube Viewer or In-Spreadsheet Browser.

Cube Viewer

Cube Viewer does not require programming to implement. It works for all cubes in a TM1 instance for which the logged-in user has access. The following steps can be followed to browse data in the Cube Viewer:

  1. 1. Open TM1 Server Explorer.

  2. 2. In the Tree pane, select the cube you want to browse.

  3. 3. Click on the cube and select Browse...:

  4. 4. The Cube Viewer window opens with the cube's system default view.

  5. 5. Press F9 or click on Recalculate to display the cell values.

With mouse clicks and drags-and-drops, the cube view of the data can be easily customized to meet your requirements.

In-Spreadsheet Browser

In-Spreadsheet Browser (ISB) does not require any programming to use. However, you may want to configure what browsing method TM1 will use as the default browser the Cube Viewer or the In-Spreadsheet Browser.

Note

When you double-click...