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.
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.
Ironside helps companies translate business goals and challenges into technology solutions that enable insightful analysis, data-driven decision making and continued success. We help you structure, integrate and augment your data, while transforming your analytic environment and improving governance.