Over the next few months we will be bringing you a number of articles on the new capabilities found in Cognos 10 (last month: IBM Cognos 10: Initial Thoughts and Reactions) with a goal towards providing our fellow developers, implementers and users with our impressions and the associated benefits and drawbacks of the new tool.

One of the most discussed features of IBM Cognos 10 is the availability of Active reports, which has been billed as an ideal solution for managed dashboards aimed at Business Managers, Executives and Front Line users. As with all tools, there are a number of pros and cons that should be considered before making any strategic decisions around the implementation of new functionality. Read more

In the past, we have introduced techniques around dynamic prompting by utilizing a number of Cognos Report Studio built-in features. Occasionally there are scenarios that will necessitate the need to set a report parameter without prompting the user to select a value. For instance, there may be a case where the report developer needs to pass both the selected year and the previous year to a stored procedure or pass in a calculated prompt value that would be based on previously selected prompt values. While there are a number of solutions for such scenarios, in this article we will focus on a Javascript based technique to provide the necessary functionality. 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

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