PacktLib: IBM Cognos TM1 Cookbook

IBM Cognos TM1 Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Getting Started with TM1

Online Analytic Processing (OLAP)

OLAP data structures terminology

OLAP (Online Analytical Processing) versus OLTP (Online Transactional)

Introduction to TM1

Examine TM1 user roles

TM1 architecture

Installing TM1 server and clients on a machine

Creating a new TM1 Data Server

Connecting to an existing TM1 Server

Setting up TM1 Data Server to run as a Windows service

Summary

Creating dimensions in TM1

Introduction

Creating dimensions manually

Creating a Months dimension

Adding additional levels in Months dimension

Adding Next and Previous attributes to the Months dimension

Creating dimensions using the Turbo Integrator

Execution of scripts for a TM1 process

Building Cubes and Views

Introduction

Creating a static pick list

Creating the Sales_Plan cube

Creating a subset pick list

Loading and Maintaining Data

Introduction

Loading data using Turbo Integrator processes

Using formulae in variables

Clearing data from a cube using a process

Accumulating data

Saving data

Adding Business Rules

Introduction

Creating simple rules

Using a rule to override aggregation

Creating a rule to share data between cubes

Creating a pick list using a rule

Reviewing a Rules worksheet

Doing custom calculations in dimensional hierarchies

Automating Data Load Processes using Scripts

Introduction

Loading data from multiple columns into a single column

Creating a dimension and a subset in Turbo Integrator

Creating a dimension with uneven/unbalanced hierarchy

Exporting data to ASCII text using Turbo Integrator

Moving data between versions

Moving data using scripts and parameters

Creating and scheduling a chore

Customizing Drill Paths

Introduction

Creating a drill-through path to a view in another cube

Creating a drill path to an ODBC source

Using Rules for Advanced Modelling

Introduction

Creating the Expenses cube

Examining a Spread Profile cube, Lookup cube, and Virtual cube

Moving balances from last month to next month

Converting Currencies

Introduction

Creating currency dimension and attributes

Creating a currency cube

Populating currency attributes using control cubes

Creating rules to apply exchange rates and calculate an equivalent amount in target currency

Modelling for Different Fiscal Requirements

Introduction

Adding a year dimension

Creating a continuous time model

Optimizing Rules Performance

Introduction

Adding SKIPCHECKS and FEEDERS

Troubleshooting rules and feeders

Working with Managed Planning Applications

Introduction

Installing and configuring IBM Cognos TM1 Contributor components

Installing Apache Tomcat 6.0.18 for IBM Cognos TM1 Contributor

Installing IBM Cognos TM1 Contributor

Deploying IBM Cognos TM1 Contributor on Tomcat Server

Configuring IBM Cognos TM1 Contributor with Microsoft IIS

Running IBM Cognos TM1 Contributor for the first time

Installing IBM CognosTM1 Contributor Administration tool

Contributing data to managed planning application

Introducing IBM Cognos TM1 Contributor workflow screen

Navigating the TM1 Contributor workspace

Opening a node and modifying a view

Entering, editing, and distributing data

Reviewing data

Creating and deploying managed planning applications to the Web

Setting security and access rights

Assigning security to managed planning applications

Defining Workflow

Introduction

Adding users and groups to the TM1Security

Installing IBM Cognos TM1 Workflow

Adding a new process and task using IBM Cognos TM1 Workflow

Reviewing submitted tasks

Integration with IBM Cognos BI

Introduction

Integrating IBM Cognos TM1 with IBM Cognos 8 BI