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 by line. There are 7 major sections to a Process: Data source Settings Data source Variables Parameters Prolog Metadata Data Epilog Data source Settings Here you can change the file/query that is being imported. It’s important when sourcing data from … Continue Reading
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: Tier 1: Cubes Applications Processes Chores Tier 2 – Dimensions Tier 3 – Elements Tier 4 – Cube Cells/Intersections of Elements The level based security is reciprocated up the tiers meaning in example that if the ‘Final Budget’ Element within … Continue Reading
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) should specify: Server Name Server Admin-host Data Directory Logging Directory Server Port Any Additional Configurations (Max Login Attempt) The typical directory structure of an Application Server is as follows:
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 it. The code below creates a view and assigns subsets to that view, zero’s the view out then destroys the view and subsets.
TM1 is an in-memory, multidimensional data store with write back from IBM. It’s primarily used for corporate planning reporting and analysis.
Over the last 2 years more and more companies have looked at going 64-bit as their complex business modelling requires much more from a hardware perspective for TM1. TM1 supports two 64-bit Operating Systems these are UNIX and Windows 64-Bit. Since it’s more than likely that the admin users of TM1 are used to working in Windows, a UNIX server can present some awkward curve balls when it comes to … Continue Reading
Attached is the presentation I did for the Sydney TM1 Usergroup organized by Amendra Pratap. This covers most of the new 9.4 features.