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, [...]
I’m more than just emotional right now since I’ve finally got that bugger of my neck.
To those who’re interested in getting trend calculated in oracle — press page-down once.
Trend line calculation in Cognos.
It’s 2008 as my desktop calendar says and it’s “Targeted information to a broader range of users ” on top of the Cognos [...]
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, [...]
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 detect [...]
New Supportlink’s article on EP+BI led me to my 2cents on EP + BI integration topic:
Carefully select dimension for publish.
- Its elements will become columns in published table, so if you want database only processing, you’d be able to preform complex calculations (mean, percentile, variance) only on those columns. By adding local processing you [...]
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 data. [...]
I’ve tried to pass Cognos BI Modeler exam this weekend and failed. That leaves me rather disappointed and anxious for another try.
Some notes and comparison with EP certification:- BI Modeler is way faster (~110 questions in 2,5 hours vs ~135 in 3,5 for EP)- BI Modeler is problem oriented (most questions consider sql\modeling problems, [...]
Using Dimensionally Modeled Relational (or DMR’s) for reports in recent projects, I’ve come over a requirement for selecting a measure for display via value box prompt fo crosstabs. It’s very simple with dimensions (let’s forget MUN’s and etc) but not that straight-forward with measures. I did the first thing that came to my mind, maybe [...]
Now there is an Event Manager task “Start planning macro”, allowing to run Analyst Macro.
Did I just heard a “tight integration” whisper…
I really liked “The missing ‘Next Big Things’” by Nigel Pendse and Carston Bange, so I translated it to Russian and it’s available there on CitForum.
Just to spread the word.
Powered by FireStats
on 
on 
