Cognos cookbook. EP and BI advices.

Some kind of posts index by topic. For some posts I'm marking applicable versions of Cognos.

Enterprise Planning.

Overall Design Principles

Objects naming convention

Analyst

Dimension Order Example
D-list formated elements and calculations.
Breack-Back across multiple hierarchies
Analyst Break-Back explained
Loops in Analyst Macros
More on Loops in analyst -- making an own version of SliceUpdate
@AddLocalPreselection Macro
Analyst HotKeys

Contributor

Modeling transactions in Contributor & an example of implementation
Generating dynamic Access Tables using @Time macro
Virtual Dims Example: Contributor Allocation Cubes
Job servers cluster checklist (prior to 8.2)
Memory Leaking in Contributor (prior to 8.1 releases)
Contributor Log Analysis

Contributor-Only

Making "Contributor-only" Systems, the ones with Analyst-functions reduced only to administrative tasks (managing assumptions, dlists, allocations etc.), no "data crunching" in Analyst anymore.
Send Data vs Get Data
More like a wish-list for Cognos
Send Data and Access Manager

BI

Adding measure prompt into reports
Dimensionally Modeled Relational: Pros and Cons
Debugging Drill-Through (prior to 8.3)
Creating a Transformer load-balancing cluster
PowerCubes swapping (prior to 8.3)
Calculating trend line in Cognos Report Studio and Oracle

EP + BI

Real-time BI reporting on Contributor Data
More on real-time reporting on Contributor
EP + BI Tricks
Some more on choosing dimension for publish
Event manager usage

Integrating Cognos with other systems:

Importing data into Enterprise Planning MultiLine models, ways to calculate running-count in Cognos

Implementation Tricks. Discussion topics&examples

EP Project file structure
Analyst-Contrib Data Flow Organization -- it should be somehow different nowadays, "Contributor-Only" reigns
Currency Handling
Sales Planning, Large Dimensions Handling

FireStats icon Powered by FireStats