Cognos Archive

Performance Tip: Use Static Prompts

If you have any prompts on a report, chances are that they include a time reference prompt variable like year and/or month. In most cases they refer to a time dimension table or similar

Performance Tip: Run Prompts Upfront

Run Prompts Upfront. In most data warehouse environments, data does not change during the day. This means prompt values do not change during that period. So it is a waste of time and server

What happens when you run a Cognos report?

What happens when you run a Cognos HTML report in compatible query mode on a relational data source? Rather a lot actually. The ability to create reports in IBM Cognos that excel in performance

Manage Translations in Framework Manager

Managing translations in Framework Manager can be a bit of a hustle. This post describes a handy way of keeping track of your translations and avoiding frustrating rework. The solution is based on a

What’s new in IBM Cognos BI 10.2.1 (Part 1/2)

What’s new in IBM Cognos BI 10.2.1:¬†Synopsis This post describes what’s new in IBM Cognos Business Intelligence 10.2.1 compared to version 10.2.¬†IBM Cognos 10.2.1 is more than just a maintenance upgrade. It is not

IBM Cognos TM1 Licensing Simplified

This post explains the different licenses of IBM Cognos TM1. Hopefully it can be helpful in choosing the right combination of licenses. This post about TM1 Licensing is for version 10.1.1, but the concept

How to get a Boeing 737 seating plan in Cognos

Since a long time I’ve had this itchy urge to do something more graphical in Cognos. Tables and crosstabs is all nice, but it seems so old fashioned. Today, if you want to get

Enable WebDAV for Cognos using Apache

I don’t know why, but when you install Cognos and you want to use pictures, it’s not available out of the box. You always have to fiddle around with web server settings before you

Creating a simple Framework Manager model

If you are a seasoned Framework Manager user then you will learn absolutely nothing from this post, zero, zilch, nada. If you are new to creating Framework Manager models then this post is a

IBM Cognos BI licensing simplified

This post explains the different licenses of IBM Cognos Business Intelligence. Hopefully it can be helpful in choosing the right combination of licenses. This is for version 10.2, but the concept is equally true