Exploring TM1

Great TM1 content brought to you by Infocube

Discover More about Infocube Here!

How to Dynamically Assign Data based on Selection in a Planning Model

How to create a planning model where users can enter and select variables in one location and TM1 then assigns the data dynamically to all required dimensions.

Selective Clear Cube based on Variable Source Data

Detailed instructions on how to clear a variable selection of data that is going to be reloaded from the source. Includes sample TI code and explanations.

StringToNumber TM1 Process: Use and Syntax

StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.

DimensionElementPrincipalName, Syntax and Use

DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.

URL to Log an IBM Cognos or IBM TM1 Support Call

TM1 Service Request

Here is a quick link to the IBM support website. From it you can log Cognos Support tickets and create TM1 Support Requests, directly with IBM.

Logging in Planning Analytics for Excel

Here is a simple step by step guide to enabling logging in Planning Analytics for Excel. PAX logging is easy and really helps IBM resolve problems with PAX.

IBM Software on Virtual Servers Could Expose You Millions (Literally)!

IBM software installed on virtual servers could potentially expose your organisation to a claim from IBM for millions. The risk is real. We’ve seen the claims. Here is what you can do now to avoid this significant and job threatening exposure.

Using Technotes to Help Manage TM1

Technotes for TM1 are a great way of keeping informal notes about “how we do things in TM1”. They’re quick, informative, imperfect and gold! Here is what to include and a downloadable example.

TM1 Clear Attribute – an AttrClear Function

The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example

How to Upgrade (or Update) Planning Analytics Workspace

Step by step instructions for updating Planning Analytics Workspace server on Windows Server 2016.