Skip to content

Tag Archives: bi

More on real-time reporting on Contributor

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

Posted 08 November 2007 † ykud § bi § cognos § contributor-only § ep cookbook ‡ Comments (7) ° Also tagged: , , , , ,

Some EP + BI tips

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

Posted 04 October 2007 † ykud § bi § cognos § ep cookbook ‡ Comments (1) ° Also tagged: , ,

Cognos “Real-time” Reporting on Contributor Data

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

Posted 21 August 2007 † ykud § cognos § contributor-only § ep cookbook § tips ‡ Comments (6) ° Also tagged: , , , ,

Cognos BIO-130 Certification

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

Posted 16 July 2007 † ykud § bi § cognos ‡ Comments (5) ° Also tagged: ,

Cognos 8 BI Measure Prompt

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

Posted 22 May 2007 † ykud § bi § cognos ‡ Comments (4) ° Also tagged:

Cognos BI 8.2 simple pleasures

Now there is an Event Manager task “Start planning macro”, allowing to run Analyst Macro. Did I just heard a “tight integration” whisper…

Posted 26 March 2007 † ykud § bi § cognos ‡ Comments (0) ° Also tagged: , ,

Failed Dozen of BI-revolutions

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.

Posted 03 March 2007 † ykud § BI&CPM ‡ Comments (0) ° Also tagged:

Analysis Studio Cube Swapping

After creating cube in Transformer you place on Cognos 8 as a data source, to allow everyone to access it. But since the reading process of Cognos 8Bi opens mdc cube file on file level, it locks and the problem of updates arises. No way to update a cube while it’s locked. There are two [...]

Posted 22 January 2007 † ykud § bi § cognos ‡ Comments (0) ° Also tagged: , , ,