PacktLib: IBM Cognos TM1 Developer's Certification guide

IBM Cognos TM1 Developer's Certification Guide

Credits

About the Author

About the Reviewer

www.PacktPub.com

Preface

The Components of TM1

The components of TM1

Summary

Dimensions and Cubes

Introduction to cubes and dimensions

Dimensions

Elements

Aggregations

Consolidating using dimension hierarchies

Creating dimensions using the Dimension Editor window

Cubes

Cube replication

Summary

TurboIntegrator (TI)

Introduction

Data sources available with TurboIntegrator

Rules

Rules

Dissection of Cognos TM1 Rules

Rules performance

Rule feeders

Troubleshooting

Summary

Advanced Techniques for TI Scripting

ETL

TM1 TurboIntergrator review

Order of operations within a TurboIntegrator process

Aliases in TurboIntegrator functions

More on data sources

CubeSetLogChanges

Revisiting variable types

TurboIntegrator sections

Summary

Drill-through

What is drill-through?

Drill process

Drill rules

Conditional drill rules

Drilling from an Excel Slice

Drilling from an Active Form

Drill-through performance

Summary

Virtual and Lookup Cubes

TM1 cube types

Virtual cubes

Feeders

Intercube feeders

Submitting a forecast to a virtual cube

Unmatched dimensionality

Conditional rules

Consolidating data with a virtual cube

Reporting with virtual cubes

Other advantages of virtual cubes

Additional reporting options

Lookup cubes

Summary

Time Considerations

The importance of time

Granularity—the lowest level of time detail required

Time dimension maintenance

Date and time Rules functions

Summary

Data Presentation and Reporting

Basic data browsing in TM1

Modifying your view of data

Saving the view

Formatting view cells

Worksheets

Active Forms

TM1 reports

TM1 Web

Custom display formats

Summary