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

The Ironside Group, Inc. is pleased to announce that we will be speaking with our customer, Grasshopper Group, a provider of a suite of products that entrepreneurs love to use and helps them get over some of the initial hurdles of running a business, as the keynote presentation at the December 8th Midsize Business Analytics Virtual Summit. Grasshopper will be offering insight into their experience with us and with Cognos Express. As an attendee, you will gain insight into Grasshopper’s self-service reporting implementation and strategy, which has significantly improved organizational efficiency. The Midsize Business Analytics Virtual summit is an amazing opportunity to see what’s new with Cognos Express without leaving your desk. IBM will be unveiling the newest capabilities of their Cognos Express Reporting, Analytics, and Planning software, purpose built for small to mid-size companies. Sign up and join us at the Keynote presentation featuring Grasshopper and Ironside on December 8th.

Business Intelligence tools have been one of the most prolific software investments for many organizations in the last decade; from Fortune 100 companies to small 100 person organizations. Providing historical, current, and predictive views of business operations, BI tools offer limitless possibilities within your organization. From analysts identifying and analyzing opportunities and trends to helping business decisions makers such as CEOs and CFOs to quickly review and understand business issues, a well designed BI application can provide significant ROI to your corporation. Read more

Cognos 10 was released on October 25th, with much fanfare (and fireworks – quite literally) at IBM’s Information on Demand conference in Las Vegas. I’ve been exploring the interface and feature set within my own test environment the past few days and here are a few early conclusions, including what I would consider to be the top three high-impact features of this release. Read more

Like any system or application you are using, performance is one of the most important factors in successful adoption by the user community. As for IBM Cognos users, optimal performance means that their reports run fast and without error;  for system administrators like you, it means that the Cognos environment is stable and that the users are happy. That being said, there is no question that performance tuning is always on a system administrator’s must-do list. By properly tuning the IBM Cognos configuration settings of dispatcher and services, you can optimize the speed and efficiency of the IBM Cognos server. Read more

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