Sometimes you find yourself with a full-blown EP model, containing a 100 or so Contributor Application links and you need to actually find what they do. Opening them one-by-one is very time-consuming. One of my colleagues stumbled in such situation, so I’ve made a quick script that processes application link export files (.cal ones) and [...]
This post will be some extracts from a recent PoC, where we made a complex planning system including a rich scenario modeling part. So it was our first big TM1 + EP integration experience. Some basic definitions: Cognos Enterprise Planning (aka Adaytum EP) is a very scalable system, all computing is client-side, nice workflow organization, [...]
As I’ve promised, here are naming conventions I tend to follow in EP projects. Setting up naming rules doesn’t seem so crucial at project start, but generally hits on you on the head on final phase, when development turns to support. And trying to support your colleagues model will leave you thinking about naming objects [...]
In the old times, before SliceUpdate first appeared ) we’ve thought that one thing analyst lacked to be really all-in-one tool was ability to do loops. For, while, until — all that nice stuff. And when SliceUpdate was introduced it became clear that @Test(Restart) allows you to cycle macro execution on whatever basis. Using @Test(Restart) [...]
In 8.2 we’ve got incremental publishing, allowing us to create real-time reporting on contributor data and that sets up new frontier in model data transfer speed. Now the slowest part of models are administration links (who’d guessed that when 7.3 appeared). Here are some ideas of how to speed admin links up, using the same [...]
Since I’ve got a couple of questions considering how to do it, I’ll get in more details on setting up Event Manager to detect application changes. See original post, and mind the second PS, especially. Some background: datadatetime column in nodestate table of application database is changed when user saves data, so we want to [...]
Difference between layouts is obvious:1 View-only is akward, old and slow (no dimensions for publish, blobs for value storing etc) 2 Table-only is modern, smooth and fast (dimensions, option to specify data types for publish and more) But I just cannot understand why annotation_user table is created only in View-Only mode. This table contains precious [...]
Nowadays Cognos EP system should look like a set of Contributor Applications exchanging data. That’s an axiom, refer to Cognos Since we have these numerous apps, we need to transfer data between them. And we got 2 variants: 1 Get Data extension — a very nice feature (especially with system links) allowing us to locally [...]
Remember me whining about absence of allocation cubes with elist in Contributor? Well, I kinda remembered the trivial solution. I wanted dynamic profiling of expenses, for example. Like profiling Year Summs on Linear driver, 4 4 5 or smth like that. And this choice should be done by user “on flight”, in the application. Like [...]
One of the main things I carried out of my alma-mater is passion for data. When you’ve got data, so many interesting things can be done . Various analysis, comparison, stats – just givŠµ the data. That was a rather pathetic preambula. Let’s get straight to business. Problem. On recent project I was doing some [...]