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
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.
