Ben Hill

Naming Conventions and Syntax

Posted on Jun 9, 2009 by Ben Hill

Within TM1 all objects names and contents are completely defined by the Developer. Cubes, Public Views, Dimensions, Public Subsets, Processes, Chores and Applications are all named on creation. All too…

Dimension Worksheets

Posted on May 11, 2009 by Ben Hill

Dimension Worksheets are a great way to manage medium sized dimensions and attributes/aliases. All Worksheets (Dimension and Rule) are held in the local data directory set in the ‘Options’ form…

Modifying a Dimension – Backend Editor

Posted on May 10, 2009 by Ben Hill

There are a few ways to update a dimension within TM1, the first is the simplest and most commonly used. To update a Dimension using the Dimension Editor: Right Click…

Conditional Feeders

Posted on May 4, 2009 by Ben Hill

Conditional feeders can be used to minimize the storage impact of rule feeders. The typical situation occurs when rule values are calculated by multiplying factors, any of which may be…

API Tutorial (not .net)

Posted on May 3, 2009 by Ben Hill

TM1 API Programming – Initial Steps:  At the start of a TM1 API project a few steps are necessary to get connected, 1.      Include the TM1 API Module 2.      At the Beginning…

Turbo Integrator Troubleshooting

Posted on May 2, 2009 by Ben Hill

Turbo Integrator Overview Turbo Integrator (TI) Processes are scripts that execute within the TM1 server to perform data manipulation. Most TI Processes use a data source which is processed line…

TM1 Security (Pre 9.4)

Posted on Mar 2, 2009 by Ben Hill

Overview Security within TM1 is limited to assigning a client to a group then a group to one or many levels and selections of objects. The levels of objects are:…

TM1 Server Setup

Posted on Feb 2, 2009 by Ben Hill

Creating a new TM1 Server To create a new server you must first create a data directory, this directory must have at very least: ‘tm1s.cfg’ ‘tm1s.lic’ The configuration file (tm1s.cfg)…

Clear Cube Process

Posted on Aug 19, 2008 by Ben Hill

It is good practice to create and destroy a view for clearing rather then leaving a large clear view sitting under the cube waiting for a user to click on…

What is TM1 (Updated)?

Posted on Aug 18, 2008 by Ben Hill

IBM Congos TM1, formerly Tables Manager 1, is a client and server software platform which uses Microsoft Excel  and various web applications on the client side with an in memory,…

Keen to chat? Book a discovery call!

pen