Cognitive Information

Business Intelligence Forecasting in SQL and Cognos

Note: This article is an update of a presentation given when I was at the University of Oklahoma’s Health Sciences Center. At that time, I was using Cognos version 7.3. This article is updated for Cognos 10 and SQL Server Analysis Server 2012.  Revisiting this subject ten years later, my opinion is that Microsoft has […]

Cognos 10 – First thoughts

Cognos 10 rolls out with lots of hype and promise. Here are my initial thoughts after viewing the demo.

Hiding Crosstab row titles in Cognos 8.4

A workaround to hide row titles in Cognos 8.x crosstab reports.

Calling Cognos reports with URL parameters and removing headers

When building dashboards with jQuery objects, there may be issues calling the report within the Cognos Portal Pages ‘Cognos Viewer’ object. The workaround is to use the ‘HTML Viewer’ in a portal page. The HTML Viewer is actually an iFrame calling a new instance of Cognos and may require re-authentication. The method we ended up […]

Add a custom chart palette to Cognos.

While Cognos does many things well, most people have different tastes in colors.  This article will walk you through creating and installing a custom chart palette.  This example is for general charts, but the principles can be applied to maps and gauges in the same XML files. Example Charts ‘Before’ and ‘After’ 1. Choose your […]

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: