Category Archives: tm1

Do you want your TM1 go twice faster on Intel-box? Turn HyperThreading off

This’ll be a bit long (but with a hidden bonus for attentive reader), so I’ll start from conclusions. If you’re using a recent server with Intel CPUs, you’d better check whether they have Hyper-Threading (HT) and try turning it off to gain 2x speed boost. How to do it: 1) go to server, open command [...]

BedRockTM1: code samples and methodology

A new TM1 resource just popped up on my radar. Take a close look at bedrocktm1.org. Overall approach excites coder part of me: modular development, agile, best practice source code — all this is actually very helpful. Having so much Turbo Integrator ‘how-to’s solves a lot of ‘re-inventing the bicycle’ cases. As far as I [...]

TM1 Load Testing and TM1 9.5.2 Parallel Interaction Feature

We’ve just finished our TM1 load-testing project and there are some conclusions I’d like to share: 1) Stress-testing scenarios should model user’s behavior as closely as possible (hence all that xml configuration in stress-testing tool) 2) Performance whack-a-mole game is a non-ending one, you’d better put yourself some deadlines where to stop at 3) Real-model [...]

New Cognos BI and TM1 content from IBM

Cognos 10 Redbook is now avalaible on IBM site. I always respected RedBooks initiative, because these are actual books with lots of practical knowledge, not just product documentation. I’ve only skimmed through this book, it seems less tips’n’tricks than Packt one about Cognos 8 Report Studio. But it’s a very good overall coverage of what [...]

TM1 model comparison tool

Another simple script, this time about reporting changes between a couple TM1 models. Developed for pre dev->prod migration in one of our projects, but maybe useful for answering ‘what did we change since backup?’ or even ‘what did they change while we weren’t around?’ questions. I’ve made random changes to Planning Sample — here’s the [...]

TM1 9.5.2 is out

It seems a very interesting new release. They’ve added a Parallel Interaction feature, which should decrease locking contentions that we’ve been working with. Would be nice to try this thing out. Take a look at new features guide and operations for more details. And Russian seems to be fully supported, cool. Watch TM1Forums threads for [...]

TM1. Generating and loading multiple rule files in one TI process

A more thorough answer to this LinkedIn thread. Several points before we start: You can load a rule file in TI process by using RuleLoadFromFile function It’s pretty easy to generate need rule file using ASCIIOutPut to write the need rule. But ASCIIOutPut opens the file on procedure (EPILOG, PROLOGUE, META) start and closes connection [...]

Optimizing tm1 calculations (with pictures!)

Found myself using both of my new toy-scripts while stress-testing TM1: I vizualize model data flow (way bigger than PlanSample in this picture, but node filtering helps). Looking at such graph it’s easy to see model inputs (to left side), hardest calculations (these are the gordian knots) and reporting cubes. So I just start pouring [...]

Stress testing TM1 models

Ever thought about load testing your dear-loved TM1 project? Emulating a hundred (or hundreds) users reading and writing data simultaneously? it’s easy and simple! Never trust sales slogans like above. Any kind of stress testing system should be approached with a huge amount of doubt, as well as this one. But it’s a simple and [...]

Should we use TM1 for reporting?

Another point worth clearing out: I really think TM1 is not a very good choice for OLAP reporting engine. On a decent data volumes, of course, millions of rows will be fast as lightning Let me explain why. There’s a fundamental difference choice you take when you’re building an OLAP engine:  you decide whether it [...]