Knowledge base

An IBM Cognos TM1 TI Process stands for a Turbo Integrator Process. It lets developers import data into cubes from data sources including ASCII files, ODBC and other cubes.

TM1 Turbo Integrator is part of the IBM Cognos TM1 solution. TM1 Turbo Integrator is used to create dimensions and cubes based on ODBC data sources or flat files. Within Turbo Integrator the developer can make use of advanced scripting features and can create and schedule chores. Turbo Integrator can be considered to be the Extract, Transform and Load utility for use with TM1. TM1 Turbo Integrator is part of TM1 Architect in which a complete TM1 model is build. 

Agile Business Intelligence (Agile BI) enables seamless collaboration between BI developers & BI users. It includes a rapid development methodology which solicits end-user input early and often and dramatically reduces the time for building BI solutions. As such Agile BI combines a set of processes, methods, tools & technologies in order to help BI users to be more flexible and more responsive to ever-changing business requirements.

Elements in TM1 are used to define data in cubes. Every element has a type associated with it: simple(number), string and consolidated element. A simple element is the lowest level in the hierarchy. A string element contains string information. An element that has aggregated data in a cube is a consolidated element.The format of the attributes of the elements can be modified by the developer.

TM1 Chores are a concept related to the IBM Cognos TM1 solution. A chore is a schedule that contains a batch of processes that is executed to run on a specific time period.

TM1 cubes exist within the IBM Cognos TM1 solution. A TM1 cube is a multidimensional database that must contain at least 2 dimensions and 1 fact. The data is loaded into the cube making use of a turbo integrator process.Each cube can be expanded to view all the dimensions that make up the cube. Once a cube is created, it is not possible to add or remove dimensions. You will have to create a complete new cube if you want to remove or add dimensions.

A TM1 application is a collection of shortcuts to TM1 objects, files, URL's and Excel files organized into format related groups. Excel files that are published on the web are also listed in the applications folder. An application folder consists out of TM1 objects like cubes, cube views, subsets and chores. File references are shortcuts to Microsoft Excel, Microsoft Word or PDF files. The applications are automatically available in TM1 Web.

TM1 Rules & Feeders are concepts related to the IBM Cognos TM1 solution. TM1 feeders feed every cell that is calculated by a rule. Feeders are not used to feed rules that apply to consolidated cells. Feeders are not required to make rules work, however they can improve performance in sparse cubes. Rules and feeders are written in the Rules Editor. The feeder statements are starting with declaring ‘FEEDERS' before starting the rule.

A TM1 Skipcheck is a concept related to the IBM Cognos TM1 solution. When a rule is added to a cube, TM1 turns off skipping empty cells and begins to check every cell in the cube before consolidating the values. This can cause performance problems. 

A TM1 Sandbox is a functionality related to the IBM Cognos TM1 solution. Sandboxes are versions of cube views saved locally. This feature allows users to have their own personal workspace with a personal copy of the data on which they can do simulations. The sandbox feature can be disabled or enabled by adding a line in the TM1s.cfg file.