Monthly Archives: May 2009

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

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

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

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

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