CA11: Prospective Cognos 11 or Cognos Analytics

Cognos 11 or Cognos Analytics, as it’s been renamed now, is IBM’s latest enterprise release for the Business Intelligence platform.  The first thing every prior Cognos user will see is the completely new web interface (see below). One of the main reasons for this new interface is to bring an “any-device” interface to the consumers. …

Read More

QlikView: Nested If Statements

It is best practice to design QlikView apps (or any BI application for that matter) in a way that presents the information in a clear and concise manner, so that users can spend their time and energy on analysis rather than wondering what it is they are actually looking at. Here is an example. I…

Read More

CA 11: Themes and Extensions

Themes and extensions are a great way to customize your Cognos instance.  The overall theme of Cognos can drive user adoption by instilling confidence that the tool was tailor-made for a corporations solution. In previous versions of Cognos, changing the theme of Cognos was a bit trickier. It would require the source CSS files to…

Read More

Qlikview: Creating a Master Calendar

When using dashboards, time is almost always an important factor. Users will always be interested in viewing data by time period, and often times comparing data between two time periods. In a typical data warehouse a time dimension is usually present. If there is a situation where a time dimension is not available, then it…

Read More

Qlik Sense: Using Fuzzy Searches

With Qlik Sense, you can now search Records to find data that matches, or kind of matches, a search criteria. This is known as fuzzy searching.  A fuzzy search compares the original searched string to each record and determines its degree of resemblance.  The results of these searches are ordered in degree of resemblance order.…

Read More