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 [...]
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 [...]
¶
Posted 05 August 2011
† ykud
§
‡
°
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 [...]
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 [...]
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 [...]
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 [...]
¶
Posted 19 March 2011
† ykud
§
‡
°
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 [...]
¶
Posted 11 March 2011
† ykud
§
‡
°
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 [...]
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 [...]
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 [...]