Tag Archives: TI Process

Managing Applications from Command Line

In TM1 10.2, a new feature has been added to allow users to perform application maintenance using command line, or in a batch file. The main purpose of this utility is to automate some of the application maintenance, using a combination of standard TI processes and TI processes that execute commands available in this utility. Also, chores can be setup to execute these periodically, such as overnight application maintenance. This … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged App Maintenance, Application Maintenance, Business Analytics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator. Bookmark the permalink. | Tagged App Maintenance, Application Maintenance, Business Analytics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator | Leave a comment

TM1 10.2 – New Feature: Enable/Disable Applications from Commandline

In this new release of TM1 10.2, a new feature has been added to allow users to perform application maintenance using command line, or in a batch file. The main purpose of this utility is to automate some of the application maintenance, using a combination of standard TI processes and TI processes that execute commands available in this utility.  Also, chores can be setup to execute these periodically, such as … Continue Reading

This entry was posted in IBM Cognos TM1, Performance Modeler, TM1 10.2 and tagged App Maintenance, Application Maintenance, Business Analystics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator. Bookmark the permalink. | Tagged App Maintenance, Application Maintenance, Business Analystics, Commandline, TI, TI Process, TM1 10.2, Turbo Integrator | Leave a comment

How to write easily understood Turbo Integrator code

As many of TM1 consultants know, reading TI code always has the possibility of being a tricky task – especially if it is someone else’s code. This is mostly due to TM1 Perspectives Turbo Integrator lacking Syntax Highlighting (See our Notepad++ highlighter) but in part it is due to poor variable naming, indenting, casing or things simply not developed consistently throughout the model.

This entry was posted in IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged IBM Cognos TM1, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged IBM Cognos TM1, TI Process, Turbo Integrator, TurboIntegrator | 4 Comments

Automating Data Transfers between TM1 Servers

Replicating a Cube from a one TM1 Server into another has never been easier. Follow the steps below to copy a cube from one server to another (this includes synchronising TM1 Dimensions). This process uses the ODBO Provider for TM1 and generated MDX. I was going to show how to create an MDX Query for the desired cube but as it turns out you can select ODBO Cube as the data type … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged ETL, ExecuteProcess, IBM Cognos, IBM Cognos Express, IBM Cognos TM1, TI Process, TM1 Training, Turbo Integrator. Bookmark the permalink. | Tagged ETL, ExecuteProcess, IBM Cognos, IBM Cognos Express, IBM Cognos TM1, TI Process, TM1 Training, Turbo Integrator | 7 Comments

TM1 Contributor – Single Security Hierarchy

Currently on-site at client installing TM1 Cognos Express. The client wishes to use the contributor application to utilize workflow in the forecast. Doing so can creates a number of limitations, namely security and secondly cube design. Within TM1 Contributor/Cognos Express Planner you apply security based on a single dimension hierarchy for the application you have created, however the elements within the entire security dimension cannot share more than one top … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 Contributor, TM1 pre 10.1, Training Material and tagged Contributor, David Payten, ETL, Fluffy Mittens, IBM Cognos TM1, Sample Code, TI Process, TM1 Process, TM1 Tutorial. Bookmark the permalink. | Tagged Contributor, David Payten, ETL, Fluffy Mittens, IBM Cognos TM1, Sample Code, TI Process, TM1 Process, TM1 Tutorial | 1 Comment

Sending Emails from TM1 (Part 2: HTML)

Sending Emails from TM1 – Using HTML Problem: Although some additional components of TM1 have built-in email functionality, TM1 does not have email functionality built into its ETL Engine. Text emails will not suffice, you want to employ HTML encoding in your email to provide a more ascetically appealing email. Solution Process: Within a TI Process output text to a file to be used as the body of the email … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Email, IBM Cognos TM1, SMTP, TI Process. Bookmark the permalink. | Tagged Email, IBM Cognos TM1, SMTP, TI Process | 4 Comments

Use Case: Removing the Structure from a Dimension

The Problem: Often when writing dimension update processes from a datasource which is updated automatically we use a standard procedure. Delete all the Elements Add Top Level Consolidations Cycle through (Metadata) Adding Elements and Element Components Cycle through (Data) Adding Aliases But in some cases we are only given a partial data feed.  For example we may be reporting off 3 years sales but the datasource for the Product dimension is broken … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Bedrock, Chores, Consolidation, Dimension, DIMENSIONELEMENTCOMPONENTDELETE, DIMNM, DIMSIZ, ELCOMPN, Element, IBM Cognos TM1, Maintenance, TI Process. Bookmark the permalink. | Tagged Bedrock, Chores, Consolidation, Dimension, DIMENSIONELEMENTCOMPONENTDELETE, DIMNM, DIMSIZ, ELCOMPN, Element, IBM Cognos TM1, Maintenance, TI Process | 3 Comments

Guest Post: Solving a TM1 Performance Problem – Wim Gielis

One of our major customers was facing severe performance problems. The problems related to 2 cubes, in which we wanted to execute a rather tricky elimination. Please follow along while we discuss the cube architecture. We have an allocation cube with the following dimensions: Financial code (10 n elements) Year (2008, 2009, 2010, 2011, 2012) Month (12 months plus YTD consolidations) Scenario (actuals, budget rounds) Allocation phase (7 phases, populated … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis. Bookmark the permalink. | Tagged IBM Cognos TM1, TI Process, TM1 Performance, Wim Gielis | 1 Comment

How to Import all Files in a Directory

We’ve recently been on a Property Management project using TM1 to deliver a Management, Planning and Reporting Solution. The Client has properties which are managed by an external property manager who produces tenancy schedules and general ledger reports for data consumption. The Problem: Every properties reports would come from the external property manager in a different file. Making the process to load these into TM1 only mildly faster than using … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged ExecuteCommand, ExecuteProcess, IBM Cognos TM1, TI Process, TurboIntegrator, VBScript. Bookmark the permalink. | Tagged ExecuteCommand, ExecuteProcess, IBM Cognos TM1, TI Process, TurboIntegrator, VBScript | 2 Comments

Guest Post: Sorting TM1 Text Output – Wim Gielis

First of all, thanks to Ben for inviting me to write this guest article. The case is as follows. Recently, the customer wanted an export from a cube view showing monthly revenue values per project. The user should open the exported file in Excel, modify and import back into TM1. Exporting data to a text file format like .CSV or .TXT is not an issue; an ASCIIOUTPUT() or TEXTOUTPUT() function … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Aexis, ASCIIOUTPUT, DataSourceAsciiQuoteCharacter, IBM Cognos TM1, Sorting Data, TEXTOUTPUT, TI Process, Turbo Integrator, Wim Gielis. Bookmark the permalink. | Tagged Aexis, ASCIIOUTPUT, DataSourceAsciiQuoteCharacter, IBM Cognos TM1, Sorting Data, TEXTOUTPUT, TI Process, Turbo Integrator, Wim Gielis | 6 Comments