IBM Cognos

2 Jun 2015

IBM Customers Can Get a Free Subscription of Watson Analytics Pro: Learn How

By | June 2nd, 2015|Categories: Business Solutions, Data Science|Tags: , , , |

IBM recently rolled out Watson Analytics Pro, a more feature-rich, subscription-based version of their free Watson Analytics platform. This new option adds some powerful new functionality to the already excellent base product, enabling subscribers to be more connected to their existing data sources and analyses, providing more storage space, and allowing for easy administration of [...]

24 Feb 2015

Case Study: Migrating Cognos from Series 7 to Version 10 with SDK

By | February 24th, 2015|Categories: Business Intelligence, Case Studies, Proven Practices|Tags: , , , |

Migrating Cognos is a highly involved process, especially when you're moving across multiple versions. When one of our clients needed this kind of migration completed, our experts turned to Cognos SDK to streamline the process and adjust the system to meet the client's needs exactly. Business Need The client for this project had been a [...]

21 Jan 2015

Tabbed Reports in Cognos 10.2.2: The New, Easy Way to Make Clean, Consumable Multi-Page Reports

By | January 21st, 2015|Categories: Business Intelligence, Reporting, Strategy & Innovation|Tags: , , , |

In Cognos 10.2.1 and earlier versions, the phrase that most accurately described a multi-page report was “wrestling match.” Long list reports would flow on for page after page until somewhere along the way you ran into that chart you knew you added but were starting to forget about. Defining page breaks helped some, but following [...]

15 Dec 2014

Ironside Tech Tip: Dynamically Selecting Filters Utilizing Before or After Aggregation via a Prompt

By | December 15th, 2014|Categories: Business Intelligence, Tech Tip, Training|Tags: , , , , , , |

 Synopsis: Enable a user via a prompt to pre-select if a value will be filtered before or after aggregation. Overview: Normally, the report author hard codes filters placed on facts in the Properties pane as before or after aggregation. While this is adequate in most report scenarios, hard coding can be limiting if the executing [...]

15 Jul 2014

Ironside Tech Tip: Creating a Burst Table for a Cognos Report

By | July 15th, 2014|Categories: Business Intelligence, Reporting, Tech Tip|Tags: , , , , |

Synopsis: How to create an external data file to use as a burst table for a Cognos report. Pre-Requisites: This article assumes familiarity with how to burst a report and how to use external data, and creating an external data package. Solution Summary 1) Create the external (burst table) data file using Excel (save as [...]

30 Jun 2014

Ironside Tech Tip: Leveraging Time and Aggregate Functions in Dimensional Reporting to Create Low Maintenance Cognos Reports

By | June 30th, 2014|Categories: Business Intelligence, Reporting, Tech Tip|Tags: , , , , , |

Over the years I have successfully used the ancestor(), parallelPeriods(), periodToDate(), aggregate(), and set() dimensional functions to develop robust and durable dimensional reporting solutions in IBM Cognos BI. I had the opportunity to go to lunch the other day with one of my clients from a few years ago and they told me that the [...]

11 Jun 2014

Ironside Tech Tip: Standardizing Prompt Names in Report Studio

By | June 11th, 2014|Categories: Business Intelligence, Reporting, Tech Tip|Tags: , , , , , , , |

Synopsis Define the technique behind and benefits of standardizing prompt conventions in Report Studio. Overview Report authors can easily create automatically generated prompt page prompts for data items in a report using the question mark syntax, as shown below: [Branch region] = ?br? Naming conventions for the alpha-numeric text between the question marks can be [...]

2 Jun 2014

IBM Cognos Solutions for the Self-Service Spectrum

By | June 2nd, 2014|Categories: Advisory, Business Intelligence, Business Solutions|Tags: , , , , , , , , , , , |

Due to the rapid pace of today’s business world, new strategies, products, projects, and tools are being introduced on a constant basis. This means that the speed of business often does not match the speed at which IT departments, which tend to have to follow rigorous testing and governance policies, can provide ways to measure [...]

20 May 2014

Ironside Tech Tip: Best Practices for Documenting Report Studio Reports

By | May 20th, 2014|Categories: Proven Practices, Reporting, Tech Tip|Tags: , , , , |

Synopsis: Three methodologies for documenting Report Studio reports. Overview: Reporting tools like IBM Cognos Report Studio do not naturally provide a means of documenting and commenting procedures like traditional programming languages do. As a result, once a report has been created, it may be difficult to follow the logic and design of the original report, [...]

Load More Posts