IBM Cognos

IBM Cognos Analytics – Conditional Notifications

Recently I was asked by a client to setup notifications for a daily report output. This is a routine request that can be addressed within the Cognos portal by creating and scheduling a job for the report. The unique challenge presented in my case however was that the client wanted results to be emailed to one set of recipients under a different condition than that

Read More »
Qlik

Getting to Know You – Raw Data Exploration in QlikView

When faced with a new dataset, one of the first impulses is to get it into Excel to get a feel for it.  Occasionally the data set is too tall (too many rows) or too wide (too many columns) to effectively pull into Excel for quick and easy manipulation. If you’re lucky enough to have access to QlikView, you can make this task straightforward for

Read More »
BI Solutions and Technologies

Anatomy of a Metric: KPI Assessment for Analysis Application Design & Data Modeling

When designing quality analytics applications that meet the expectations and requirements of various business users, being specific can mean the difference between collaborative success and argumentative failure. Rising to meet the challenge of satisfying these varied roles can be daunting. Executives, Managers, Business Analysts, Application Designers, Data Modelers and Developers may all be involved. While each of these roles has a different perspective regarding the

Read More »
BI Solutions and Technologies

The Art of Business Intelligence

“If you know the enemy and know yourself, you need not fear the result of a hundred battles. If you know yourself but not the enemy, for every victory gained you will also suffer a defeat. If you know neither the enemy nor yourself, you will succumb in every battle.” ― Sun Tzu, The Art of War OK, so maybe getting a grip on your

Read More »

Make Report Maintenance Easier by Implementing these BI Development Strategies

To “Get it done” and to “Get it done well” are two entirely different things.  Both have merit and are appropriate under specific conditions.  A mission critical output under a strict deadline must be prioritized to “get it done” to meet the objective.  Often this approach has delayed consequences that the urgency of the objective justify.  When time allows, real advantages can be gained from

Read More »
Qlik Sense

Qlik Sense Task Failure Notifications Solved!

It can be quite useful to know when a Qlik application has failed in order to correct the issue and get your business users back up and running.  While QlikView has a solid task failure notification feature, Qlik Sense currently falls short.  Because there is no default facility by which to issue notifications for task failures in Qlik Sense (https://community.qlik.com/thread/157245), a third party solution must

Read More »
Uncategorized

When Values Aren’t Values: NULL Handling in Qlik

It’s funny how much trouble can be caused by nothing. Because we cannot see it, the absence of a value is often overlooked in a data set. In Qlik, missing values play a key role in representing relationships (or the lack thereof) between entities. It’s important to deal with them appropriately. When handling common cases of “nothing”, it’s worth consistently addressing zero length strings or

Read More »
BI Solutions and Technologies

Manage Framework Manager Model Changes

Managing change is difficult in any aspect of life, whether changing jobs, moving cities or simply adapting to the fact that Panera has done away with your favorite Cuban Chicken Panini (bummer, right?). Addressing changes in business critical systems can range from mildly annoying to down right time consuming depending upon several factors. How big your environment is, measured by the number of users, developers,

Read More »
IBM Cognos

A Report Developer’s Guide to Sanity

IBM Cognos Report Studio is a tremendously flexible and useful application for querying and presenting data in a multitude of forms. From crosstabs to graphs, details or summaries, sales reporting to financial statutory reporting, Report Studio is both powerful and versatile. Due to its expansive feature set and extensibility, every report developer will have their own approach to development. When inevitably under deadlines, even the

Read More »