Exploring TM1

Great TM1 content brought to you by Infocube

Discover More about Infocube Here!

#206752 Test Post

What is Lorem Ipsum? Lorem Ipsum is simply a dummying text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the … Continue Reading

SUBNM Excel TM1 Function: Syntax, Use and Example

SUBNM allows you to use a subset from a TM1 dimension for drop-down selection in an Excel report or form and open the subset editor to select elements.

Dynamic TM1 Server Name in Excel Workbook

Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean all your server references in TM1 formulas will dynamically update and refer the model you are currently logged into.

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.