Tip of the day: Having common metadata layer for BI and Enterprise Planning is really cool, especially with the ability to load data from BI packages to EP via links. Just that it sometimes doesn’t work. But there are always some workarounds. With mostly very cryptical error messages or without any. One of the problems [...]
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, [...]
I already wrote some notes on choosing dimension for publish in this post. Today I just want to add some of points: 1 If you’re up to publishing some serious amount of data, variant with adding a dummy dlist with 1 item and using it as dimension for publish seems a very bad idea. You’re [...]
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 [...]
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 [...]
There are some situations when you definitely need some way of recognizing new input from user. These are rather rare occasions, but when it’s nice to have such a tool is sack. One of the applications was discussed in this communities topic. By the way, I’m spending much time on communities these days (it’s a [...]
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 [...]
I’ve nicked the term “Multi-Line” model out from some cognos best practices presentations. Never known it was called that way ) Multi-Line is only way to go when you have a potentially huge dimension only a tiny bit of which should be available to end-user at a time. Like employee planning, whole dimension of 10k [...]
A common question of ep admins is: “How can I see all users currently logged into planning wrt applications they’re using?” Something like: “Steve is now editing Capex and Sales Planning, and Mary is the only one in HR application now”. The task relatively simple for 1 application (yet required view publish for version prior [...]