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, [...]
Finally, we’ve solved problem stated in communities. And Robert allowed me to publish resulting library here as well. See attached zip file. Problem statement We have 2 cubes, one containing product groups sales (for example) and the other containing detailed product data. Users should be able to correct overall group totals and correct detailed product [...]
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 [...]
Just found an excellent option “Table-only Publish Post-GTP” that detects changes that make incremental publish incompatible and republishes application. It should be set to “Yes” by default, imho. See how incremental publish can streamline your reporting in these posts: 1, 2.
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 [...]
Remember me muttering about array languages? Just in case, famous Jhost7.exe is a J language execution process. So every computation in Contributor is performed by array-processing J machine, packed to xml and held as a blob in nodestate table. So it’s APL in Analyst and J in Contributor. It’s really cool, because array processing is [...]
Usually these are the signs of coming disaster in an EP system: 1) too many dlists of the same “dimension”, some elements thrown out for cutting volumes, calculating or not calculating smth, and you have all seen them laying around just because they seemed to consistent at the time of creation. 2) manually maintained access [...]
8.2 makes many things nice&simple. To get a full budget report we need to do the following: 1) Publish the whole application 2) Run the report on published data Publishing a typical application of 100+ elist takes around 20 minutes, so no real-time here. But 8.2 introduces trickle publish, allowing to incrementally publish only changed [...]
Can you imagine such a Contributor Application: 2 Cubes (A&B for example), each linked to each other so that when you input a value in a cube A cell, corresponding cube B cell changes to that value, and when you input some value into that cube B cell (the very same changed), cube A cell [...]
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 [...]
on DMR’s pros and cons
on DMR’s pros and cons on DMR’s pros and cons
on DMR’s pros and cons on Macro functions and prompts in Cognos BI reports