Tag Archives: ep

Cognos BI and MS SQL — not meant for each other?

We’ve encountered an annoying Cognos 8 bug recently. 
Usual scenario if you’re creating reports over Enterprise Planning data includes “unioning” data from several applications. 
For example, you have an Operating Expenditures planning application and a Sales Planning application. To make a simple P&L, you just have to show up data from both these applications. So you can [...]

A couple of small, but oh-so vital Cognos Enterprise Planning Enchancements

Why am I writing this?
Well, sometime it helped and we now have allocation tables in administration links. Although I’m sure my post didn’t have any impact, some deem hope remains
I’m going to repost this into Communities and into Insight. And, maybe, we can create some noise by voting for these enchancements in Insight aka registering [...]

New Cognos Planning is finally out

With so-long waited new Contributor client, with expand\collapse and nest dimensions features. And a lot, lot more. ActiveX free ) Actually, as long as I’m with cognos ep (since adaytum 2.4), contributor was always the same good-old-rigid tool, so it’s a revolution indeed.
Well, with a huge lot of bugs inside, it’s time, gentlemen, to power [...]

More on choosing Dimension for Publish

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 terribly slowing [...]

Admin Links from Package troubles

A lot of work stops me from investigating it further, but I’ve experienced some errors in admin links (dlinks) from cognos package when data contained double qoutes (”).
I guess, this is due to the fact that package links generate an xml mapping file (source to destination) which contains lines like
and this file is then [...]

Modeling transactions in Contributor

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 [...]

Cyclic calculations in Analyst or “Make yourself an own @SliceUpdate”

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) allowed [...]

Ways of calculating Running Count to import data into Multi-Line models

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 people, [...]

Contributor Audit Reports

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 to 8.2, [...]

Incremental Publish in EP

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.

FireStats icon Powered by FireStats