Fixed Width File Format from TM1

When outputting data from TM1 usually we can get away with comma separated values format. Which is standard functionality from a Turbo Integrator process [See ASCIIOutput, TextOutput functions]. Every now and then we need to interface with a ERP system which requires Fixes Width Fields. This presents a few problems, not insurmountable but still not expressly easy either. The tips below will make things easier for you. ASCII Quote Character Options To start your extract process … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator. Bookmark the permalink. | Tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator | Leave a comment

TM1 at month-end

IBM Cognos TM1 is … what it has been developed to do within your environment. Unfortunately that means most companies aren’t getting the most out of their investment as it has been sold to them as a single point solution, solving a single point problem – So I thought that over the next for months I would post a couple of applications of TM1 in areas where its not always … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged CoGS, ERP, Gross Margin, Gross Revenue, IBM Cognos Express, IBM Cognos TM1, Journal, Monthend, PeopleSoft, Pronto, SAP. Bookmark the permalink. | Tagged CoGS, ERP, Gross Margin, Gross Revenue, IBM Cognos Express, IBM Cognos TM1, Journal, Monthend, PeopleSoft, Pronto, SAP | 1 Comment

Notepad++ for TM1 Rules & TI – Updated!

With the new release of Notepad++ yesterday to v6.4.1, I thought it was a brilliant time to update the TM1 Turbo Integrator and Rules Syntax files to be based on TM1 v10.1.0 Reference Guide. The new version xml file can be found here: TM1 v10.1 Notepad++ update In this release, we’ve added a couple of new TI functions such as: Synchronize: Used in a TI script to force serial execution of … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, TM1 10.1, TM1 pre 10.1, Training Material and tagged Code, IBM Cognos Express, IBM Cognos TM1, Notepad++, Rules, Syntax Highlighting, Turbo Integrator. Bookmark the permalink. | Tagged Code, IBM Cognos Express, IBM Cognos TM1, Notepad++, Rules, Syntax Highlighting, Turbo Integrator | 10 Comments

Monte Carlo simulation with TM1

A bit about Vangelis: Hi, I am Vangelis, I am from Greece and now I live in Sydney Australia. Currently, I’m working as a consultant at Infocube Consulting. I have expertise in IBM Cognos products, BI and TM1 and also in mathematics and statistics. My academic background consists of a BSc in Mathematics, MSc in Finance & Banking, MSc in Information & Telecommunications Technologies and a couple of certifications on … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, TM1 10.1 and tagged Cognos Insight, Monte Carlo simulation, TM1. Bookmark the permalink. | Tagged Cognos Insight, Monte Carlo simulation, TM1 | 2 Comments

Woohoo! TM1 Tuts has cracked 100,000 visits!

This is just a shout out to all the administrators, support teams and developers who have browsed or subscribed to the TM1 Tutorials blog over the last two years. Thanks, your the best and we are so pleased to have the opportunity to share our time tested tips and tricks with you all If you are new to TM1 Tutorials, take a moment to read through the topics we have covered … Continue Reading

This entry was posted in Bug Fix, Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 Contributor, TM1 pre 10.1, Training Material and tagged Cognos TM1, Feeders, IBM Cognos TM1, Rule Feeders, Turbo Integrator. Bookmark the permalink. | Tagged Cognos TM1, Feeders, IBM Cognos TM1, Rule Feeders, Turbo Integrator | Leave a comment

Your Lifeline, The TM1 Transaction Log

The TM1 Transaction Log stores all data changes in TM1 you can use it to restore data as kind of a Super-Undo. You can use it to back out, or reverse, changes to data Reversing Transactions in TM1 Backing out transactions in TM1 is not at all difficult. First of all here is the view of the Salary cube with data: And one after the data is accidentally flushed out: How … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, TM1 Admin, Training Material and tagged Architect, Backing Out Changes, IBM Cognos TM1, Perspectives, TM1, Transaction Log. Bookmark the permalink. | Tagged Architect, Backing Out Changes, IBM Cognos TM1, Perspectives, TM1, Transaction Log | 1 Comment

Creating basic Top 10 reports using MDX expression

One of the most common requests for reports is to generate a list of top 10 for a dimension based on TM1 data. This makes sense considering level of data TM1 works best with; this could cover top 10 consumers, customers or top 30 SKUs at one particular outlet or within a brand. There are several ways to achieve that within TM1, the simplest way to do this within a … Continue Reading

This entry was posted in IBM Cognos TM1, Training Material and tagged Excel, IBM Cognos TM1, MDX Use, Reporting. Bookmark the permalink. | Tagged Excel, IBM Cognos TM1, MDX Use, Reporting | 9 Comments

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

Broken Transaction Log?

With Windows Vista, 7 and many of the newer server editions of Windows a Microsoft security fix has removed a component which TM1 Perspectives & Architect use to display the Transaction Log browser.  This component is called “MSMask32.ocx” which traditionally belongs in the System32 folder. To get this working again on these machines: Download the component here: msmask32.zip Save these to the appropriate folder below: On a 32-bit computer save to C:\Windows\System32\ On … Continue Reading

This entry was posted in Bug Fix, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged Bug, IBM Cognos TM1, Transaction, Transaction Log. Bookmark the permalink. | Tagged Bug, IBM Cognos TM1, Transaction, Transaction Log | 1 Comment

Removing old TM1 Servers from "Services"

When upgrading a clients environment to IBM Cognos TM1 10.1 I noticed a bunch of older TM1 Services. A quick google reveals that you can remove services by using the following command line: sc delete “Service Name” Note: If you have a TM1 Service setup as: “TM1 Server x64 / Production Server” you will use the following command sc delete “Production Server” Is it about time you cleaned up the … Continue Reading

This entry was posted in TM1 10.1, TM1 pre 10.1 and tagged IBM Cognos TM1, Install, Installation Guide, NT Service, TM1, TM1 Installation. Bookmark the permalink. | Tagged IBM Cognos TM1, Install, Installation Guide, NT Service, TM1, TM1 Installation | Leave a comment