Conditional Feeders

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 zero. This means that the value should be fed only when all the factors are non-zero. Example Given a cube SalesBySalesperson with dimensions: ·         Salesperson, ·         Product, ·         Month, ·         Measures (‘Sales’ and ‘Commissions’) If you calculate Commissions based on Sales using a commission … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Conditional Feeders, Feeders, Rules. Bookmark the permalink. | Tagged Conditional Feeders, Feeders, Rules | Leave a comment

API Tutorial (not .net)

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 of the Project use the ChDir and ChDrive function and set the Selected Directory to the Directory that contains TM1api.dll or put the bin dll files in the projects folder.                 example:                    ChDir “C:Program FilesApplixbin”                    ChDrive “C” The Best way … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged API, TM1, TM1 API, VBA. Bookmark the permalink. | Tagged API, TM1, TM1 API, VBA | Leave a comment

Turbo Integrator Troubleshooting

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Development, TM1Message Log, Troubleshooting, Turbo Integrator. Bookmark the permalink. | Tagged Development, TM1Message Log, Troubleshooting, Turbo Integrator | Leave a comment

TM1 Security (Pre 9.4)

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Development, Security, TM1, Users. Bookmark the permalink. | Tagged Development, Security, TM1, Users | Leave a comment

TM1 Server Setup

Starting Up a Server Creating a new 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:

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Configuration, Data Directory, Getting Started, Logging Directory, Maintenance, Naming Conventions, NT Service, Server Instance, Setup Guide, Shutdown, TM1. Bookmark the permalink. | Tagged Configuration, Data Directory, Getting Started, Logging Directory, Maintenance, Naming Conventions, NT Service, Server Instance, Setup Guide, Shutdown, TM1 | Leave a comment

Clear Cube Process

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.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged AssignSubset, CreateSubset, Development, ElementInsert, SubsetDestroy, TM1, Turbo Integrator, ViewDestroy, ViewSubset, ViewZeroOut. Bookmark the permalink. | Tagged AssignSubset, CreateSubset, Development, ElementInsert, SubsetDestroy, TM1, Turbo Integrator, ViewDestroy, ViewSubset, ViewZeroOut | Leave a comment

What is TM1?

IBM Congos TM1, formerly Tables Manager 1, is a Client and Server Software platform which uses an Microsoft Excel Client side with a Multidimentional Datastore on the Server side. This is Commonly used for Financial Planning and Reporting.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged TM1. Bookmark the permalink. | Tagged TM1 | Leave a comment

TM1 in a Unix Environment

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Best Practice, TM1, Top, UNIX. Bookmark the permalink. | Tagged Best Practice, TM1, Top, UNIX | Leave a comment

TM1 9.4 Presentation

Attached is the presentation I did for the Sydney TM1 Usergroup organized by Amendra Pratap. This covers most of the new 9.4 features.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged TM1 9.4. Bookmark the permalink. | Tagged TM1 9.4 | Leave a comment