Reporting should start with a “single source of truth” and end with a “single version of truth.” Delivery of accurate reporting information is paramount in the day-to-day operations of every organization. Some of the methods for maintaining data Integrity (within the data warehouse) would be to apply referential integrity and maintain primary keys on tables. In addition, associated ETL processes can utilize checksums, or record counts, when loading the warehouse. Once the data is in the warehouse, the next step would be to model the data for exposure to the end-users. Read more

For an updated version of this blog post using IBM Cognos Analytics 11.1.7, click here.

For users of IBM Cognos Workspace Advanced (formerly Business Insight Advanced), a popular request is to have the ability to highlight every other row in a list report. This technique has been demonstrated with IBM Cognos Report Studio using the running-count() and mod() functions. The issue is that IBM Cognos Workspace Advanced does not expose all functions that can be used in query calculations, so users think they are not available.

This article will demonstrate how to highlight every other row using IBM Cognos Workspace Advanced by entering a ‘non-exposed’ function in the expression editor (the twist!). Read more

IOD 2012 was once again another successful and productive event for the Ironside Group! We want to personally thank those who stopped by our booth during the conference and we hope that you had an educational experience at IOD 2012.

On Sunday, October 21st, the Ironside Group won an IBM Business Analytics Circle of Excellence Award at the Business Partner Summit where we were highlighted for our work with customer, By Appointment Only, (BAO, INC.) You can view the entire presentation here, and view the segment where our work was recognized at 13:59. Click here to read more on how we helped BAO, Inc. improve their sales by 25%. Read more