IBM Cognos TM1 Developers Certification guide电子书

IBM Cognos TM1 Developer's Certification Guide

Table of Contents

IBM Cognos TM1 Developer's Certification Guide

Credits

About the Author

About the Reviewer

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

Certification

Benefits of certification

Self assessment of skills

Know what you know

Identify your areas of weakness

Resume builder

The certification exam

Exam specifics

Length

Format

Maximum time allowed

Topics

Minimal score required to pass

Test languages

Location of exam

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. The Components of TM1

The components of TM1

Client components

TM1 Client

TM1 Perspectives

Features of TM1P

TM1 Architect

TM1 API

Server components

TM1 Admin Server

TM1 CFG

TM1 Server

TM1 Web

Setting up a worksheet reference

TM1 Top

TM1 Contributor

Summary

Two minute drill

Self test

2. Dimensions and Cubes

Introduction to cubes and dimensions

Dimensions

Elements

Editing element properties

Aggregations

Consolidating using dimension hierarchies

Element attributes

Descriptive attributes

Alias attributes

Display format attributes

Creating dimensions using the Dimension Editor window

Ordering elements in a dimension

Cubes

Loading cubes

Viewing cube characteristics

Lookup cubes

Control cubes

Security

Client and group administration

Object attribute and properties control

Performance monitoring

Hold tracking by username

Cube replication

Replicating your cubes between your servers

Replication must knows

Summary

Two minute drill

Self test

3. TurboIntegrator (TI)

Introduction

Data sources available with TurboIntegrator

The Data Source tab

The Variables tab

Defining your own variables!

More on the Variables tab

Local variables

Some very special local variables

The Maps tab

Cube tab

Dimensions tab

The Advanced tab

Order of operations within a TurboIntegrator process

The Schedule tab

Key notes on TurboIntegrator processes

String lengths limit in TurboIntegrator

Reserved words

Functions

Cube logging

Summary

Two-minute drill

Self Test

4. Rules

Rules

Rules — how do they really work?

Sparsity

Combinatorial explosion

Wikipedia

Dissection of Cognos TM1 Rules

Rules — calculation statements

Area definition

Area definition syntax

Special characters and non-unique element names

The CONTINUE function and area definitions

Numeric, consolidation, or string (oh my!)

Formulas

Numeric constants

Arithmetic operators

Using conditional logic

Cube references

External cube references

Drill assignment rule

More important Rules facts

Rules performance

Key notes on Rules behaviors

Rule feeders

Persistent feeders

The special feeders

Modifying rules and feeders

Guidelines for simple feeders

Troubleshooting

Rules Tracer

Summary

Two minute drill

Self test

5. Advanced Techniques for TI Scripting

ETL

TM1 TurboIntergrator review

The Data Source tab

Using TurboIntegrator Variables

Dynamic Definitions

Important TurboIntegrator functions

ExecuteProcess

ItemSkip

ProcessBreak, ProcessError, and ProcessQuit

View handling

ViewZeroOut

PublishView

CubeClearData

CellIsUpdateable

SaveDataAll

SubsetGetSize

Security functions

Rules and feeders Management functions

CubeProcessFeeders

DeleteAllPersistentFeeders

ForceSkipCheck

RuleLoadFromFile

SubsetCreateByMDX

Order of operations within a TurboIntegrator process

Aliases in TurboIntegrator functions

More on data sources

CubeSetLogChanges

Revisiting variable types

TurboIntegrator sections

Summary

Two minute drill

Self-Test

6. Drill-through

What is drill-through?

Components of TM1 drill-through

Where to drill from?

Drill-through (source) types

TM1 cube views

MaximumViewSize

ODBC

Other

Drill process

Creating a drill process

Drill process parameters

Editing drill processes

Drill rules

Feeders

Area definition

Creating a drill assignment rule

Drill-through area examples

Assigning drill processes

Conditional drill rules

Drilling from an Excel Slice

Drilling from an Active Form

Drill-through performance

Summary

Two minute drill

Self-test

7. Virtual and Lookup Cubes

TM1 cube types

Virtual cubes

Virtual cube creation

Feeders

Intercube feeders

Submitting a forecast to a virtual cube

Unmatched dimensionality

Conditional rules

Using conditional rules within a virtual cube

Consolidating data with a virtual cube

Reporting with virtual cubes

Other advantages of virtual cubes

Additional reporting options

Lookup cubes

Translation of data

Lookup cube example—using rules

Loading data with lookup cubes

Spreading data with lookup cubes

Summary

Two minute drill

Self test

8. Time Considerations

The importance of time

Granularity—the lowest level of time detail required

Month—two time dimensions

Month—one time dimension

Weeks

Days

Lower than day detail

Date format flexibility

Time dimension maintenance

Date and time Rules functions

DATE

DATES

DAY

DAYNO

MONTH

NOW

TIME

TIMST

TIMVL

TODAY

YEAR

Summary

Two minute drill

Self-test

09. Data Presentation and Reporting

Basic data browsing in TM1

Cube Viewer

In-Spreadsheet Browser

Modifying your view of data

Stacking a title dimension as a row dimension

Saving the view

Formatting view cells

Zero suppression

Worksheets

Slicing a view

Snapshots

Active Forms

Refreshing and recalculating

Deleting an Active Form

Active Forms and special formatting

Formatting Active Forms

Active Form default formatting

Modifying default formatting

Applying formatting

TM1 reports

TM1 Print Report Wizard

Selecting the sheets

Selecting the title dimensions

Selecting workbook print options

TM1 Web

TM1 Websheets

TM1 Web Cube Viewer

Creating a new TM1 Web cube view

Custom display formats

Summary

Two minute drill

Self-Test

Index