Investing in a robust enterprise business intelligence platform like IBM Cognos can be a gateway to improving your organization’s performance in a multitude of ways. One such area of improvement which cannot be dismissed or overlooked is to respond to the call for greater corporate social responsibility. We now live an age where achieving success is no longer measured in simple dollars and cents alone, but also by how large and indelible a mark we leave upon our surroundings in the process. We have already begun to realize the directly proportional relationship between the sustainability of our success and that our own environment.
Read more

Most companies that invest in Business Intelligence technologies do so with high expectations of better decisions, more efficient processes and decreased cost. Others expect increased insight into spending, competition, and customer behavior or employee performance. The simple fact is that many BI implementations do not deliver on their expected value. Read more

Editor’s Note:  This blog was originally posted on August 1, 2010 and has been reviewed and updated on 10/5/2020 with Cognos Analytics 11.1.7.  We find that these best practice tips about metadata modeling are still very useful to build solid data foundation for reports, especially cardinality settings and stich query controls as they are critical modeling techniques. These procedures are also applicable to Cognos new web based metadata modeling component – the Data Module, which is greatly adopted by self-service authors and when Cognos is hosted in cloud (no need to install Framework Manger tool).

Last month’s article described the overall approach for best practice model design using the 4 layer architecture. In this month’s article, I’ll describe some advanced issues which arise during model design, and how best to deal with them. Given the limitless and complex situations that can come up during modeling, these techniques may or may not apply to your specific situation. Read more

The IBM Cognos Forum and IBM Information On Demand 2010 will be jointly held this year in Las Vegas, Nevada from October 24-28.

Through our Premier Partnership with IBM, the Ironside Group is able to offer an amazing discount: $400 off each IBM IOD / Business Analytics Forum registration. Simply enter the Ironside Promotion Code G10IRNSIDE at registration to receive your promotional discount.

Read more

For those starting out with Cognos 8, or even those who have worked with it for quite a while, Framework Manager model design can seem like a daunting or even overwhelming task. With so many options available, it can be hard to know what to consider during design, and how to promote stability and sustainability.

This is the first in a two-part article that will focus on the best practices, organization and overall methodology of Framework model development. As is often the case with complex tools, even developers who have worked with Cognos for a while can be confused on at least some of the concepts and considerations of model design. The focus of this first article will start from the beginning, and describe an overall 4 layer approach, detailing the purpose and reason for each of the four layers. Next month’s article will describe advanced best practices, and other tips. Read more

During 2009, IBM Cognos introduced Cognos Express, its one-stop BI and planning solution purpose-built to meet the needs of midsize companies”. While large organizations have been implementing Business Intelligence solutions for years, mid-size organizations were often left in a quandary wondering whether to spend time and money on a solution that did not necessarily fit their needs. With a more streamlined implementation, web and excel based interfaces, and attractive pricing, Cognos Express is a promising step in closing the gap between mid-sized companies and enterprise Performance Management Software. Read more

As consultants the first question we are often asked by our customers is can we build reports directly against our transactional systems.    While there are some exceptions our general best practice is to recommend against this type of architecture.

The reasons are long and detailed, but simply put, some high level reasons not to build reporting systems off of normalized databases are:

  • Query performance
  • General production system performance
  • Aggregate view of data vs transactional view
  • Complex SQL
  • Normalized databases are typically tuned for simple queries

The discussion then leads to questions surrounding data mart or warehouse creation.  Typical initial concerns are time, money, maintenance, and flexibility. All which are real considerations when traveling this path.

Read more

There is a growing need to provide more dynamic and interactive reporting for technically savvy consumers that have elevated expectations for how their data should be presented to them. With the arrival of IBM Cognos 8.4 comes Cognos Mashup Services, an API that empowers us to build modern looking and feeling web applications using IBM Cognos Reports as a data source. But what do you do if you want to deliver that sort of functionality within Cognos Viewer? The following presentation describes how you can leverage the powerful open-source JavaScript library jQuery to add dynamic user interface elements to your reports or provide functionality previously unavailable. Demonstrations include dynamically filtered and sortable list reports as well as drill-down enabled Tree Map data visualizations.

Download the presentation for Creating Dynamic IBM Cognos Reports with jQuery

The relationship between the report developer and report consumer often times have very little definition, with neither side having a concise picture of the best alignment of roles and responsibilities. The report developer has a clear understanding of the capability of the tools whereas the consumer may not. Conversely the consumer has a unique understanding of the business while the developer may not. When this disconnect is not addressed, the value of your BI tool may not truly be realized. Read more

In a time of financial instability, corporate investments must be thought out very carefully. That said, some investments can offer benefits almost immediately after implementation. There is one that can help you increase operational efficiency, harmonize departmental reporting, and provide immediate and up-to-date insight on your business at the click of your mouse. This investment gives you access to view the many different perspectives of your organization’s most crucial asset: its data. Read more