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) [...]
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 [...]
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.
Christmas present for us — Cognos EP 8.3 is out. A question for me now is: What will happen to Access Manager, what’s his future? I’ve heard rumors about discontinuation of development\support in near future, I know that some readers have better internal access, so could you please clarify the issue somehow? So we can [...]
Go out and download. I assume it a stabilizing release, polishing 8.2 bugs (we’ve ate plenty of them in past couple of months).
I’d like to collect some scenarios of how Event Manager can leverage your Planning process, to recognize patterns later and be sure what to propose.It’s like a brain-storm, feel free to add your comments. And there it goes: 1 Automatic publishing of updated data – see here, and here2 Sending mail notifications of budgeting period [...]
I’m afraid that design post was too dense and somebody just missed this useful technique of managing time-related stuff.Using @Time you can get current date and therefore update allocation table importing fact data to include current month. Or lock the past quarter in application, since i’s budget is already accepted.See cognoise theme for an example.
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 [...]
Just a rule to follow. Create time dimension so that detail item iids are consistent\meaningful and then add all summary items. So then in common Months dlist you’d get 1-12 for months, 13 for “1 Quater”, 14 for “2nd Quater” and so on. That will allow you to use simple time arithmetics in dlist formated [...]