Adding Financial Local/Group Currency Logic

The purpose of this article is to describe how to add a Local/Group Currency system to a new TM1 cube; this can be core requirement for International Companies and is relatively common. To explain the Group/Local split, Group – the company’s home country currency – used primarily for Reporting Local – the branch/profit-centre’s currency – how data is entered.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Currency, Currency Conversion, Forex, Group Currency, Local Currency, Rules, TM1. Bookmark the permalink. | Tagged Currency, Currency Conversion, Forex, Group Currency, Local Currency, Rules, TM1 | Leave a comment

Installing TM1 9.4

To begin download the latest version of TM1 from the ‘My-IBM’ site. You will need a login to access the site. (http://www-01.ibm.com/software/data/cognos/) At the time of writing this the most current version of TM1 is 9.4 MR1 with FP2 being the latest hot fix. Once you have downloaded the version of TM1 you wish to install you should probably check your computer/server has everything needed to install TM1 I’ll break … Continue Reading

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

Adding Items to the TM1 Web Right Click Menu

Within the TM1Web/Scripts folder open the ‘tm1webbook.js’ file within notepad or the preferred editor. You should probably create a backup of this file before making any changes.

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

Naming Conventions and Syntax

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 often naming conventions are disregarded within the initial development stages of a TM1 implementation. Usually an attempt is made to bring these in at a later time, often too late – it will  never be considered as a value-add enhancement … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Best Practice, ETL, Rules, TM1Naming Conventions, Turbo Integrator. Bookmark the permalink. | Tagged Best Practice, ETL, Rules, TM1Naming Conventions, Turbo Integrator | Leave a comment

Dimension Worksheets

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 found in Server Explorer under ‘File’.     To create a new Dimension via Dimension Worksheets

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

Modifying a Dimension – Backend Editor

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 on the Dimension Click “Edit Dimension Structure”   Right Click any where and click “Insert Element”   Type the name of the element Check the settings are as expected (Element Type)   Click ‘Add’ to insert the Element into the … Continue Reading

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

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